{"id":3303,"date":"2013-01-14T06:43:13","date_gmt":"2013-01-14T06:43:13","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=3303"},"modified":"2013-01-14T06:43:13","modified_gmt":"2013-01-14T06:43:13","slug":"set-field-length-at-run-time-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/","title":{"rendered":"Set field length at run time in Sage CRM"},"content":{"rendered":"

There are different types of fields in Sage CRM. Well obviously we can change\/set the field length as per our convenient and depending upon the data that would be user filling while entering the data.
\nSuppose we need to change the field length then you need to do refer the below link.
\nhttps:\/\/www.greytrix.com\/blogs\/sagecrm\/2008\/12\/29\/changing-field-length-of-a-text-field\/<\/a>
\nAlternate way would be to change the same from SQL by executing the necessary queries.
\nCan it be done at a runtime? Well, the answer is yes. For example, we can set person private email address field length at run time. To do the same we need to follow the below steps:<\/p>\n

    \n
  1. Create a ClientFunctions.js file in the custom pages folder.<\/li>\n
  2. Add the below code in the ClientFunctions.js file.
    \nfunction setLength()
    \n{
    \nif(document.EntryForm.emai_emailaddressprivate)
    \n{
    \noEmailPrivate = document.EntryForm.emai_emailaddressprivate;
    \noEmailPrivate.maxLength = “50”
    \n}
    \n}<\/li>\n
  3. Navigate to Administration<\/strong>|<\/strong>Customization<\/strong>|<\/strong>Translations<\/strong><\/li>\n
  4. Check the Translation<\/strong> inline mode checkbox.<\/li>\n
  5. Go to the Person phone email tab.<\/li>\n
  6. Click on the Email_<\/em>and add the below code in the US and UK translation of the same.
    \nEmail< script language=javascript src=”..\\CustomPages\\ClientFunctions.js” >
    \n< \/script >
    \n< script >
    \nwindow.attachEvent(“onload”, setLength)
    \n< \/script ><\/li>\n
  7. Click on the Save button and disable the Inline translation mode.<\/li>\n
  8. Log off Sage CRM.<\/li>\n
  9. Log in again to check the same.<\/li>\n<\/ol>\n

    You can do all the above mentioned steps to set length of any field at a runtime.<\/p>\n","protected":false},"excerpt":{"rendered":"

    There are different types of fields in Sage CRM. Well obviously we can change\/set the field length as per our convenient and depending upon the data that would be user filling while entering the data. Suppose we need to change the field length then you need to do refer the below link. https:\/\/www.greytrix.com\/blogs\/sagecrm\/2008\/12\/29\/changing-field-length-of-a-text-field\/ Alternate way\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,212,326,332],"tags":[],"class_list":["post-3303","post","type-post","status-publish","format-standard","hentry","category-fields","category-length","category-runtime","category-sage-crm"],"yoast_head":"\nSet field length at run time 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\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Set field length at run time in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"There are different types of fields in Sage CRM. Well obviously we can change\/set the field length as per our convenient and depending upon the data that would be user filling while entering the data. Suppose we need to change the field length then you need to do refer the below link. https:\/\/www.greytrix.com\/blogs\/sagecrm\/2008\/12\/29\/changing-field-length-of-a-text-field\/ Alternate way\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-01-14T06:43:13+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\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/\",\"name\":\"Set field length at run time in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2013-01-14T06:43:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Set field length at run time 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":"Set field length at run time 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\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Set field length at run time in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"There are different types of fields in Sage CRM. Well obviously we can change\/set the field length as per our convenient and depending upon the data that would be user filling while entering the data. Suppose we need to change the field length then you need to do refer the below link. https:\/\/www.greytrix.com\/blogs\/sagecrm\/2008\/12\/29\/changing-field-length-of-a-text-field\/ Alternate way\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-01-14T06:43:13+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\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/","name":"Set field length at run time in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2013-01-14T06:43:13+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/01\/14\/set-field-length-at-run-time-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Set field length at run time 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\/3303","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=3303"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/3303\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=3303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=3303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=3303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}