Search - Joel Lipman .Com

41. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... if not found, let's see if state is specified else if(!isnull(r_LeadDetails.get("State"))) { // find a module record matching the State l_SearchResults = zoho.crm.searchRecords("States","Name:equals:" ...; Created on 15 December 2021
42. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... 32; // // set to the Account record of our organization v_OrgAccountRecord = 123456789012345678; // // loop through all users r_Users = zoho.crm.getRecords("users"); if(!isnull(r_Users.get("users"))) { for ...; Created on 02 December 2021
43. Zoho CRM: Schedule a Call using Deluge: / Zoho /; What? This is an article to document how to schedule a call with a reminder in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to ...; Created on 18 November 2021
44. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... if I encounter any. This is simply how I fixed this error on this occasion. Consider the following code which loops through some Creator records, then loops through one of the subforms in each record: // ...; Created on 17 November 2021
45. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... e = zoho.writer.mergeAndSend("aaaabbbbccccddddeeeeffff000011112222333344445555", "pdf", r_ContactRecord.get("Email"), m_MergedData, "joels_connector"); if(!isNull(r_SendResponse.get("records"))) { v_Gramm ...; Created on 21 October 2021
46. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... = "2020-01"; // // loop through 2500 records v_LastID = 0; l_ProductIDs = List(); l_Pages = ; for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion.toString() ...; Created on 12 October 2021
47. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; What? This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in ...; Created on 08 October 2021
48. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... = r_UserDetails.toMap(); if(!isnull(m_UserDetails.get("Division"))) { v_DivisionID = ""; v_DivisionName = m_UserDetails.get("Division"); l_CrmDivisions = zoho.crm.searchRecords("Divisions","Name:equals:" ...; Created on 01 September 2021
49. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next ...; Created on 30 August 2021
50. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... The example below is that we are going to search for some records in Zoho Creator and display these in either Zoho Books or Zoho CRM. For demonstration purposes, these have been simplified and will ...; Created on 30 July 2021