Search - Joel Lipman .Com

21. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... the last element. At time of print, I ran this to retrieve 1970 active product IDs and their SKUs without erroring by going over the Zoho Deluge statement execution limit. Additional: See my ...; Created on 12 October 2021
22. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... r_Coql; Additional If you wanted the unique values of a picklist/dropdown, then consider an invokeUrl looping through the fields settings in CRM. Source(s): Zoho CRM Developer Docs API v ...; Created on 08 October 2021
23. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... that any change was made. Instead, I need to add an additional field called "eTag_Title", check if the new MD5 is different, if it is then I proceed with the automations otherwise I stop it. // get given ...; Created on 19 September 2021
24. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge .toList() fails the function ...; Created on 01 September 2021
25. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... == v_OwnerID) { v_SalesPersonID = r_SalesPerson.get("salesperson_id"); break; } } m_CreateSO.put("salesperson_id",v_SalesPersonID); } Additional Note(s): Scope(s) required: for ...; Created on 30 August 2021
26. ZohoCRM: Process all records of a module: / Zoho /; ... Additional Notes As a preliminary measure, I deactivate any workflows in CRM that this process would affect. In the example above, all workflows relating to the Contacts and Leads module. Lastly, ...; Created on 24 August 2021
27. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... ... code to create new record r_NewRecord = insert into [ = = = ]; } Done: Additional Remember that an integration field on the interface is returned as a string ...; Created on 27 July 2021
28. Zoho Creator: Add a subform while creating a record: / Zoho /; ... Billing_Address.country=v_AddressCountry Line_Items=c_LineItems ]; From the documentation Additional Note that any bidirectional relation field that exists will be prepopulated ...; Created on 14 July 2021
29. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... ¡ Upside-down Exclamation 0161 ¿ Upside-down Question 0191 ª Feminine Ordinal 0170 º Masculine Ordinal 0186 « Left angle quote 0171 » Right angle quote 0187 Additional "Alt Codes" can ...; Created on 03 June 2021
30. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... process doesn't just require you to add in this custom field per line item, but also requires a change to the other fields in the line item. There is an additional note that when using v2.1, you no longer ...; Created on 17 May 2021
31. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; What? This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar ...; Created on 30 April 2021
32. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... + " (" + v_ThisFileSize + ")"; } } // v_ThisHtmlLink can be displayed on a page as a link or you can put in a Note Field for the user to download just by clicking it. Additional: Why ...; Created on 02 February 2021
33. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... n for leave."; c_Response = Collection(); c_Response.insert("EmployeeID":v_OutputMessage); c_Ok = Collection(); c_Ok.insert("response":c_Response); return c_Ok; } Additiona ...; Created on 10 December 2020
34. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... and even in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a report button (report workflow). How? This will create a popup ...; Created on 06 November 2020
35. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... Now access this application and preview your masterpiece! The following screenshot shows what happens when I change the parameter: Additional Note(s): I have found that adapting Widgets ...; Created on 24 October 2020
36. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... type: GET connection: "joelconnector" ]; Additional I'd always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times of ...; Created on 12 August 2020
37. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... name "MyImage". There is an additional single-line text field called "Name". I have added an entry with name "Logo" and I have uploaded an image accordingly. // change this to eu (Europe), com (US), ...; Created on 14 July 2020
38. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... attaches the file(s) to the CRM record. See my "Additional" note further below in this article on how to sync the attachments to the CRM record, however for now, check the logic of this as this is known ...; Created on 15 May 2020
39. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Additional The reverse (date string to unix seconds) can be done using either of the following: v_MyDate = "2020-04-01 12:34:56"; v_UnixSeconds = v_MyDate.toTime().toLong(); info v_UnixSeconds; // ...; Created on 04 May 2020
40. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... create the record r_Clone = zoho.crm.createRecord("Invoices",m_Clone); // get cloned invoice ID if(!isNull(r_Clone.get("id"))) { v_Duplicate_InvoiceID = r_Clone.get("id"); } Additional Note(s): Invoice_Date ...; Created on 17 March 2020