{"id":8629,"date":"2014-09-11T06:11:50","date_gmt":"2014-09-11T06:11:50","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=8629"},"modified":"2019-12-05T05:55:59","modified_gmt":"2019-12-05T05:55:59","slug":"linked-selection-fields-through-client-side-scripting","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/","title":{"rendered":"Linked selection fields through client side scripting"},"content":{"rendered":"

Today I will revisit one of the oldest, but very much useful tricks related to web forms. Most of the forms nowadays need relationship to be established between two fields. For example when I select Product interest in one list it should filter Sub product interest in another field. Today I will explain how this can be achieved on Sage CRM screens through fairly simple configurations and client side scripting
\nNew Stuff:<\/strong><\/em><\/span>  Sage CRM and IIS authentication settings<\/a>
\nLet\u2019s consider an example, in Person screen we want to filter \u201cSub Selection<\/strong>\u201d (pers_subselection) field based on the value selected in \u201cMain Selection<\/strong>\u201d (pers_mainselection) field. Before moving ahead we need to configure values in both this field using some logic so that it can be filtered easily using jQuery. The logic that I have used is the code value of \u201cMain Selection<\/strong>\u201d needs to be available in code of \u201cSub Selection<\/strong>\u201d field i.e. based on code \u201cA\u201d I can search \u201cA1, A2\u201d. When we define this logic in fields it becomes easier for configurations in case new options are getting added over the time. We don\u2019t have to go to server side for querying option values from translations in that case which means faster processing.
\n\"Image1\"<\/a>
\nAfter configuring the values, we need to add below syntax in the Custom content of the screen where we have added above two fields.
\n<script language=’javascript’><\/em><\/span>
\nif(window.attachEvent)<\/em><\/span>
\n{<\/em><\/span>
\n window.attachEvent(“onload”,FilterSelection);<\/em><\/span>
\n}<\/em><\/span>
\nelse if(window.addEventListener)<\/em><\/span>
\n{<\/em><\/span>
\n window.addEventListener(‘load’, FilterSelection, false);<\/em><\/span>
\n}<\/em><\/span>
\nfunction FilterSelection()<\/em><\/span>
\n{<\/em><\/span>
\n var options = $(“#pers_subselection”).html();<\/em><\/span>
\n $(“#pers_mainselection”).change(function(e) {<\/em><\/span>
\n var text = $(“#pers_mainselection :selected”).text();<\/em><\/span>
\n $(“#pers_subselection”).html(options);<\/em><\/span>
\n if (text == “–None–“) return;<\/em><\/span>
\n $(‘#pers_subselection :not([value^=”‘+ text +'”])’).remove();<\/em><\/span>
\n $(“#pers_subselection”).append(“<option value=” selected=true>–None–<\/option>”);<\/em><\/span>
\n });<\/em><\/span>
\n}<\/em><\/span>
\n<\/script><\/em><\/span>
\nAfter adding above script, you will be able to filter the values from above 2 fields as displayed in following screenshot.
\n\"Img\"<\/a>
\nHappy scripting!
\nAlso Read:<\/strong><\/em><\/span>
\n1) Sort Dropdown list items using jQuery<\/a>
\n2) Sorting Country Selection<\/a>
\n3) Dropdown Sync in Sage CRM System<\/a>
\n4) Changing max allowable length of Text field using Jquery<\/a>
\n5) Limit number of characters in Sage CRM fields<\/a>
\n <\/p>\n","protected":false},"excerpt":{"rendered":"

Today I will revisit one of the oldest, but very much useful tricks related to web forms. Most of the forms nowadays need relationship to be established between two fields. For example when I select Product interest in one list it should filter Sub product interest in another field. Today I will explain how this\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,200,219,267,332,357,373,1],"tags":[1143,1471,1532,1695,2259,2313],"class_list":["post-8629","post","type-post","status-publish","format-standard","hentry","category-fields","category-javascript-sage-crm","category-list","category-on-change","category-sage-crm","category-selection","category-sort","category-uncategorized","tag-fields","tag-javascript","tag-list","tag-on-change","tag-selection","tag-sort"],"yoast_head":"\nLinked selection fields through client side scripting - 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\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Linked selection fields through client side scripting - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Today I will revisit one of the oldest, but very much useful tricks related to web forms. Most of the forms nowadays need relationship to be established between two fields. For example when I select Product interest in one list it should filter Sub product interest in another field. Today I will explain how this\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-11T06:11:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-05T05:55:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/09\/Image1.jpg\" \/>\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\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/\",\"name\":\"Linked selection fields through client side scripting - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/09\/Image1.jpg\",\"datePublished\":\"2014-09-11T06:11:50+00:00\",\"dateModified\":\"2019-12-05T05:55:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/09\/Image1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/09\/Image1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Linked selection fields through client side scripting\"}]},{\"@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":"Linked selection fields through client side scripting - 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\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/","og_locale":"en_US","og_type":"article","og_title":"Linked selection fields through client side scripting - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Today I will revisit one of the oldest, but very much useful tricks related to web forms. Most of the forms nowadays need relationship to be established between two fields. For example when I select Product interest in one list it should filter Sub product interest in another field. Today I will explain how this\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-09-11T06:11:50+00:00","article_modified_time":"2019-12-05T05:55:59+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/09\/Image1.jpg","type":"","width":"","height":""}],"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\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/","name":"Linked selection fields through client side scripting - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/09\/Image1.jpg","datePublished":"2014-09-11T06:11:50+00:00","dateModified":"2019-12-05T05:55:59+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/09\/Image1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/09\/Image1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/11\/linked-selection-fields-through-client-side-scripting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Linked selection fields through client side scripting"}]},{"@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\/8629","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=8629"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8629\/revisions"}],"predecessor-version":[{"id":23405,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8629\/revisions\/23405"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=8629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=8629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=8629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}