{"id":11013,"date":"2015-09-30T17:58:42","date_gmt":"2015-09-30T17:58:42","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=11013"},"modified":"2015-09-30T17:58:42","modified_gmt":"2015-09-30T17:58:42","slug":"use-escalation-rules-for-birthday-and-anniversary-wishes","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/","title":{"rendered":"Use Escalation Rules for Birthday and Anniversary wishes"},"content":{"rendered":"

Hello everyone!! As we all know, Sage CRM comes with a powerful tool which allow system to notify users in form of Escalation emails. The Escalation feature is best utilized in Case management module of CRM wherein on breaching the SLA reminder emails goes out of system.
\nIn our recent implementation, we have extended this feature of Escalation to send birthday and anniversary reminder emails to customers. How we can make this working is explained in this blog topic.
\nNew Stuff:Unable to Download Data through Sage CRM Mobile Apps \u2013 Part 2<\/a><\/span><\/strong><\/span>
\nTo do this follow below steps:<\/strong>
\n1. Add new fields pers_birth_date<\/strong>, pers_anniversary_date<\/strong>, pers_emailflag<\/strong>, pers_dateflag<\/strong> in person entity.
\n2. Create a view under Person<\/strong> entity in order to get those person records to whom you wish to send reminder mails.
\n3. Create a Escalation Rule by navigating to Administration | Advanced Customization | Escalation.
\n<\/strong>4. Fill in the following information as given below:<\/p>\n

a. Select Person<\/strong> entity from Table option.
\nb. Rule Name: Birthday Reminder (As per your requirement).
\nc. Select the Rule Enabled<\/strong> check box.
\nd. Add below condition in Trigger SQL Clause<\/strong>.<\/p>\n

MONTH(pers_birth_date)=MONTH(GetDate()) and day (pers_birth_date) = day(GetDate()) and pers_emailflag is null and Pers_Deleted is null<\/em>
\n\"IMG2\"<\/a>
\n 
\n5. Add Send Email action to the escalation rule.
\n\"image3\"<\/a>
\n6. Configure the Email Template & Save.
\n\"IMG3\"<\/a>
\nOn performing the configuration your system is ready to send emails to your customers. You can also update the action flag on respective field to avoid sending repetitive emails from system.
\nAlso Read:<\/strong><\/span>
\n1. Send Auto \u2013 Festival Greetings through Sage CRM<\/a>
\n2. Put user first name in escalation emails in place of full name that comes by default<\/a>
\n3. Why Notify Time Field is used in Escalation<\/a>
\n4. Escalation Rules<\/a>
\n5. Enabling Secondary Entities for Escalation<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Hello everyone!! As we all know, Sage CRM comes with a powerful tool which allow system to notify users in form of Escalation emails. The Escalation feature is best utilized in Case management module of CRM wherein on breaching the SLA reminder emails goes out of system. In our recent implementation, we have extended this\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":[73,98,139,141,140,332],"tags":[1101,1102],"class_list":["post-11013","post","type-post","status-publish","format-standard","hentry","category-configuration","category-customization","category-escalation-rule","category-escalations-2","category-escalations","category-sage-crm","tag-escalation-rule","tag-escalations"],"yoast_head":"\nUse Escalation Rules for Birthday and Anniversary wishes - 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\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use Escalation Rules for Birthday and Anniversary wishes - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Hello everyone!! As we all know, Sage CRM comes with a powerful tool which allow system to notify users in form of Escalation emails. The Escalation feature is best utilized in Case management module of CRM wherein on breaching the SLA reminder emails goes out of system. In our recent implementation, we have extended this\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-30T17:58:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/IMG2.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\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/\",\"name\":\"Use Escalation Rules for Birthday and Anniversary wishes - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/IMG2.jpg\",\"datePublished\":\"2015-09-30T17:58:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/IMG2.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/IMG2.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use Escalation Rules for Birthday and Anniversary wishes\"}]},{\"@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":"Use Escalation Rules for Birthday and Anniversary wishes - 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\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/","og_locale":"en_US","og_type":"article","og_title":"Use Escalation Rules for Birthday and Anniversary wishes - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Hello everyone!! As we all know, Sage CRM comes with a powerful tool which allow system to notify users in form of Escalation emails. The Escalation feature is best utilized in Case management module of CRM wherein on breaching the SLA reminder emails goes out of system. In our recent implementation, we have extended this\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-09-30T17:58:42+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/IMG2.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\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/","name":"Use Escalation Rules for Birthday and Anniversary wishes - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/IMG2.jpg","datePublished":"2015-09-30T17:58:42+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/IMG2.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/IMG2.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/30\/use-escalation-rules-for-birthday-and-anniversary-wishes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Use Escalation Rules for Birthday and Anniversary wishes"}]},{"@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\/11013","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=11013"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11013\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=11013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=11013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=11013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}