1.0Sage CRM – Tips, Tricks and Componentshttps://www.greytrix.com/blogs/sagecrmTable Level Scripts - Sage CRM – Tips, Tricks and Componentsrich600338<blockquote class="wp-embedded-content" data-secret="5etfTofdkn"><a href="https://www.greytrix.com/blogs/sagecrm/2011/08/02/table-level-scripts/">Table Level Scripts</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.greytrix.com/blogs/sagecrm/2011/08/02/table-level-scripts/embed/#?secret=5etfTofdkn" width="600" height="338" title="“Table Level Scripts” — Sage CRM – Tips, Tricks and Components" data-secret="5etfTofdkn" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
/* ]]> */
</script>
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 »