Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... = ifnull(m_Body.get("requests").get("request_name"),"-"); if(v_RequestName.containsIgnoreCase("credit application")) { v_ZohoSign_DocumentType = "CreditApplication"; } v_DebugMessage = v_DebugMessag ...; Created on 06 August 2024
2. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... was not accurate enough... but here's the snippet: r_CommentsHistory = Map(); l_Comments = ifnull(r_CommentsHistory.get("comments"),List()); for each m_Comment in l_Comments { if(m_Comment.get("description").containsIgnoreCase("Purchase ...; Created on 09 July 2024
3. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... item and description v_ItemDescDisp = "" + c_Quote.Product.Product_Name + " "; if(c_Quote.Special_Edition.containsIgnoreCase("yes")) { v_ItemDescDisp = "SPECIAL EDITION "; } // // ...; Created on 07 May 2024
4. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
5. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... e if(r_ChatGPTResponse.get("responseCode") == 429) { // store in response text v_Answer = "I dont have any knowledge in this. Please ask me something else"; } } else if (v_Message.containsIgnoreCase("H ...; Created on 13 February 2023
6. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode = ifnull(r_Result.get("payment_mode_formatted"),""); v_PaymentDate ...; Created on 17 August 2022
7. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... URL of the hosted image if(r_ResponseXML.containsIgnoreCase("Success") || r_ResponseXML.containsIgnoreCase("Warning")) { v_BiggestHeight = 0; x_RespondedXML = r_ResponseXML.replaceFirst("xmlns=\"urn:ebay:apis:eBLBaseComponents\"","",true); x_PictureSets ...; Created on 31 March 2022
8. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
9. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... " + r_Event.get("eventType"); // // get the xero ID of the record (hexadecimal) v_Xero_ResourceID = r_Event.get("resourceId"); // // do different things based on the category of the update if(r_Event.get("eventCategory").containsIgnoreCase("CONTACT")) { / ...; Created on 10 January 2022
10. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... == "Customer_s_Timezone") { // loop through all the picklist values of this dropdown for each r_TimeZone in r_Field.get("pick_list_values") { if(r_TimeZone.get("display_value").containsIgnoreCase(v_TimeZone)) { v_CustomerTimeZon ...; Created on 15 December 2021
11. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... single out this person (can be removed after testing) if(v_LastName.containsIgnoreCase("Lipman")) { // // get user id v_UserID = r_User.get("id"); // // startofweek is a ...; Created on 02 December 2021
12. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... = v_PhotoWithExt.subString(v_PhotoWithExt.lastIndexOf(".") + 1).toLowerCase(); // if(l_CompatiblePhotoExtensions.containsIgnoreCase(v_PhotoFileExtension)) { v_ThisPhotoSrc = "https://creator.zoho.com/file/appowner/appname/My_Form_Report/" ...; Created on 17 October 2021
13. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... = r_AvailableSlots.get("response").get("returnvalue").get("data"); if(!l_AvailableSlots.toString().containsIgnoreCase("Slots Not Available")) { for each r_AvailableSlot in l_AvailableSlots { if(!r_AvailableSlot.contains("00:00") ...; Created on 23 June 2021
14. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records: ... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)]; ... Lastly, there ...; Created on 21 November 2019