Easy way of identifying Team Leader in CRM

Escalations for the betterment of services are the need of today’s business. Along with this Mail communications and notifications to customer are also important, but by whose name they should be conveyed? Simple answer is by Administrator, however small organizations always try and maintain the communications at Team level where Team leader is responsible for… Read More »

Re-Installing the component

Re-Installing a component is nothing but installing a same component more than once. You know system does not list the component for installation once listed. We might need to re-install the component due to some changes done in the same component without losing the already applied modules e.g. If we have a component comp1 which is for… Read More »

Changing max allowable length of Text field using Jquery

In my earlier blog, I have explained how to restrict a length of Sage CRM text field on screen block using JavaScript. https://www.greytrix.com/blogs/sagecrm/2013/01/14/set-field-length-at-run-time-in-sage-crm/ Here is how you can achieve the same using JQuery. Here explaining the example with Company Name field on Company screen. 1) I have input text field on CRM screen with field… Read More »

Sort Dropdown list items using jQuery

Recently I came across a requirement from client wherein I have to sort selection fields alphabetically which comprise of approximately 400-450 selection options in it. If it would have been fewer records then probably I would have done it by going into CRM and then change the order of fields at the field level. So… Read More »

How to access views of Different Database in CRM

Recently I encountered a situation wherein I had to fetch records of Views and display the same, but from a database other than the CRM default database. It took some time to think about the way to accomplish my requirement and then after some researching I came up with the solution. The solution to tackle… Read More »

Mapping Component Issues

Recently while installing the Standard Mapping Component in SageCRM component manager, I encountered below error. As seen from the error message highlighted above its caused because of missing Clustered indexes on Company and Lead tables. I was a bit surprised knowing the reason of error as Indexes are by default defined on CRM database by… 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 »