Search - Joel Lipman .Com

21. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: ...; Created on 07 December 2021
22. 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
23. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; What? Just a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 ...; Created on 17 November 2021
24. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; What? I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want ...; Created on 11 November 2021
25. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; What? A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next ...; Created on 02 November 2021
26. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
27. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... The above should yield something like: /1234567890123_my_beautiful_face.jpg ,"message":"photo uploaded successfully","status":"success"} Source(s): ZohoCRM REST API: Upload a Photo Zoho Deluge: ...; Created on 27 September 2021
28. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // ...; Created on 21 September 2021
29. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; What? A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are ...; Created on 10 September 2021
30. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... pure Deluge no Regex v_DelugeDate = v_TestDate.toList("/").get(2) +"-"+ v_TestDate.toList("/").get(1) +"-"+ v_TestDate.toList("/").get(0); info v_DelugeDate; info v_DelugeDate.toDate(); info v_DelugeDate.toString("E, ...; Created on 01 September 2021
31. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; What? A quick article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called ...; Created on 01 September 2021
32. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge ...; Created on 26 August 2021
33. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting ...; Created on 30 July 2021
34. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; What? This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form ...; Created on 23 June 2021
35. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; What? A super quick article to demonstrate an example where we create a project with custom fields. Why? At time of print, the documentation on the Projects API would only show responses rather ...; Created on 17 June 2021
36. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
37. 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
38. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; What? This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module ...; Created on 28 April 2021
39. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; What? This is an article documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing ...; Created on 03 February 2021
40. Zoho Deluge: Sort a Map by a specific field: / Zoho /; What? This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort ...; Created on 29 January 2021