Category Archives: Tables

Sage CRM 2022 R1 – Resize table columns in the Email Templates

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 »

Adding Secondary Entity for Primary Entity

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 »

Enhance a Custom entity list for loading results faster

Every new version of Sage CRM has provided with some or the other new features which has improved system stability, user experience, ease in third party apps integration and so on. Sage CRM 2018 R2 has come up with a new feature related to Custom entity, which has helped to load custom entities list faster.… Read More »

How to Exclude Auto-Opportunities created in Sage CRM?

Sage CRM’s Opportunities is the heart of every potential sale done with the Customer. These opportunities further helps to track/maintain the Quotations and Orders raised against the Sale. However, CRM’s feature of allowing the Users to create direct Quotes or Orders in CRM is also not left unnoticed, which can help the Users to maintain… Read More »

Get Size of all Tables in CRM Database

For any database driven application, it is very important that the database must be optimized to the best so as to deliver higher performance. As the data volume in database increases, load on the system also increases which affects the performance on the system which in turn affects the client’s business. For business application like… Read More »

Table Level Scripts Logging and Performance

In SageCRM, Table level script can be used for replicating SQL trigger like functionality.  Table level scripts help us handle the data update events properly and do corresponding actions within SageCRM. The beauty of it is we can use SageCRM API and write server side JavaScript like functionality to function similar to that of triggers.… Read More »