Built-in Functions
This guide will help you with the following:
- String functions
- Numeric Functions
- Boolean string functions
- Date Functions
- Time functions
- List Functions
- Map Functions
- XML Functions
- URL Functions
- Form Data Functions
A function is a set of code, that takes a finite number of input and optionally returns a value.
String functions
Functions that operate on string expression are classified as string functions, they include functions for finding the length of a given text, remove certain words from a text etc.
In all the given functions, the original string is not changed by the functions, whereas only the return value is affected by these functions.
In all the given functions, the original string is not changed by the functions, whereas only the return value is affected by these functions.
Note:
- In the above table, <string>,<string1>,<string2>, <substring> are all <string expression>
- Behavior of toString()when applied to datetime value:
- <date/datetime>.toString() function on date/datetime will output date string in the format specified in the application setting.
- If you want to override it, you can use <date/datetime>.toString("date format as string"). eg. toString("dd-MM-yyyy")
- If you wish convert to string in different timezone, you can use <date/datetime>.toString("date format as string","<Time Zoho>"). eg. toString("dd-MM-yyyy","Asia/Calcutta")
- The Date and Time pattern strings are mentioned below,
- Date - dd
- Month - MM (or) MMM (or) MMMM
- Year - yy (or) yyyy
- 12 hour format - hh
- 24 hour format - HH
- minute - mm
- second - ss
- AM/PM marker - a
Numeric Functions
Functions that operate on numeric values are classified as numeric functions:
In all the given functions, the original number is not changed by the functions, whereas only the return value is affected by these functions.
Boolean string functions
These functions operate on two string expression and return a boolean expression.
Date Functions
Time functions
List Functions
Map Functions
XML Functions
URL Functions
Form Data Functions
The sample application GetFieldNames uses the getFieldNames() and getFieldValue() functions in Form A -> on add -> on success block . The script iterates each list value (field name) and gets the value of this field. The field name and value is updated in a user variable "fieldNameVsVal" and used in the message block of the sendmail() task.
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Custom Functions
Custom functions are user built functions that help them to add new features to Zoho CRM as per their requirement. These are written in deluge script and are easy to construct. The syntax and logic are simple to formulate and aid in the continuous ...Functions
This guide helps you with the following: Create Functions Normal Functions REST API Functions Invoke Functions Edit Functions Delete Functions Rest API Functions Authentication Version 2.0 Version 1.0 Example Comparison of Version 2.0 and 1.0 ...Custom Functions
The guide will help you with the following: Create Custom Functions Program Custom Functions Test Custom Functions Associate with Workflow Rules Manage Custom Functions Custom functions help in automation where procedural logic is required, which ...Logical Functions
The guide helps you with the following: 1. Difference between isBlank(), isNull() and isEmpty() functions 2. Equals 3. isBlank 4. isEmpty 5. isNull 6. isValidObject Difference between isBlank(), isNull() and isEmpty() functions The table below lists ...Client Functions
This guide will help you with the following: 1. Hide | Show 2. Enable | Disable 3. Add | Append 4. Select | Deselect 5. SelectAll | DeselectAll 6. Clear items 7. Alert 8. Reload 1. Hide | Show Overview The hide deluge task hides a specified field on ...
New to Zoho LandingPage?
Zoho LandingPage Resources