{"id":13235,"date":"2016-09-19T12:43:16","date_gmt":"2016-09-19T12:43:16","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=13235"},"modified":"2016-09-19T12:43:16","modified_gmt":"2016-09-19T12:43:16","slug":"how-to-change-user-select-fields-display-format-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/","title":{"rendered":"How to Change User-Select fields display format in Sage CRM?"},"content":{"rendered":"

You all must be familiar with the two different formats provided by Sage CRM<\/a> for User-select field. But do you really know, on what specific criteria does this field\u2019s data type changes or where it is basically configured in CRM?<\/p>\n

New Stuff:<\/span>\u00a0<\/em><\/strong>Unlock the potential Enterprise data \u2013 With our GUMU™ Integration for Sage CRM with Sage 100<\/a><\/p>\n

Well, the user-select field\u2019s data type is mainly dependent on the number of active users enabled in CRM. Thus if there are relatively low number of active users in the system, then this field will appear in the form of a Drop down list as shown below.<\/p>\n

\"1.Before<\/a><\/p>\n

However, if you increase the number of active users in CRM you will find that the way the field is displayed changes eventually.<\/p>\n

\"2.After<\/a><\/p>\n

This change in field\u2019s data type is managed through the DropdownThreshold<\/em><\/strong> value set in table named \u2018Custom_Sysparams\u2019<\/em><\/strong>.<\/em>
\nBelow are few queries that will help you to find the number of active users in CRM as well as identify and modify the DropdownThreshold <\/em><\/strong>through backend.
\n1.<\/strong> You can verify the number of active users by running the following SQL:
\nSELECT COUNT(*) FROM Users WHERE User_Deleted IS NULL AND User_Resource =’false’ AND User_Disabled IS NULL<\/em>
\n2.<\/strong> The current DropdownThreshold value can be determined by running the following SQL:
\nSELECT Parm_Name, Parm_Value FROM Custom_SysParams WHERE Parm_Name =’DropdownThreshold’<\/em>
\n3.<\/strong> To change the threshold value, execute the following SQL query. Here you can increase the threshold value as per your need.
\nUPDATE Custom_SysParams SET Parm_Value = 30 WHERE Parm_Name = ‘DropdownThreshold’<\/em>
\n4.<\/strong> Once done, execute metadata refresh and check.<\/p>\n

Also Read:<\/strong><\/em><\/span><\/p>\n

1.<\/strong> User Select field Selection or Finder?<\/a>
\n2.<\/strong> Creating User Multi Selects<\/a>
\n3.<\/strong> Setting Time Zone configurations in Sage CRM at user level as well as at system level<\/a>
\n4.<\/strong> How to setup Web Services for a User in Sage CRM.<\/a>
\n5.<\/strong> Display Current User Name under Custom Tab using jQuery<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

You all must be familiar with the two different formats provided by Sage CRM for User-select field. But do you really know, on what specific criteria does this field\u2019s data type changes or where it is basically configured in CRM? New Stuff:\u00a0Unlock the potential Enterprise data \u2013 With our GUMU™ Integration for Sage CRM with\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[155,216,219,332,357,410,1,420],"tags":[879,914,1018,1140,2534,2535,2536],"class_list":["post-13235","post","type-post","status-publish","format-standard","hentry","category-fields","category-limit","category-list","category-sage-crm","category-selection","category-type","category-uncategorized","category-user-select","tag-custom_sysparams","tag-data-type","tag-dropdownthreshold","tag-field-data-type","tag-user-select-field","tag-user-select-field-data-type","tag-user-select-field-display-format"],"yoast_head":"\nHow to Change User-Select fields display format in Sage CRM? - 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\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Change User-Select fields display format in Sage CRM? - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"You all must be familiar with the two different formats provided by Sage CRM for User-select field. But do you really know, on what specific criteria does this field\u2019s data type changes or where it is basically configured in CRM? New Stuff:\u00a0Unlock the potential Enterprise data \u2013 With our GUMU™ Integration for Sage CRM with\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-19T12:43:16+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/1.Before-User-add1.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\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/\",\"name\":\"How to Change User-Select fields display format in Sage CRM? - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/1.Before-User-add1.jpg\",\"datePublished\":\"2016-09-19T12:43:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/1.Before-User-add1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/1.Before-User-add1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Change User-Select fields display format in Sage CRM?\"}]},{\"@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":"How to Change User-Select fields display format in Sage CRM? - 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\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"How to Change User-Select fields display format in Sage CRM? - Sage CRM \u2013 Tips, Tricks and Components","og_description":"You all must be familiar with the two different formats provided by Sage CRM for User-select field. But do you really know, on what specific criteria does this field\u2019s data type changes or where it is basically configured in CRM? New Stuff:\u00a0Unlock the potential Enterprise data \u2013 With our GUMU™ Integration for Sage CRM with\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2016-09-19T12:43:16+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/1.Before-User-add1.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\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/","name":"How to Change User-Select fields display format in Sage CRM? - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/1.Before-User-add1.jpg","datePublished":"2016-09-19T12:43:16+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/1.Before-User-add1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/1.Before-User-add1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/19\/how-to-change-user-select-fields-display-format-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"How to Change User-Select fields display format in Sage CRM?"}]},{"@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\/13235","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=13235"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13235\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=13235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=13235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=13235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}