{"id":1715,"date":"2012-04-06T13:01:42","date_gmt":"2012-04-06T13:01:42","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=1715"},"modified":"2012-04-06T13:01:42","modified_gmt":"2012-04-06T13:01:42","slug":"access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/","title":{"rendered":"Access field value from database and display the same on the screen using client side script"},"content":{"rendered":"

Consider a scenario where we need to populate a field value from another table to Company Summary screen. To achieve the same we need to access the database to get the field value and then display the same on the screen.
\nFor example FinalTotal<\/strong> is a field in any other table in CRM. You want this value to be populated in field on Company summary screen i.e. comp_finaltotal<\/strong>. The easiest way to do this will be as follows.
\nEdit the company summary screen from customization section. On the Create script section of field comp_lastyeartotal put the below script.
\nvar FinalTotal = 0;<\/em>
\nvar qryfinaltotal = \u201cselect finaltotal from < your table name > where < whereclause >\u201d;<\/em>
\nvar recfinaltotal = eWare.CreateQueryObj(qryfinaltotal);<\/em>
\nrecfinaltotal.SelectSQL();<\/em>
\nif(!recfinaltotal.eof)<\/em>
\n{<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FinalTotal = recfinaltotal (\u201cfinaltotal\u201d);<\/em>
\n}<\/em>
\nCaption = \u201cLast Year:\u201d + \u201c< input type=hidden id=hdnlstyr\u00a0 name=hdnlstyr\u00a0 value=\u2019\u201d+ FinalTotal +\u201d\u2019 >\u201d<\/em>
\nThis script will push the value to the hidden variable hdnlstyr<\/strong>.
\nThen on the Custom content area you can access this value from client side script as given below.
\nvar FinalTotal = document.EntryForm.hdnlstyr.value;<\/em>
\nYou can use this value to whatever field you want from client side java script.<\/p>\n","protected":false},"excerpt":{"rendered":"

Consider a scenario where we need to populate a field value from another table to Company Summary screen. To achieve the same we need to access the database to get the field value and then display the same on the screen. For example FinalTotal is a field in any other table in CRM. You want\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":[155,332],"tags":[],"class_list":["post-1715","post","type-post","status-publish","format-standard","hentry","category-fields","category-sage-crm"],"yoast_head":"\nAccess field value from database and display the same on the screen using client side script - 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\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Access field value from database and display the same on the screen using client side script - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Consider a scenario where we need to populate a field value from another table to Company Summary screen. To achieve the same we need to access the database to get the field value and then display the same on the screen. For example FinalTotal is a field in any other table in CRM. You want\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-06T13:01:42+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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/\",\"name\":\"Access field value from database and display the same on the screen using client side script - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2012-04-06T13:01:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Access field value from database and display the same on the screen using client side script\"}]},{\"@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":"Access field value from database and display the same on the screen using client side script - 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\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/","og_locale":"en_US","og_type":"article","og_title":"Access field value from database and display the same on the screen using client side script - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Consider a scenario where we need to populate a field value from another table to Company Summary screen. To achieve the same we need to access the database to get the field value and then display the same on the screen. For example FinalTotal is a field in any other table in CRM. You want\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2012-04-06T13:01:42+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/","name":"Access field value from database and display the same on the screen using client side script - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2012-04-06T13:01:42+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/06\/access-field-value-from-database-and-display-the-same-on-the-screen-using-client-side-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Access field value from database and display the same on the screen using client side script"}]},{"@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\/1715","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=1715"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/1715\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=1715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=1715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=1715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}