Zoho Deluge

Zoho Deluge: Generate a loop or list of any size

: Category: Zoho Deluge; 21 October 2022; 21 October 2022; Hits: 27355; Rating:

( 804 Ratings )

What?
This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any size.

Why?
My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week.

How?
As mentioned, using leftpad takes 2 parameters, the first is the string to start with, the second is the number of spaces to pad with.

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros

: Category: Zoho Deluge; 08 February 2022; 08 February 2022; Hits: 35139; Rating:

( 740 Ratings )

What?
A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt this deserved its own article.

Why?
A client wanted the discount displayed on a template and if they gave 10% discount, it would display as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, and display 12.5% instead of 12.50%.

Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function.

How?
If we're not going to use loops, then the next best thing I'm aware of is a regular expression.

Zoho Deluge: a HTML Entity Decoder

: Category: Zoho Deluge; 27 January 2022; 27 January 2022; Hits: 23851; Rating:

( 912 Ratings )

What?
A very quick article to document a HTML Entity decoder in Zoho Creator.

Why?
Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded HTML entities. (Zoho if you're listening) Ideally, Zoho may add this to their zoho.encryption namespace such as zoho.encryption.htmldecode(string). But at time of print, it doesn't exist and in the meantime, I've made a function that does this.

How?
Not sure how else to do this but I simply wrote a function in Zoho Creator for each instance that I knew a HTML entity would be submitted. So it doesn't decode every HTML in existence, only the ones I know will happen.

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)

: Category: Zoho Deluge; 16 December 2021; 16 December 2021; Hits: 35733; Rating:

( 747 Ratings )

What?
A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge.

Why?
The use-case here is that we want local sense dialing where specific numbers are used both for outbound and inbound but local to the customer and we want to remind our customer that they have an appointment in 1 hour with us.

How?
The code is actually pretty straightforward but you will need to follow these steps to get the credentials:

Zoho Deluge: Calculate start and end of Daylight Savings Time

: Category: Zoho Deluge; 07 December 2021; 07 December 2021; Hits: 22977; Rating:

( 568 Ratings )

What?
An article to document how I calculated the start and end dates of when Daylight Savings Time is in effect.

Why?
Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them.

How?
I will use this to amend and refine but here's the snippets for the various DSTs around the world.

Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday

: Category: Zoho Deluge; 02 November 2021; 02 November 2021; Hits: 25572; Rating:

( 104 Ratings )

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 few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on.

How?
We're going to get today's date, then use the .addDay(), check none of these are a Sunday, and move the next few days along:

Zoho Deluge: Generate List of TimeZones

: Category: Zoho Deluge; 19 October 2021; 19 October 2021; Hits: 26159; Rating:

( 733 Ratings )

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 this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form.

How?
So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop through removing HTML tags and while we're at it, storing it in a list for Zoho Deluge:

Zoho Deluge: Push a value to a datetime field in CRM

: Category: Zoho Deluge; 29 September 2021; 10 September 2021; Hits: 13044; Rating:

( 839 Ratings )

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: