Display On screen notification to Team rather than specific User

By | July 19, 2021

In Sage CRM, there are a wide range of different functionalities available. One of the most useful feature in Sage CRM is Escalation Rules. By using the Escalation rule you can perform numerous actions within Sage CRM such as displaying On screen notifications for users, send emails to customers, set certain column value, reset column value, execute SQL statement or run stored procedures, etc.  All these actions can be performed on Primary entities i.e., for Company, Person, Cases, Opportunity, Lead, etc. as well as for Custom entities in Sage CRM.

New Stuff: On-screen notification is not visible in Sage CRM

One of the client came up with the requirement where they wanted to trigger on screen notifications to all members of a team rather than a specific user. The reason for sending notification to the team was that as per the business process designed at a certain stage they wanted to involve the whole team rather than just an individual user.

In this blog, we are going to discuss about how to create an escalation rule that sends on screen notification to all members of a team rather than just an individual user in CRM.

To achieve the same just follow below few steps –

  1. To create on screen notification for the team just navigate to, Administration -> Advanced Customization -> Escalation and click on the new Button. Here we are considering an example of a Case entity.
  2. Add values in the necessary fields like Table or View, Rule name, Rule Enabled, Trigger SQL Clause, etc.
  3. Add below code “Trigger SQL Clause” field to show the on screen notification to the team.

case_deleted IS NULL AND Case_ChannelId=#C
Here, #C will return the current logged users’ team ID. You can refer below screenshot for your reference.

Code in Trigger SQL Clause
Code in Trigger SQL Clause

4. Now save the escalation. Once you save the escalation, users of the same team will get the on screen notification.

In this way with the help of the “#C” code in the Trigger SQL Clause, you can easily create an escalation rule that sends on screen notifications to all members of a team rather than just an individual user in CRM. You can even send on screen notifications to a team for custom entities if the channel Id field is created in the custom entity.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service SignatureSage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.