{"id":394,"date":"2011-10-17T05:26:14","date_gmt":"2011-10-17T05:26:14","guid":{"rendered":"http:\/\/greytrix.com\/blogs\/sagecrm\/?p=394"},"modified":"2011-10-17T05:26:14","modified_gmt":"2011-10-17T05:26:14","slug":"change-entry-type-of-field-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/","title":{"rendered":"Change Entry Type of Field in Sage CRM"},"content":{"rendered":"

Sage CRM standard functionality allows us to add multiple types (Text, Selection List, Multi Select, Search Select Advanced etc) of entries in an entity and showing them for at the entity level for informative purpose. What if you have created a field with wrong data type? Has anyone thought how one can change the data type of field without deleting the field? Well, the answer is yes you can change the data type and for this you need to do some database level changes.
\nSuppose you have created a field in the Company entity with the following specifications.
\nEntry Type : Currency
\nColumn Name : comp_test
\nNow, if you want to change the Entry Type of this field, you will normally navigate to field level under the appropriate entity (Here Company) and select the field to change the entry type. But sometimes Entry Type column in the field Read Only.
\nYou need to follow the below steps.
\n1. Login to MS-SQL server.
\n2. Select the Sage CRM database.
\n3. Select the Company Table and check the data type of any existing Selection field.
\n4. Create a query on the Sage CRM database in the below format.
\nalter table < < table name > >
\nalter column < < column name > > < < data type of new field > >
\nHere in this case, my query would be something like this.
\nalter table company
\nalter column comp_test nchar(40)
\n5. Execute the query by pressing Execute button or F5.
\n6. Now, Login to Sage CRM.
\n7. Navigate to Administration > Customization > Company.
\n8. In the Fields tab, select the field comp_test (which will show you as Currency type)
\n9. Click on field name and change type of the field.
\n10. Click on Save button.
\n11. Do the Metadata Refresh.
\n12. Run the IISRESET command.
\nThe similar thing can be achieved by only executing the SQL queries only perquisite is you need to know the Entry Type of the new field. You need to execute the Update query on the Custom_Edits table which stores all the field level information. The query would be something like below. You need to change it as per requirement.
\n–Query – Change the column properties to make it selection field
\nupdate custom_edits
\nset
\ncolp_entrytype=21
\ncolp_defaulttype=0
\ncolp_entrysize=20,
\ncolp_datatype=4,
\ncolp_datasize=40
\ncolp_updateddate =getdate()
\nwhere colp_colname = ‘< field name e.g. comp_test >‘
\n— Query – Alter column in table to fit the selection field
\nalter table < < table name > > alter column < < column name > > < < data type of new field > >
\nLogin to CRM and do Metadata refresh.
\nI would recommend using 1st option as it saves your time to search for the Entry Type of the new field. Make sure that you have database backup before applying above scripts on the CRM database.
\nFor more details on Add-On and pricing, please drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee> <\/p>\n","protected":false},"excerpt":{"rendered":"

Sage CRM standard functionality allows us to add multiple types (Text, Selection List, Multi Select, Search Select Advanced etc) of entries in an entity and showing them for at the entity level for informative purpose. What if you have created a field with wrong data type? Has anyone thought how one can change the data\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":[332],"tags":[914,1082,2010],"class_list":["post-394","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-data-type","tag-entry-type","tag-sage-crm"],"yoast_head":"\nChange Entry Type of Field 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\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change Entry Type of Field in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage CRM standard functionality allows us to add multiple types (Text, Selection List, Multi Select, Search Select Advanced etc) of entries in an entity and showing them for at the entity level for informative purpose. What if you have created a field with wrong data type? Has anyone thought how one can change the data\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-17T05:26:14+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\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/\",\"name\":\"Change Entry Type of Field in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2011-10-17T05:26:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change Entry Type of Field 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":"Change Entry Type of Field 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\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Change Entry Type of Field in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Sage CRM standard functionality allows us to add multiple types (Text, Selection List, Multi Select, Search Select Advanced etc) of entries in an entity and showing them for at the entity level for informative purpose. What if you have created a field with wrong data type? Has anyone thought how one can change the data\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2011-10-17T05:26:14+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\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/","name":"Change Entry Type of Field in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2011-10-17T05:26:14+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/17\/change-entry-type-of-field-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Change Entry Type of Field 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\/394","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=394"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/394\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}