Zoho Deluge - Some Useful Regular Expressions
- Category: Zoho Deluge
- Hits: 51426
A more comprehensive post on some other regex (regular expressions) to format values in Zoho.
How?
Zoho Deluge - Update Creator from CRM
- Category: Zoho Deluge
- Hits: 32290
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>
Zoho Deluge: Check Time Booking Slots
- Category: Zoho Deluge
- Hits: 10295
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
- Hits: 19048
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".
Zoho Deluge - MD5 function
- Category: Zoho Deluge
- Hits: 18442
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?
Zoho Deluge - Hide Reset Button on Form
- Category: Zoho Deluge
- Hits: 13200
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?
Zoho Deluge - Get Full Day Name
- Category: Zoho Deluge
- Hits: 20876
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?Zoho Deluge - Get English Ordinal
- Category: Zoho Deluge
- Hits: 19903
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?