An Email and Communication module is one of the most used features by Sage CRM users to manage and maintain customer relationships. In the latest release of Sage CRM 2022 R1, new features and enhancements have been introduced related to Email Templates. New Stuff: Sage CRM 2022 R1: Change Default Location of Log Files In… Read More: Sage CRM 2022 R1 – Resize table columns in the… »
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: Adding Secondary Entity for Primary Entity »
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: How Sage CRM changed Structure of Phone and Email in… »
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: Using Id fields of entities on screens and lists »
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: Open up hidden tables for editing in CRM. »
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: Identity increment in CRM tables »
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: Query to Find out Duplicate records in SageCRM Table »
