{"id":164,"date":"2009-07-06T12:04:00","date_gmt":"2009-07-06T12:04:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=164"},"modified":"2009-07-06T12:04:00","modified_gmt":"2009-07-06T12:04:00","slug":"writing-table-level-script-is-a-hectic-job-try-this-instead","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/","title":{"rendered":"Writing Table Level Script is a hectic job ? – Try this instead…"},"content":{"rendered":"

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. <\/p>\n

I wonder if anyone knows there is a way to avoid this nuisance by using simple Java Script file instead of the Table Level Scripts. <\/p>\n

How !! <\/p>\n

For this we need to create a new Key in Registry of Current CRM. <\/p>\n

Have a look at below steps:
1. Go to Registry editor and open the registry for current CRM installed on your System.
2. Most Probably you will find this at My Computer -> HKEY_LOCAL_MACHINE -> Software->eWare->Config
<\/strong>3. Select the Instance name of your CRM.
4. Right Click on Instance Name and click on New -> String Value<\/strong>
5. Put the Name of key as \u201cScriptCommonFunctions\u201d<\/strong> and Save.
6. Double click on the newly created Key and it will open an editor.
7. Put the path of JS file here. It is required that this JS file should be in your CustomPages folder. For Example if you\u2019re Custom Pages resides at C:\/Program Files\/Sage\/CRM\/\/WWWRoot\/CustomPages.
Then your new folder for JS file should reside in Custom Pages. <\/p>\n

My JS files Name is \u201cSampleJSTLS.js<\/strong>\u201d and it resides in folder name \u201cSKIPTLS<\/strong>\u201d which is in Custom pages folder. So for the Key \u201cScriptCommonFunctions\u201d, I will put the value as \u201cSKIPTLS SampleJSTLS.js<\/strong>\u201d and click on OK. <\/p>\n

8. Now what we have to do is just define all the methods in this JS file and from TLS we just need to call them.<\/p>\n

The benefit of this is if any changes are required then we need not to change in CRM which will need to create a new version of Component file. Instead of that just do the changes in the JS file which is much easier to deploy at client end.<\/p>\n

Hope this helps. <\/p>\n

If you find this useful, Please drop us a mail on crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

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\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[853,2403],"class_list":["post-164","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-custom","tag-table-level-script"],"yoast_head":"\nWriting Table Level Script is a hectic job ? - Try this instead... - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Writing Table Level Script is a hectic job ? - Try this instead... - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"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\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-07-06T12:04:00+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/\",\"name\":\"Writing Table Level Script is a hectic job ? - Try this instead... - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2009-07-06T12:04:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Writing Table Level Script is a hectic job ? – Try this instead…\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Writing Table Level Script is a hectic job ? - Try this instead... - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/","og_locale":"en_US","og_type":"article","og_title":"Writing Table Level Script is a hectic job ? - Try this instead... - Sage CRM \u2013 Tips, Tricks and Components","og_description":"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\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2009-07-06T12:04:00+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/","name":"Writing Table Level Script is a hectic job ? - Try this instead... - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2009-07-06T12:04:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/06\/writing-table-level-script-is-a-hectic-job-try-this-instead\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Writing Table Level Script is a hectic job ? – Try this instead…"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=164"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/164\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}