{"id":23514,"date":"2019-12-23T05:13:32","date_gmt":"2019-12-23T05:13:32","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=23514"},"modified":"2019-12-23T05:13:33","modified_gmt":"2019-12-23T05:13:33","slug":"customization-for-exporting-notes","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/","title":{"rendered":"Customization for exporting Notes"},"content":{"rendered":"\n<p>Hello everyone! In my previous blog I have explained how we can export notes for leads using sage CRM\u2019s standard report functionality. We can do the same with the help of coding as well.  <\/p>\n\n\n\n<p><strong><em>New Stuff<\/em><\/strong>:  <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/13\/client-side-script-to-concatenate-address\/\">Client Side Script to Concatenate Address<\/a><\/p>\n\n\n\n<p>Recently, one of our client asked us to add a button on notes list which will export all notes data in excel format for that particular lead. To do so you can follow below steps. <\/p>\n\n\n\n<p><strong> Add button to Notes tab naming \u201cExport to Excel\u201d. <\/strong><\/p>\n\n\n\n<ol><li>Log on to sage CRM.<\/li><li> Navigate through below path: <strong><\/br>Administration |Advanced Customization | Button Groups<\/strong><\/li><li>Click on New, give name as Notes and select action as \u201cnotelist\u201d and click on Save.<\/br><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg\" alt=\"Button Group\"><\/a>\n<font size=\"2\"><center><i>Button Group<\/i><\/center><\/font> <\/li><li> Now add button to newly created button group naming Export to excel Action as customfile and in custom file field fill up your file name. <\/li><li> Click on Add and then click on Save. A button will get added on notes tab of Lead as shown below: <\/br><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-2-2.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-2-2.jpg\" alt=\"Export to Excel\"><\/a>\n<font size=\"2\"><center><i>Export to Excel<\/i><\/center><\/font>\n<\/li><\/ol>\n\n\n\n<p><strong> Create ASP file using below code for exporting content to excel. <\/strong><\/p>\n\n\n\n<p>var\u00a0 strLeadID=Request.QueryString(&#8220;Key44&#8221;);<br>var exportingContent = &#8220;&lt;table border=1 style=&#8217;border-collapse:collapse&#8217;>&#8221;;<br>exportingContent += &#8220;&lt;tr>&#8221;;<br>exportingContent += &#8220;&lt;td>&lt;B>&#8221;+eWare.GetTrans(&#8220;colNames&#8221;,&#8221;Lead_CompanyName&#8221;)+&#8221;&lt;\/B>&lt;\/td>&#8221;;<br>exportingContent += &#8220;&lt;td>&lt;B>&#8221;+eWare.GetTrans(&#8220;colNames&#8221;,&#8221;Lead_PersonFirstName&#8221;)+&#8221;&lt;\/B>&lt;\/td>&#8221;;<br>exportingContent += &#8220;&lt;td>&lt;B>&#8221;+eWare.GetTrans(&#8220;colNames&#8221;,&#8221;Lead_PersonLastName&#8221;)+&#8221;&lt;\/B>&lt;\/td>&#8221;;<br>exportingContent += &#8220;&lt;td<br>&lt;B>&#8221;+eWare.GetTrans(&#8220;colNames&#8221;,&#8221;Lead_PersonPhoneNumber&#8221;)+&#8221;&lt;\/B>&lt;\/td>&#8221;;<br>exportingContent += &#8220;&lt;td>&lt;B>&#8221;+eWare.GetTrans(&#8220;colNames&#8221;,&#8221;Note_Note&#8221;)+&#8221;&lt;\/B>&lt;\/td>&#8221;;<br>exportingContent += &#8220;&lt;td>&lt;B>&#8221;+eWare.GetTrans(&#8220;colNames&#8221;,&#8221;Lead_Description&#8221;)+&#8221;&lt;\/B>&lt;\/td>&#8221;;<br>var NotesRecSQL=&#8221;&#8221;;<br>NotesRecSQL = &#8220;SELECT * FROM Notes &#8220;;<br>NotesRecSQL += &#8221; JOIN Lead ON note_foreignid = Lead_LeadID AND note_foreigntableid = 59&#8243;<br>NotesRecSQL += &#8221; WHERE Lead_deleted IS NULL AND Note_Deleted IS NULL and lead_leadid = &#8220;+strLeadID;<br>NotesRecords = eWare.CreateQueryObj(NotesRecSQL);<br>NotesRecords.SelectSql();<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if(!NotesRecords.eof)<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 while(!NotesRecords.eof)<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exportingContent += &#8220;&lt;tr>&#8221;;<br> \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var companyName = CheckNull(new<br>String(NotesRecords(&#8220;Lead_CompanyName&#8221;)));<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var PersFirstName = CheckNull(new String(NotesRecords(&#8220;Lead_PersonFirstName&#8221;)));<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var PersLastName = CheckNull(new String(NotesRecords(&#8220;Lead_PersonLastName&#8221;)));<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var PhoneNumber = CheckNull(new String(NotesRecords(&#8220;Lead_PersonPhoneNumber&#8221;)));<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var Note = CheckNull(new String(NotesRecords(&#8220;Note_Note&#8221;)));<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var PersDescription = CheckNull(new String(NotesRecords(&#8220;Lead_Description&#8221;)));<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exportingContent += &#8220;&lt;td>&#8221;+companyName+&#8221;&lt;\/td>&#8221;;<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exportingContent += &#8220;&lt;td>&#8221;+PersFirstName+&#8221;&lt;\/td>&#8221;;<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exportingContent += &#8220;&lt;td>&#8221;+PersLastName+&#8221;&lt;\/td>&#8221;;<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exportingContent += &#8220;&lt;td>&#8221;+PhoneNumber+&#8221;&lt;\/td>&#8221;;<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exportingContent += &#8220;&lt;td>&#8221;+Note+&#8221;&lt;\/td>&#8221;;<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exportingContent += &#8220;&lt;td>&#8221;+PersDescription+&#8221;&lt;\/td>&#8221;;<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exportingContent += &#8220;&lt;\/tr>&#8221;;<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NotesRecords.NextRecord();<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br>exportingContent += &#8220;&lt;\/table>&#8221;;<br>Response.AddHeader(&#8220;content-disposition&#8221;,&#8221;attachment;filename=LeadsNote.xls&#8221;);<br>Response.ContentType = &#8220;application\/vnd.ms-excel&#8221;;<br>Response.Buffer = true;<br>Response.Write(exportingContent);<br>Response.Flush()<br>}<br>function CheckNull(pmField)<br>{<br>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if(pmField== &#8220;&#8221; || pmField == &#8220;NULL&#8221; || pmField== &#8220;undefined&#8221;)pmField = &#8220;&#8221;;<br> \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return pmField; }<\/p>\n\n\n\n<p> Now on click of \u201c<strong>Export to Excel<\/strong>\u201d button an excel file will get generated as follows: <\/p>\n\n\n\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-3-2.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-3-2.jpg\" alt=\"Template\"><\/a>\n<font size=\"2\"><center><i>Template<\/i><\/center><\/font>\n\n\n\n<p> You can use this code for any data all you need to provide is proper column names and data value. Hope this will help. <\/p>\n\n\n\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><\/p>\n\n\n\n<p>Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n<p>Greytrix\u00a0has some unique integration solutions developed for Sage CRM with Sage ERPs namely\u00a0Sage X3,\u00a0Sage Intacct,\u00a0Sage 100,\u00a0Sage 500,\u00a0and\u00a0Sage 300. We also offer best-in-class\u00a0Sage ERP\u00a0and\u00a0Sage CRM\u00a0customization and development services\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users, and Sage PSG worldwide. Greytrix\u00a0helps in\u00a0the migration of Sage CRM from\u00a0Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes\u00a0add-ons like\u00a0 Greytrix Business Manager,\u00a0Sage CRM Project Manager,\u00a0Sage CRM Resource Planner,\u00a0Sage CRM Contract Manager,\u00a0Sage CRM Event Manager,\u00a0Sage CRM Budget Planner,\u00a0Gmail Integration,\u00a0Sage CRM Mobile Service Signature,\u00a0Sage CRM CTI Framework.<gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n<p>Greytrix is a recognized\u00a0Sage Champion Partner\u00a0for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration listed on\u00a0Sage Marketplace and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU&#x2122; Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n<p>For more information on our integration solutions, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hello everyone! In my previous blog I have explained how we can export notes for leads using sage CRM\u2019s standard report functionality. We can do the same with the help of coding as well. New Stuff: Client Side Script to Concatenate Address Recently, one of our client asked us to add a button on notes\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83,146,184,317,332,333,334,335,3986,3987,3985,336,337,338,340,341,342,1],"tags":[574,640,1117,1679],"class_list":["post-23514","post","type-post","status-publish","format-standard","hentry","category-crm72","category-export-to-excel","category-import-sage-crm","category-report","category-sage-crm","category-sage-crm-2017","category-sage-crm-2018","category-sage-crm-2018-crm72","category-sage-crm-2019-r1-sage-crm-2018-crm72","category-sage-crm-2019-r1-sage-crm","category-sage-crm-2019-r1","category-sage-crm-7-1-sp2","category-sage-crm-7-2","category-sage-crm-73","category-sage-crm-guide","category-sage-crm-r1","category-sage-crm7-3","category-uncategorized","tag-asp","tag-buttons","tag-export-to-excel","tag-notes-tab"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Customization for exporting Notes - 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\/2019\/12\/23\/customization-for-exporting-notes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Customization for exporting Notes - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Hello everyone! In my previous blog I have explained how we can export notes for leads using sage CRM\u2019s standard report functionality. We can do the same with the help of coding as well. New Stuff: Client Side Script to Concatenate Address Recently, one of our client asked us to add a button on notes\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-23T05:13:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-23T05:13:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\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\/2019\/12\/23\/customization-for-exporting-notes\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/\",\"name\":\"Customization for exporting Notes - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg\",\"datePublished\":\"2019-12-23T05:13:32+00:00\",\"dateModified\":\"2019-12-23T05:13:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Customization for exporting Notes\"}]},{\"@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 &amp; 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\/402abe5da07cd7f9bfeb6acfa41fae39\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Customization for exporting Notes - 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\/2019\/12\/23\/customization-for-exporting-notes\/","og_locale":"en_US","og_type":"article","og_title":"Customization for exporting Notes - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Hello everyone! In my previous blog I have explained how we can export notes for leads using sage CRM\u2019s standard report functionality. We can do the same with the help of coding as well. New Stuff: Client Side Script to Concatenate Address Recently, one of our client asked us to add a button on notes\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2019-12-23T05:13:32+00:00","article_modified_time":"2019-12-23T05:13:33+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/","name":"Customization for exporting Notes - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg","datePublished":"2019-12-23T05:13:32+00:00","dateModified":"2019-12-23T05:13:33+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2019\/12\/Img-1-2.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2019\/12\/23\/customization-for-exporting-notes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Customization for exporting Notes"}]},{"@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 &amp; 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\/402abe5da07cd7f9bfeb6acfa41fae39","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/23514","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=23514"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/23514\/revisions"}],"predecessor-version":[{"id":23520,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/23514\/revisions\/23520"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=23514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=23514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=23514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}