Category Archives: View

Highlight Date Column in Sage CRM Grid

We all know how we can add color to columns or rows of a list or grid using Sage CRM Api filterWhere condition. But if we notice carefully, a date field contains the value of Today or Tomorrow then it is displayed a “Today” or Tomorrow” in Sage CRM list/grid. So filterWhere condition cannot be… Read More »

Showing All Communications in Calendar List of Sage CRM 2018 R3

In the latest version of Sage CRM 2018 R3, many new functionalities are been added to it. We all are aware of the Calendar List functionality been introduced in Sage CRM 2018 R3. Calendar List allows us to view Communications created for a User in a more easy and responsive manner. It also allows sorting… Read More »

How to get SQL Query of Groups created in Sage CRM

In Sage CRM, Groups feature allows you to create, edit, and save lists of people, companies, leads, cases, opportunities, quotes and orders based on defined filter criteria. Groups are based on the SQL views generated by queries. The views that are used to create group’s needs to be designed such that each row should return… Read More »

Sage CRM 2018 R3: Create a group of Persons who have not responded to a Consent Request

In our earlier blog, we explained about the new feature introduced in Sage CRM 2018 R2 i.e. Consent. It helped to capture the global and local legislation surrounding people data, including the GDPR in Sage CRM. In this blog, we will explain how you can maintain tracking of those persons who haven’t responded to the… Read More »

Adding Custom Field on Sage CRM screen using .Net

Sage CRM provides System administrator with easy ways to add or remove fields from the system. Every screen and list in CRM draws its data from the views which are based on the SQL tables linked to a particular entity. Thus whenever a user needs to add a field belonging to a different entity, he… Read More »

Sage CRM 7.3 SP3 Enhancement

With the introduction of latest Sage CRM 7.3 patch i.e. SP3 they have come up with great enhancements in terms of UI/UX which has increased user experience. New Stuff: Display Distinctive Records in Reports Let’s see each of them in this blog. 1. Navigation Bar: The navigation bar is now more fit to screen and has… Read More »

How to give Name in Communication List for Attachment column

Hello everyone! As we know that SAGE CRM is enriched with number of functionalities such as maintaining Customer records, creating communications against customers, attaching documents in communication record, etc. The communication list also display records with attachment but it doesn’t allocate the “Column Name” to it. Can we give suitable name to the column for… Read More »

Identifying Views to Create Reports in Sage CRM

Reports module has been proved a very essential as well as important part of Sage CRM. Reports not only helps in getting a clear idea of the ongoing work but also provides an overview of the historical data from the past years. In every Business organization, Managers or the Team Leaders are very much concerned… Read More »

How to alter View Script Field’s Data Entry size in Sage CRM

As we all know, Sage CRM works on SQL views to return records in response to user searches and to present relationships between different entities. For example, a view might list all the cases associated with a particular company that are assigned to a specific user. Creating advanced user-defined views entails administrators employing SQL operations… Read More »

Send Auto – Festival Greetings through Sage CRM

In Sage CRM, Timings functionality has helped to track the duration of any entity record right from the time it is opened till it gets closed. For a more accurate measurement of duration, this information can be combined with a Business Calendar, which defines standard business days and work times along with Holiday Sets for… Read More »