{"id":315,"date":"2011-05-04T13:34:00","date_gmt":"2011-05-04T13:34:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=315"},"modified":"2011-05-04T13:34:00","modified_gmt":"2011-05-04T13:34:00","slug":"using-id-fields-of-entities-on-screens-and-lists","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/","title":{"rendered":"Using Id fields of entities on screens and lists"},"content":{"rendered":"

Ideally speaking this will not be an out of box feature that everybody needs in CRM, however I came across many such requirements these days where people either wanted to use id fields on the screen as unique reference values. Some just wanted to display them on the screen for viewing purpose. Some wanted to put them in the list for ordering. I will be discussing the today\u2019s topic based on the similar grounds. Throughout the write up I will take up opportunity entity for explanation.<\/p>\n

ID value to be used just for viewing purpose:<\/strong><\/p>\n

Suppose you want Opportunity ID only to be displayed on the summary screen only for viewing purpose. For this create a new field under opportunity entity of size 1 char. Place it on the opportunity screen (Opportunity Detail Screen). On Create script of the newly created field get the opportunity id from context. Put the value in the caption part and then make the field read-only. Refer below given code snippet
<\/p>\n

var CurrOppoId = eWare.GetContextInfo(“Opportunity”,”Oppo_opportunityid”)
Caption=”Opportunity ID: “+ CurrOppoId;
Readonly=true;<\/em><\/p>\n

ID value to be used for checking uniqueness as an alternate to reference Id:<\/strong><\/p>\n

Yes we can create stored procedure fields In CRM to generate reference id\u2019s for the entities, however when the table size grows and insert operations become slow, running the procedures prior to insert operation add up to the task. Again we need this only for finding unique records through search screen or add them in the list for ordering purpose so we can also use the already existing unique factor i.e. ID value. Below is how you can achieve the same.<\/p>\n

1. Create a dummy integer field in entity. E.g.Oppo_DummyOppoId. <\/p>\n

2. Add this field to OpportunitySearchBox, OpportunityFilterBox etc. i.e. wherever needed for searching purpose.<\/p>\n

3. Add the same to OpportunityDetailBox if you want to display it on summary screen as well but do not forget to make it readonly.<\/p>\n

4. As now we are done with adding dummy field everywhere you have to write either a Table level script or SQL trigger to update the id value (Oppo_OpportunityId) of the record being inserted in this dummy field (Oppo_DummyOppoId).<\/p>\n

5. You can add the similar field on the list boxes too in order to apply order by clause based on ID value.<\/p>\n

If you find this content useful, please drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

Ideally speaking this will not be an out of box feature that everybody needs in CRM, however I came across many such requirements these days where people either wanted to use id fields on the screen as unique reference values. Some just wanted to display them on the screen for viewing purpose. Some wanted to\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":[1076,1377,2030,2031,2402],"class_list":["post-315","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-entity","tag-identity","tag-sage-crm-7-0","tag-sage-crm-7-1","tag-table"],"yoast_head":"\nUsing Id fields of entities on screens and lists - 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\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Id fields of entities on screens and lists - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Ideally speaking this will not be an out of box feature that everybody needs in CRM, however I came across many such requirements these days where people either wanted to use id fields on the screen as unique reference values. Some just wanted to display them on the screen for viewing purpose. Some wanted to\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-05-04T13:34:00+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\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/\",\"name\":\"Using Id fields of entities on screens and lists - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2011-05-04T13:34:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Id fields of entities on screens and lists\"}]},{\"@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":"Using Id fields of entities on screens and lists - 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\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/","og_locale":"en_US","og_type":"article","og_title":"Using Id fields of entities on screens and lists - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Ideally speaking this will not be an out of box feature that everybody needs in CRM, however I came across many such requirements these days where people either wanted to use id fields on the screen as unique reference values. Some just wanted to display them on the screen for viewing purpose. Some wanted to\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2011-05-04T13:34:00+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\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/","name":"Using Id fields of entities on screens and lists - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2011-05-04T13:34:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/05\/04\/using-id-fields-of-entities-on-screens-and-lists\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Using Id fields of entities on screens and lists"}]},{"@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\/315","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=315"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/315\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}