Zoho Deluge: a HTML Entity Decoder
- Category: Zoho Deluge
- Hits: 25385
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
- Hits: 38517
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
- Hits: 24436
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
- Hits: 27278
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
- Hits: 28029
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
- Hits: 13757
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 some formatting examples:
Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps
- Category: Zoho Deluge
- Hits: 23981
A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds.
Why?
I've done this in lots of other systems but here's one in 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.
Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)
- Category: Zoho Deluge
- Hits: 29695
A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd.
Why?
Irrespective of server, organization or user settings, the date handling can vary. If we are getting a date from a CSV or other external source as "dd/MM/yyyy", how do we guarantee that the system will understand the date correctly?
How?
It may be that when obtaining a date string and applying the method .toString("dd/MM/yyyy") is dependent on the settings. But making a date into a SQL format or from largest denominator to smallest in "yyyy-MM-dd" will usually handle the date better.