Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with Connection Link: The syntax for this is response = zoho.creator.updateRecord( ownerName, appLinkName, formLinkName, id,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 #1: 5 Randomly Selected Letters Using a snippet from the community forums on how someone shuffled a pack of cards, I came up with a function that will take a list of letters, shuffle the list, and return the first 5 characters. string...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 2, 3"]} // What Creator understands: FAILS {"My_MultiPicklist":["["Option1","Options 2, 3"]"]} With workaround .toString() // What Creator understands: FAILS {"My_MultiPicklist":["Option1","Options 2"," 3"]} How? So the way to push this value over to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 Continue } } fex.SetCapacity(-1) Return fex } Usage v_MyMediaFile := "C:\Users\Public\Music\Sample Music\Maid with the Flaxen Hair.mp3" a_MediaObject := Filexpro( v_MyMediaFile,, "System.Media.Duration" , "System.Audio.ChannelCount" ,...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found COLLECTION...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the plural of what kind of records I am sending as parameters (in this case "Quotes"). As the actual...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 How? So to give you a gist of what the following snippet of code is doing, let me give an overview: Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 its changes to CRM. It was actually causing a loop which used up all the API calls. How? You might already be familiar with some of the trigger options below but one that worked was initially guessed as "none" but then later found in the documentation...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Zoho Bookings Get Available Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

23 June 2021 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 to allow customers to make a booking based on the configuration...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 default in Zoho Bookings as documented in the official documentation. Not sure why anyone would want to leave this enabled without applying the fix. So the fix is a setting: Login to Zoho Bookings as the admin Click on the settings cog icon in the top...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 a webhook) to my CRM REST API function. The following includes UserDeliveryPreferenceArray but I've successfully subscribed without this. I'm just including it because I want to be notified if feedback is left: OAuth Method (requires contacting eBay to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 address from a sales order in Zoho Books into the template of the Package Slips. Why? It took me a while of playing about with the placeholder reference fields in the template before Zoho advised on a 'hidden' away setting which was key to changing what...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 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 fix for the error: Execution Failed UnPredictable exception, Invalid...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Embed Forms/Reports on a Pagehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 styling // embed a form loading... // embed a report loading... // // embed using IFRAME: allows for content refreshing with openUrl to target iframes on a page // embed a form // // embed a report // // // embed a published form, the parameter is...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Populate a Multi-Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-creator-populate-a-multi-lookup.html

18 August 2022 This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, you can parse the multi-line into a nice HTML table. But on a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 that are currently listed in a client's eBay store; we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory... How? So we're going to use a ZohoCRM function to get this file which we can run on demand. Why...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST CARD // Send in as payment endings: eg. $100.00 == payment approved 00 Payment Approved 01 Payment Declined //...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *