Search - Joel Lipman .Com

1. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... things to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element ...; Created on 18 August 2014
2. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... = true; // // Mark the estimate as accepted r_Accept = invokeurl [ url :"https://www.zohoapis.com/books/v3/estimates/" + v_EstimateID + "/status/accepted?organization_id=" + v_OrgId type ...; Created on 04 November 2024
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... m_Data.put("templates",m_Templates); m_Templates.put("actions",l_Actions); m_Templates.put("notes",""); m_Parameters.put("data",m_Data); m_Parameters.put("is_quicksend",true); // // Send the ...; Created on 06 August 2024
4. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... statements; this is not true as the following counts 3 statements executed prior to the loop: // l_LoopInnerInner = " ".leftpad(5000); l_LoopInner = l_LoopInnerInner.replaceAll(" ", ","); l_Loop ...; Created on 31 July 2024
5. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; What? A quick article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have ...; Created on 09 July 2024
6. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is ...; Created on 07 May 2024
7. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... // restore by default b_RestoreOrderUpdateWebhook = true; b_RestoreInventoryLevelWebhook = true; // // retrieve connection details record r_ShopifyConnection = zoho.creator.getRecordById("myOwnerName","myAppName","myAPIConnectionsData",,"myCreatorConnection"); // // ...; Created on 22 April 2024
8. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... ",", true)); l_CsvRow.add(c_Product.Product_Desc.replaceAll(",", ",", true)); l_CsvRow.add("\"" + c_Product.ID + "\""); l_CsvLines.add(l_CsvRow.toString()); } Generate ...; Created on 25 March 2024
9. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... Superceded by including "send=true" in the invoice creation request More Info: Error 1038: JSON is not well formed - Encountered when trying to use the send an invoice API - Was sending ...; Created on 07 March 2024
10. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... for myself is as follows: Trigger if the contact record has a tickbox called "Extra Confidential" ticked/checked=true Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer ...; Created on 06 February 2024
11. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... */ // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // taken from stackoverflow: https://stackoverflow.com/questions/17369098/simplest-way-of-getting-the-number-of-decimals-in-a-number-in-javascript ...; Created on 13 December 2023
12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... :v_ImageToDownload type :GET ]; // // upload file to workdrive r_WorkdriveUpload = zoho.workdrive.uploadFile(f_File,v_TargetFolder,v_FileName,true,"zworkdrive"); info "Workdrive response:"; info ...; Created on 05 December 2023
13. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... = ; l_CrmShippingAddress = ; l_BooksAddress = ; // // evaluate r_QuoteDetails = zoho.crm.getRecordById("Quotes",123456789012345678); // // push to ZohoBooks estimate if(true) { // // ---------------------- ...; Created on 18 September 2023
14. Zoho Deluge: Proper Case for Names: / Zoho /; ... " :|JOEL|: ", true).proper(); v_FirstName = v_FirstName.replaceAll(" :|joel|: ", "-", true); // // Names starting with Mc, O', D', I' l_ExceptionPrefixes = ; // // deal with double barrelled surnames l_FormattedLastName ...; Created on 13 July 2023
15. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... = v_ThisCurrentWeekNumber.leftPad(2).replaceAll(" ", "0", true); // // or // v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("ww"); // // ...; Created on 06 July 2023
16. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... "", "is_mandatory": true, "payment_terms": -2, "payment_terms_label": "Due end of the month" }, { "payment_terms_id": "", "is_mandatory": true, ...; Created on 06 July 2023
17. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... "GMT"), true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London" ...; Created on 03 July 2023
18. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... ones m_CreateBooksItem.put("track_serial_number",true); m_CreateBooksItem.put("track_batch_number",true); // // let's try creating it r_CreateItem = zoho.inventory.createRecord("items",v_BooksOrgID,m_CreateBooksItem,"zinventory"); info ...; Created on 04 May 2023
19. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... = 1; v_PerPage = 10; m_Output = Map(); l_Costs = ; b_DebugMode = true; l_DebugMessages = List(); l_DebugMessages.add("eBay Order ID: " + p_eBayOrderRef); l_DebugMessages.add("eBay Order Date: " + ...; Created on 27 April 2023
20. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023