{"id":9033,"date":"2014-10-25T09:42:36","date_gmt":"2014-10-25T09:42:36","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=9033"},"modified":"2014-10-25T09:42:36","modified_gmt":"2014-10-25T09:42:36","slug":"alter-length-of-phone-number-fields-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/","title":{"rendered":"Alter length of Phone Number Fields in Sage CRM"},"content":{"rendered":"

In our earlier blogs posts, we had explained how to set field length at run time using JavaScript and jQuery. Following are the links for the same.
\n1) Set field length at run time in Sage CRM
\n<\/a>2) Changing max allowable length of Text field using JQuery<\/a>
\nNew Stuff: <\/em><\/strong><\/span>Using Primary Key Column of an Entity to Search<\/a>
\nLength of the Phone Number field is enough for general business processes. However, if Country Code and Area Code both are entered into the phone number field then the Phone number may increase to more than 10 digits. In such cases, users would want to increase the length of the phone number field.
\nLet\u2019s say you want to increase the Phone Number field of Sage CRM to 25. You need to follow below steps for the same.
\n==Backup Sage CRM database before making any of the changes==<\/span>
\n1) Increase the display length of Phone Number field on Sage CRM screens by executing below query.
\nUPDATE custom_edits SET colp_entrysize = 25
\nWHERE ColP_Entity = ‘phone’ and ColP_ColName = ‘phon_number’
\n2) Increase the physical length of Phone Number field by executing below query.
\nalter table phone alter column phon_number nvarchar(20)
\nUPDATE custom_edits SET colp_lookupwidth = 25
\nWHERE ColP_Entity = ‘phone’ and ColP_ColName = ‘phon_number’
\n3) You must also change the phon_number field of CRMPhoneEmailData table by executing below query. (if Sage CRM v7.1 and above)
\nalter table CRMEmailPhoneData alter column epd_PhoneNumber nvarchar(25)
\n4) Do Metadata Refresh to see the effect.
\n5) Run IISRESET command.
\nOnce done, you can navigate to Phone\/Email tab of Company or Person entities. Now you will be able to enter 25 characters in Sage CRM Phone number field.
\nAlso Read:<\/span>
\n<\/em><\/strong>1) Phone Type Field in Web services
\n<\/a>2) Phone and Email Structure Changed in Sage CRM7.1
\n<\/a>3) Remove unwanted Phone-Email fields
\n<\/a>4) Remove unwanted Phone-Email fields Part 2
\n<\/a>5) Including phone numbers from phone table in standard Document Merge<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In our earlier blogs posts, we had explained how to set field length at run time using JavaScript and jQuery. Following are the links for the same. 1) Set field length at run time in Sage CRM 2) Changing max allowable length of Text field using JQuery New Stuff: Using Primary Key Column of an\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":[24,83,185,239,286,332,336,337],"tags":[552,656,833,1415,1684,1765,2010,2030,2140],"class_list":["post-9033","post","type-post","status-publish","format-standard","hentry","category-alter","category-crm72","category-increase","category-max-length","category-phone","category-sage-crm","category-sage-crm-7-1-sp2","category-sage-crm-7-2","tag-alter","tag-change","tag-crm7-0","tag-increase","tag-number","tag-phone","tag-sage-crm","tag-sage-crm-7-0","tag-sage-crm-com"],"yoast_head":"\nAlter length of Phone Number Fields 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\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Alter length of Phone Number Fields in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our earlier blogs posts, we had explained how to set field length at run time using JavaScript and jQuery. Following are the links for the same. 1) Set field length at run time in Sage CRM 2) Changing max allowable length of Text field using JQuery New Stuff: Using Primary Key Column of an\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-25T09:42:36+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\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/\",\"name\":\"Alter length of Phone Number Fields in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2014-10-25T09:42:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Alter length of Phone Number Fields 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":"Alter length of Phone Number Fields 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\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Alter length of Phone Number Fields in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In our earlier blogs posts, we had explained how to set field length at run time using JavaScript and jQuery. Following are the links for the same. 1) Set field length at run time in Sage CRM 2) Changing max allowable length of Text field using JQuery New Stuff: Using Primary Key Column of an\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-10-25T09:42:36+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\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/","name":"Alter length of Phone Number Fields in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2014-10-25T09:42:36+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/10\/25\/alter-length-of-phone-number-fields-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Alter length of Phone Number Fields 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\/9033","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=9033"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/9033\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=9033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=9033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=9033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}