Skip to product menu
Zoho.com
English
Sign In
Get Started
SIGN IN
Get Started
Learn Deluge
Try Now
Functions
Resources
Join us for the biggest low-code event of the year.
Register now!
x
Skip to main content
Learn Deluge
Try Now
Functions
Resources
Get Started
Deluge
The fastest programming language for developers
Choose where you’d like to start
Introduction to Deluge
Zoho services which support Deluge
Data types
Text
Number
Decimal
Boolean
Date-Time
Time
List
Key-value
Collection
File
Zoho Creator fields' data types
Operators
Arithmetic operators
Logical operators
Relational Operators
Assignment operators
Creator fields and their applicable operators
Variables
Expressions
System Variables
Send notifications using Deluge
Send SMS
Send push notifications
Send mail
SMS Integrations
Integrations
Custom integrations with any Zoho or external service
Connections
Invoke URL
Pre-defined integrations with Zoho services
SDP Cloud integration tasks
Create Record in SDP Cloud
Get Records from SDP Cloud
Get record by ID from SDP cloud
Update Record in SDP Cloud
Associate Record in SDP Cloud
SDP Cloud Invoke URL
Zoho Analytics integration tasks
Create a row
Delete a row
Update a row
Zoho Billing integration tasks
Create Records
Get organization from Zoho Billing
Fetch records
Fetch record by record ID
Update record
Zoho Bookings integration tasks
Get Workspaces from Zoho Bookings
Get record by ID from Zoho Bookings
Get Related Records from Zoho Bookings
Get available slots from Zoho Bookings
Create appointment in Zoho Bookings
Update record in Zoho Bookings
Zoho Books integration tasks
Get Organizations
Create record
Fetch records
Fetch record by ID
Update record
Get Templates
Mark Status
Zoho Calendar integration task
Create event
Zoho Cliq Integration Tasks
Create record
Fetch records
Fetch record By ID
Update record
Delete records
Delete record using the record ID
Post to Bot
Post to Bot as an admin
Post to Channel
Post to channel as admin
Post to chat
Post to Chat as admin
Post to User
Edit Message
Extension properties tasks
Zoho Cliq Integration Attributes
Posting to Zoho Cliq
Zoho Connect integration tasks
Add a post
Get post
Get post using a third party ID
Update a post
Delete post
Add a comment
Add users to group
Fetch groups
Fetch networks
Send a private message
Zoho Creator Integration Tasks
Get Records
Get Record by ID
Create record
Update Records
Update Record
Zoho Creator V1 Integration tasks
Get records from Zoho Creator V1
Create record in Zoho Creator - V1 task
Update Record in Zoho Creator - V1 task
Zoho CRM integration tasks
Create Record in Zoho CRM
Get Records from Zoho CRM
Fetch Record from Zoho CRM using record ID
Get Related Records from Zoho CRM
Search Records in Zoho CRM
Update Record in Zoho CRM
Update related record in Zoho CRM
Bulk Create Records
Update records in bulk in Zoho CRM
Attach file
Convert Lead
Upsert record
Zoho CRM Vertical Solutions Integration Tasks
Get All Module Metadata in Zoho CRM
Get Module Metadata in Zoho CRM
Get Organization Information in Zoho CRM
Get Organization Variable in Zoho CRM
Get User Data in Zoho CRM
Invoke Connector Task in Zoho CRM
Set Organization Variable in Zoho CRM
Zoho Desk Integration Tasks
Create record
Create Related Record
Fetch records
Fetch Record By ID
Fetch related records
Fetch related records by ID
Search Records
Update Record
Update related record
Merge tickets
Move a ticket
Split a ticket
Zoho FSM integration tasks
Create Record in Zoho FSM
Get Records from Zoho FSM
Fetch Record from Zoho FSM using record ID
Get Related Records
Search Records
Update Record in Zoho FSM
Get Transitions
Update Transitions
Zoho Inventory Integration Tasks
Create Record In Zoho Inventory
Get organization from Zoho Inventory
Mark status in Zoho Inventory
Get Records From Zoho Inventory
Get Records By ID from Zoho Inventory
Update Record In Zoho Inventory
Zoho Invoice Integration Tasks
Create record
Fetch Records
Fetch record by ID
Update record
Zoho Mail integration tasks
Create folder in Zoho Mail
Get folders from Zoho Mail
Move to folder in Zoho Mail
Set Flag in Zoho Mail
Remove Flag in Zoho Mail
Mark As Read in Zoho Mail
Mark As Unread in Zoho Mail
Get Message from Zoho Mail
Create Tags in Zoho Mail
Get labels from Zoho Mail
Set Tag in Zoho Mail
Zoho Map Integration Tasks
Geocode
Reverse Geocode
Distance Between
Zoho Notebook Integration Tasks
Create Notecard In Zoho Notebook
Zoho People Integration Tasks
Create Record
Get Records
Get Record By ID
Update Record
Zoho Projects integration tasks
Create Record in Zoho Project
Get Records From Zoho Projects
Get Record By ID From Zoho Projects
Update Records in Zoho Projects
Create Project in Zoho Projects
Get Portals From Zoho Projects
Get Project Details From Zoho Projects
Associate Logs in Zoho Projects
Update Associated Logs in Zoho Projects
Zoho Recruit integration tasks
Create record
Fetch records
Fetch a record by ID
Search records in Zoho Recruit
Update record
Upload files to Zoho Recruit
Zoho Sales IQ integration tasks
Visitor session - set
Visitor session - get
Zoho Sheet Integration Tasks
Create record
Get records
Update record
Find text
Get sheets
Insert CSV
Replace text
Zoho Sign Integration Tasks
Create and send documents using template ID
Get Document By ID
Update document in Zoho Sign
Download document
Get IDs of fields
Get template by ID
Get templates
Submit request
Upload document
Zoho WorkDrive Integration Tasks
Upload File In Zoho Workdrive
Create Folder In Zoho WorkDrive
Create Team Folder In Zoho WorkDrive
Zoho Writer Integration Tasks
Get documents
Upload document
Share documents
Get merge fields
Merge and send documents
Sign document
Get all fields
Merge and sign
Merge and store V2
Merge and invoke
Mark or unmark as favorite document
Rename document
Enable or disable track changes
Add or update description
Lock or unlock documents
Mark document as ready
Mark or revert final documents
Get merge templates
Get sign templates
Get fillable templates
Sign Document V2
Generate Fillable Link
Merge and send V2
Send SMS
Send SMS using Clickatell
Send SMS using ClockworkSMS
Send SMS using Hoiio
Send SMS using SMS-Magic
Send SMS using Twilio
getUrl
postUrl
invokeUrl
invokeUrl function
invokeAPI
Deluge tasks
Artificial Intelligence Tasks
Analyse Sentiment
Translate
Find Named Entities
Parse Address
Parse Phone Number
Predict Language
Recognize Text
Detect Face
Detect Object
Keyword Extraction
Creator Blueprint Tasks
Blueprint Attributes
Change Stage
Execute Transition
Conditions
Conditional statements
Criteria in conditional statements
Data Access
Add record
Fetch records
Fetch records
Fetch a field's value
Fetch all values of a field
Collection variable
Criteria to fetch records
Aggregate functions on fetched records
Average
Count
Distinct
Maximum
Median
Minimum
Sum
Update multiple fields
Update record
Delete records
For each record
Accessing form fields using input
old
Composite fields and their usage in Deluge
Client Functions
Focus
Hide | Show
Enable | Disable
Add | Append
Select | Deselect
SelectAll | DeselectAll
Clear items
Alert
Reload
Miscellaneous
Cancel Delete
app language identifier
getFieldNames
getFieldValue
Set Variable
Set field value
Call function
Send mail
return deluge task
Success message
Cancel submit
Break
Continue
Try-Catch
Debug
Info
List Manipulations
Create List
Create list of specific data type
Add
Remove index
Remove element
Add all | Remove all
Clear
Sort
For each element
For each index
notContains
Map Manipulations
Create map
Put
Put all keys
Remove key
Clear map
Subform Tasks
Insert rows in Subform
Clear rows in Subform
Access fields in subform rows
File upload field tasks
Actual name
content
User roles & properties tasks
App Admin Tasks
Fetch email address of app admin
Fetch username of app admin
App User Tasks
Assign profile to app user
Delete app user
Determine profile of logged-in app user
Fetch email address of logged-in app user
Fetch profile name of app user
Fetch profile name of logged-in app user
Fetch role of app user
Fetch username of logged-in app user
Logged-in User Tasks
Determine profile of logged-in app user
Determine profile of logged-in portal user
Determine role of logged-in user
Fetch email address of logged-in app user
Fetch email address of logged-in customer portal user
Fetch profile name of logged-in app user
Fetch profile name of logged-in portal user
Fetch username of logged-in app user
Get username of logged-in portal user
Portal Admin Tasks
Fetch email address of portal admin
Fetch username of portal admin
Portal User Tasks
Assign profile to portal user
Delete portal user
Determine profile of logged-in portal user
Fetch email address of logged-in customer portal user
Fetch profile name of logged-in portal user
Fetch profile name of portal user
Get username of logged-in portal user
XML manipulation
executeXpath
openUrl
File Functions
compress
extract
getFileContent
getFileName
getFileSize
getFileType
isFile
setCharset
setFileName
setFileType
toFile
Built-in functions
Collection functions
clear
containsKey
containsValue
delete
deleteAll
deleteKey
deleteKeys
distinct
duplicate
get
getKey
getLastKey
insert
insertAll
intersect
isEmpty
keys
percentile
size
sort
sortKey
toCollection
update
values
notContains
Date-time functions
totalMonths
yearFraction
totalYears
daysBetween
addBusinessDay
nextWeekDay
previousWeekDay
subBusinessDay
addBusinessHour
hoursBetween
addHour
addDay
addMinutes
addMonth
addSeconds
addWeek
addYear
day
days360
edate
eomonth
getDate
getDateTime
getDay
getDayOfWeek
getDayOfYear
getHour
getMinutes
getMonth
getSeconds
getTime
getWeekOfYear
getYear
hour
isDate
minute
month
monthsBetween
now
second
subDay
subHour
subMinutes
subMonth
subSeconds
subWeek
subYear
timeBetween
toDate
toDateTime
today
toStartOfMonth
toStartOfWeek
toString
toText
toTime
unixEpoch
weekday
workday
workDaysBetween
workDaysList
yearsBetween
toDateTimeString
Time Functions
addHour
addMinutes
addSeconds
getHour
getMinutes
getSeconds
subHour
subMinutes
subSeconds
timeBetween
toString
toText
Encryption functions
SHA1
aesDecode
aesDecode128
aesEncode
aesEncode128
base64DecodeToFile
base64decode
base64encode
hmacsha1
hmacsha256
md5
sha256
sha512
HMAC-SHA512
HTML Decode
HTML Encode
XML Decode
XML Encode
Functions which return a boolean value
contains - text function
containsIgnoreCase - text function
endsWith - text function
endsWithIgnoreCase - text function
equals - logical function
equalsIgnoreCase - text function
matches - text function
notContains - text function
startsWith - text function
startsWithIgnoreCase - text function
contains - list function
containKey - map function
containValue - map function
isBlank - logical function
isNull - logical function
isEmpty - logical function
isValidObject - logical function
isDate - type check function
isFile - type check function
isNumber - type check function
isText - type check function
List functions
add
addAll
average
clear
contains
distinct
get
getAsString
indexOf
intersect
isEmpty
largest
lastIndexOf
median
nthLargest
nthSmallest
rank
remove
removeAll
removeElement
size
smallest
sort
subList
toJSONList
toList
toListString
Logical functions
Difference between isBlank, isNull and isEmpty functions
equals
isBlank
isEmpty
isNull
isValidObject
Map functions
clear
containKey
containValue
get
isEmpty
keys
put
putAll
remove
size
toMap
notContains
Number functions
Degrees
Radians
abs
frac
truncate
acos
acosh
asinh
signum
atan2
atanh
cosh
tanh
asin
atan
average
ceil
cos
exp
floor
isEven
isNumber
isOdd
largest
log
log10
max
median
min
nthLargest
nthSmallest
percentile
power
randomNumber
rank
round
sin
smallest
sqrt
tan
toDecimal
toHex
toLong
toNumber
sinh
toWords
Text functions
getPrefixIgnoreCase
isAscii
ltrim
repeat
replaceAllIgnoreCase
replaceFirstIgnoreCase
rtrim
concat
contains
containsIgnoreCase
endsWith
endsWithIgnoreCase
equalsIgnoreCase
find
getAlpha
getAlphaNumeric
getOccurenceCount
getPrefix
getSuffix
indexOf
isEmpty
lastIndexOf
left
leftpad
len
length
matches
mid
notContains
proper
remove
removeAllAlpha
removeAllAlphaNumeric
removeFirstOccurence
removeLastOccurence
replaceAll
replaceFirst
right
rightpad
startsWith
startsWithIgnoreCase
subText
substring
text
toDate
toDecimal
toJSONList
toList
toListString
toLong
toLowerCase
toMap
toNumber
toString
toText
toTime
toUpperCase
trim
getSuffixIgnoreCase
Reverse
HexToText
Type check functions
isDate
isFile
isNumber
isText
Type conversion functions
toCollection
toDate
toDateTime
toDecimal
toJSONList
toList
toLong
toMap
toNumber
toString
toText
toTime
Utilities
encodeUrl
urlEncode
urlDecode
XML & JSON functions
get vs getJson
getJSON
toJSONList
toMap
toXml
toXmlList
Difference Between Deluge Tasks
Alert and Info
Deluge editor
Deluge preferences
Deluge error messages
Deluge release notes
Built-in functions
Functions which return a boolean value
Functions which return a boolean value
Text Functions
contains
containsIgnoreCase
endsWith
endsWithIgnoreCase
equalsIgnoreCase
matches
notContains
startsWith
startsWithIgnoreCase
List Functions
contains
Map Functions
containKey
containValue
Logical Functions
isBlank
isEmpty
isNull
Number Functions
isEven
isOdd
Type Check Functions
isDate
isFile
isNumber
isText
Get Started Now
Execute