{"id":98,"date":"2009-03-23T04:08:00","date_gmt":"2009-03-23T04:08:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=98"},"modified":"2009-03-23T04:08:00","modified_gmt":"2009-03-23T04:08:00","slug":"interesting-fact-about-values-collection","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/","title":{"rendered":"Interesting fact about Values () collection:"},"content":{"rendered":"

Let\u2019s consider the case of creating new opportunity as an example.<\/p>\n

Consider that you want to set value of oppo_description field based on oppo_type field i.e. say you want to set description field to \u201cHello World\u201d if oppo_type is set to parts.<\/p>\n

Now normally what comes in our head to incorporate this is something like, we will write the below given code on CreateScript of oppo_Description field.<\/p>\n

lc_type = (Values(‘oppo_type’))
if (lc_type == ‘Parts’)
{
DefaultValue=\u201dHello World\u201d
}
Errorstr= lc_type<\/p>\n

Usually there is nothing wrong with this code as far as the logic is concerned, but the thing is you can use Values() collection only if the record already exists i.e. you can use them on summary screens but cannot on New Entry screens. So for the above requirement we can write a below code in CreateScript box of Opportunity Detail Screen.<\/p>\n

\"\"id=\"BLOGGER_PHOTO_ID_5316230510517995426\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Let\u2019s consider the case of creating new opportunity as an example. Consider that you want to set value of oppo_description field based on oppo_type field i.e. say you want to set description field to \u201cHello World\u201d if oppo_type is set to parts. Now normally what comes in our head to incorporate this is something like,\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":[1],"tags":[499,2549],"class_list":["post-98","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-action","tag-values"],"yoast_head":"\nInteresting fact about Values () collection: - 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\/2009\/03\/23\/interesting-fact-about-values-collection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Interesting fact about Values () collection: - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Let\u2019s consider the case of creating new opportunity as an example. Consider that you want to set value of oppo_description field based on oppo_type field i.e. say you want to set description field to \u201cHello World\u201d if oppo_type is set to parts. Now normally what comes in our head to incorporate this is something like,\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-03-23T04:08:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SccLe5OEx6I\/AAAAAAAAARg\/nj8hX6BH9XM\/s400\/calues+coll.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=\"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\/2009\/03\/23\/interesting-fact-about-values-collection\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/\",\"name\":\"Interesting fact about Values () collection: - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SccLe5OEx6I\/AAAAAAAAARg\/nj8hX6BH9XM\/s400\/calues+coll.JPG\",\"datePublished\":\"2009-03-23T04:08:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#primaryimage\",\"url\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SccLe5OEx6I\/AAAAAAAAARg\/nj8hX6BH9XM\/s400\/calues+coll.JPG\",\"contentUrl\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SccLe5OEx6I\/AAAAAAAAARg\/nj8hX6BH9XM\/s400\/calues+coll.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Interesting fact about Values () collection:\"}]},{\"@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":"Interesting fact about Values () collection: - 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\/2009\/03\/23\/interesting-fact-about-values-collection\/","og_locale":"en_US","og_type":"article","og_title":"Interesting fact about Values () collection: - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Let\u2019s consider the case of creating new opportunity as an example. Consider that you want to set value of oppo_description field based on oppo_type field i.e. say you want to set description field to \u201cHello World\u201d if oppo_type is set to parts. Now normally what comes in our head to incorporate this is something like,\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2009-03-23T04:08:00+00:00","og_image":[{"url":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SccLe5OEx6I\/AAAAAAAAARg\/nj8hX6BH9XM\/s400\/calues+coll.JPG","type":"","width":"","height":""}],"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\/2009\/03\/23\/interesting-fact-about-values-collection\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/","name":"Interesting fact about Values () collection: - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#primaryimage"},"thumbnailUrl":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SccLe5OEx6I\/AAAAAAAAARg\/nj8hX6BH9XM\/s400\/calues+coll.JPG","datePublished":"2009-03-23T04:08:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#primaryimage","url":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SccLe5OEx6I\/AAAAAAAAARg\/nj8hX6BH9XM\/s400\/calues+coll.JPG","contentUrl":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SccLe5OEx6I\/AAAAAAAAARg\/nj8hX6BH9XM\/s400\/calues+coll.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/23\/interesting-fact-about-values-collection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Interesting fact about Values () collection:"}]},{"@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\/98","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=98"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}