It is possible to customize Sage CRM in different ways, to meet user requirement. There are many customization option in Administration. So in this Blog we are going to see how to create a secondary Entity for Standards Entity. Sometime if organization is using Opportunity entity to store all of their Projects in Sage CRM. It… Read More »
Hi folks! You all must be familiar with the following entities in CRM ”Email”, “Email Link”, “Person” ,“Person Link” ,”phone” and “Phone Link“ table .These are the tables where person’s and company’s communicated related details are saved. But when you want to check one of these details in database for the related company or person… Read More »
Ideally speaking this will not be an out of box feature that everybody needs in CRM, however I came across many such requirements these days where people either wanted to use id fields on the screen as unique reference values. Some just wanted to display them on the screen for viewing purpose. Some wanted to… Read More »
Last weekend I got a chance to visit a holiday resort by the lake side. It was just heavenly with the silence and peace, to be woken up in the morning by the chirping birds rather than the blackberry alarm, trekking, swimming. Ahhh! Just awesome. The hectic life in the city does make you appreciate… Read More »
Primary keys in SQL tables allow us to uniquely identify the rows. These keys also allow us to establish the relationship between tables based on foreign key-primary key concept. Though we can have different id field names in CRM tables, the standard primary key feature is well maintained with field names like “_” (e.g. Case_CaseId).… Read More »
If we make use of the Tab groups in custom pages for the custom entity, sometimes we get unnecessary crashing errors after clicking on tab twice. Using this script you can restrict user not to click tab again, once the page is submitted. You can mould this script for any content according to your requirement.
Below is an example of a SQL query which you can use in a scenario where you want to display a list of duplicate records which are stored in a particular table. Below is the query that has been used to do the needful on the Leads entity (where Client wanted to have the list… Read More »