Recent updates to built-in functions in Deluge

Hello everyone,

Deluge offers more than 200 built-in functions for widely performed actions, like adding specified number of business days to a date, removing extra leading & trailing spaces in a text, and so on. You can refer to our help documents and flashcards to learn more.

We have now expanded the built-in functions set available in Deluge by supporting 11 new functions. These new functions are available in all Zoho services that support Deluge. Let us take a look at them:

Text functions

Built-in function	Description	Example
getPrefixIgnoreCase	Gets prefix of the specified search text in the input text. This function performs case-insensitive search.	inputText = "Zoho Deluge"; searchText = "DELUGE"; info inputText.getPrefixIgnoreCase (searchText); // Returns "Zoho "
getSuffixIgnoreCase	Gets suffix of the specified search text in the input text. This function performs case-insensitive search.	inputText = "Zoho Deluge"; searchText = "ZOHO"; info inputText.getSuffixIgnoreCase (searchText); // Returns " Deluge"
replaceAllIgnoreCase	Replaces all occurrences of the specified search text in the input text with the specified new text. This function performs case-insensitive search.	inputText = "Zoho Creator Zoho Creator"; searchText = "CREATOR"; newText = "Deluge"; info inputText.replaceAllIgnoreCase (searchText, newText); // Returns "Zoho Deluge Zoho Deluge"
replaceFirst IgnoreCase	Replaces the first occurrence of the specified search text in the input text with the specified new text. This function performs case-insensitive search.	inputText = "Zoho Creator Zoho Creator"; searchText = "CREATOR"; newText = "Deluge"; info inputText.replaceFirstIgnoreCase (searchText, newText); // Returns "Zoho Deluge Zoho Creator"
reverse	Returns a text with the characters of the input text in reverse order.	inputText = "Deluge"; info inputText.reverse(); // Returns "eguleD"
repeat	Returns a text with the input text repeated for the specified number of times.	inputText = "Deluge"; repeatCount = 3 info inputText.repeat (repeatCount); // Returns "DelugeDelugeDeluge"
isAscii	Checks if all characters of the input text are valid ASCII characters.	inputText = "ZohoßDeluge123"; info inputText.isAscii(); // Returns false

Number functions

Built-in function	Description	Example
frac	Returns the fraction part of the input number.	inputNumber = "24.6"; info inputNumber.frac(); // Returns 0.6

Date functions

Built-in function	Description	Example
nextWeekDay	Returns the next immediate date from the input date that falls on the specified day.	inputDate = '22-Jul-2021'; // is a Thursday inputDay = "Sunday"; info inputDate.nextWeekDay (inputDay); //Returns 25-Jul-2021
previousWeekDay	Returns the immediate previous date of the input date that falls on the specified day.	inputDate = '22-Jul-2021'; inputDay = "Tuesday"; info inputDate.previousWeekDay(inputDay); //Returns 20-Jul-2021
subBusinessDay	Subtracts the specified number of business day from the input date.	inputDate = '21-Jul-2021'; businessDays = 5; weekends = {"Sunday"}; holidays = {'20-Jul-2021','19-Jul-2021'}; info inputDate.subBusinessDay (businessDays, weekends, holidays); // Returns 13-Jul-2021

You can keep track of all the new releases, bug fixes, and improvements from our release notes. Do let us know your questions and suggestions in the comments.

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Topic Participants
Ramya B

Sticky Posts
Function #41: Sync Associated Subforms!
Welcome back everyone! The last custom function showed how to update a Contact with Product details from it's Related list in Deals. This week, let's look at a function that lets you update subform records in two modules simultaneously when one of them is updated. Business scenario Let's look at how subform helps in an education institution that has deployed Zoho CRM. National Public School, Austin (made up, of course!) has set up Zoho CRM and it follows the same relationship pattern of "Students",