Zoho Deluge

Zoho Deluge - Some Useful Regular Expressions

: Category: Zoho Deluge; 25 March 2019; 31 May 2019; Hits: 51006; Rating:

( 892 Ratings )

What
A more comprehensive post on some other regex (regular expressions) to format values in Zoho.

How?

: Category: Zoho Deluge; 18 February 2019; 18 February 2019; Hits: 31802; Rating:

( 782 Ratings )

What?
This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM.

Why?
I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the responses returned as successful, but the target fields did not update. This was as a result after changing the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer".

How?
I'm going to demo two methods here using the <connection_link>

: Category: Zoho Deluge; 05 December 2018; 05 December 2018; Hits: 10150; Rating:

( 435 Ratings )

What?
Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking.

How?

Zoho Deluge: Loop through 30 Minute Slots

: Category: Zoho Deluge; 30 November 2018; 30 November 2018; Hits: 18904; Rating:

( 569 Ratings )

What?
This code snippet took me a while to do and the documentation is flaky 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 24-hour clock, enable adding to the picklist when the starting hour is found and stop adding when the closing hour is found. The picklist field is called "Time_Field".

: Category: Zoho Deluge; 19 November 2018; 19 November 2018; Hits: 18268; Rating:

( 834 Ratings )

What?
So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task.

Why?
I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a multiline but this would defeat the objective of an Etag).

How?

: Category: Zoho Deluge; 15 November 2018; 15 November 2018; Hits: 13046; Rating:

( 238 Ratings )

What?
So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes:

Why?
Because I can. And because as someone said, a "reset" button is so 1990. I have a confirmation page and don't want the button to show so...

How?

: Category: Zoho Deluge; 08 November 2018; 08 November 2018; Hits: 20676; Rating:

( 385 Ratings )

What?
This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday").

Why?
If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon").

My_Date = today;
Day_Name = My_Date.toString("E");  // returns "Mon"

How?

: Category: Zoho Deluge; 08 November 2018; 08 November 2018; Hits: 19654; Rating:

( 8 Ratings )

What?
This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018".

Why?
Well there's a long a way to do it (but reliable). But being limited to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number of lines used would be an improvement. This is how I was doing it previously.

	// get the date (eg. 1, 2, 3, ... 29, 30, 31)
	This_Day_Date = My_Date_Field.toString("d");

	// determine English ordinal
	English_Ordinal = "th ";
	if(This_Day_Date == "1" || This_Day_Date == "21" || This_Day_Date == "31")
	{
		English_Ordinal = "st ";
	}
	if(This_Day_Date == "2" || This_Day_Date == "22")
	{
		English_Ordinal = "nd ";
	}
	if(This_Day_Date == "3" || This_Day_Date == "23")
	{
		English_Ordinal = "rd ";
	}

	// display
	info My_Date.toString("d") + English_Ordinal;

How?