Sage CRM has proved beneficial for small or medium sized companies to handle the Customer Relationship Management in an efficient way. The base structure designed in the system itself is so easy to understand as well as promising that the system users will be equipped with all the information related to the Customer in a… Read More »
Sage CRM has numerous built-in functionalities which helps to manage Customer Relationship all through a single system. Be it recording Customer data, capturing Enquiries, tracking support cases or maintaining follow-up data. Sage CRM’s Email functionality helps in managing both the inbound and outbound communications with ease. But have you ever noticed these Email Communications fails… Read More »
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 »
Table Level Scripts (TLS) are an alternative method of creating SQL triggers that can be performed in Sage CRM system. Table Level Script (TLS) are used to perform various operations after inserting records, updating or deleting records in Sage CRM. To perform operations, it is necessary to fetch the primary ID of the current entity in… Read More »
In SQL we use “Triggers” to handle some activity after insert, update and delete operations on some SQL records. Sage CRM provides a similar option within the application in the form of TLS (Table Level Scripts). The predefined events in TLS i.e. Update(), Post Insert(), Delete() and Insert() allows you to have operations on insert,… Read More »
Worldwide developers face this that they have to write longer and longer Table Level Scripts to make business logic work and a single issue will force them to create multiple Component files again and again to modify the TLS. I wonder if anyone knows there is a way to avoid this nuisance by using simple… Read More »
For handeling any of your Post Recod insert activity the very first option that comes to your mind is the Table Level Script. You can make use of PostInsertRecord function in order to handle the Post Insert Record activities. It is quites simple to make use of this standard functionality provided by Sage CRM, but… Read More »
Are you facing Timeout Error for Table Level Script which makes extensive use of SQL SELECT statement??? To find the resolution to this problem, please try to run your query in SQL backend using query window. Analyze the query and see how much time it is taking through SQL. If the fault is in query,… Read More »