Category Archives: Custom fields

How to add Custom Entities into the Regarding field of Communication

For every business, communication is the most important aspect that needs to be managed appropriately. As you all know, Sage CRM has helped to manage all the business related chores such as maintaining Customer database, managing Enquires and Opportunities of these customers, logging of service tickets, and scheduling appointments and so on. The communication records… Read More »

Generate Unique Reference Number in Custom Field using Workflow

In previous blog, we have seen that how we can call stored procedure from workflow action. Now, I will explain you, how we can use the same feature to generate Unique Reference Number for other entities like Case, Quote or Order. New Stuff: How to enable Export to Excel on Calendar List in Sage CRM? We… 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 »

Display List on Communication screen – Part II

In our previous blog, we have explained the functionality to display the list on Standard Communication screen by using HTML scripting. But, this time we will be explaining how to add communication list using JAVASCRIPT. New Stuff: Promoting Quote to an Order issue Here, we were asked by our customer to display past communication records regarding… Read More »

Tracking your custom fields in SageCRM

When it comes to progressing workflows, updating values in any entity of CRM Tracking is very much necessary. Being business software CRM handles very delicate data and we cannot afford anybody to just go and change anything. Hence the Tracking functionality has been provided by SageCRM out of the box. The New Stuff: Checklist for… Read More »

Sage CRM 7.2 Client Side API Adding columns to List at Runtime

Sage CRM 7.2 introduced a new powerful and simple way to use API for carrying out client side customizations. In my previous blog I had explained how we can hide and show fields using Client side API.  Below is the link for the same. New way of Client side field customizations In this blog I… Read More »

How the address is arranged over multiple lines?

In Sage CRM, you can see address of Person arranged over multiple lines as shown below. This is because the corresponding view under the Address entity is written as follows. CREATE VIEW vAddress AS SELECT ISNULL(rtrim(Addr_Address1), ”) +’ ‘+ ISNULL(rtrim(Addr_Address2), ”) +’ ‘+ ISNULL(rtrim(Addr_Address3), ”) +’ ‘+ ISNULL(rtrim(Addr_Address4), ”) +’ ‘+ ISNULL(rtrim(Addr_Address5), ”) AS Addr_Street,… Read More »