Core Functions:

• length(string) - Returns string length
• substring(string, start, end) - Extract substring
• replace(string, old, new) - Replace text
• toLowerCase(string) - Convert to lowercase
• toUpperCase(string) - Convert to uppercase
• trim(string) - Remove whitespace
• contains(string, substring) - Check if contains text
• startsWith(string, prefix) - Check prefix
• endsWith(string, suffix) - Check suffix
• split(string, delimiter) - Split into list

Example: name = toUpperCase(substring(input.Full_Name, 0, 10));

Essential Functions:

• today() - Current date
• now() - Current datetime
• addDays(date, days) - Add days to date
• addMonths(date, months) - Add months
• daysBetween(date1, date2) - Calculate difference
• format(date, "dd-MMM-yyyy") - Format date
• hour(datetime) - Extract hour
• minute(datetime) - Extract minute
• year(date) - Extract year
• month(date) - Extract month

Example: due_date = addDays(today(), 30);

List/Map Operations:

• size(collection) - Get collection size
• sort(list, field) - Sort collection
• distinct(list, field) - Remove duplicates
• sum(list, field) - Calculate sum
• max(list, field) - Find maximum
• min(list, field) - Find minimum
• average(list, field) - Calculate average
• contains(list, value) - Check if contains
• add(list, value) - Add to list
• remove(list, index) - Remove from list

Example: total = sum(order_items, "Amount");

CRUD Operations:

• insert into Form_Name values {field1: value1};
• update Form_Name set field1 = value1 where condition;
• delete from Form_Name where condition;
• fetch records from Form_Name where condition;
• count from Form_Name where condition;
• sum field from Form_Name where condition;
• max field from Form_Name where condition;
• min field from Form_Name where condition;

Example: records = fetch records from Customers where Status == "Active";

API & Communication:

• invokeURL(url, method, headers, data) - API calls
• sendmail(to, subject, message) - Send email
• sendSMS(mobile, message) - Send SMS
• getUrl(record_id, form_name) - Get record URL
• openUrl(url, target) - Open URL
• downloadFile(url) - Download file

Example: response = invokeURL("https://api.example.com/data", "GET", headers, "");

Calculations:

• round(number, decimals) - Round number
• ceil(number) - Round up
• floor(number) - Round down
• abs(number) - Absolute value
• pow(base, exponent) - Power calculation
• sqrt(number) - Square root
• random() - Random number

Example: total = round(price * quantity * 1.18, 2);

File Operations:

• getFile(file_field) - Get file details
• uploadFile(file_content, filename) - Upload file
• deleteFile(file_id) - Delete file
• getFileContent(file_id) - Read file content

System Functions:

• zoho.currentuser - Current user info
• zoho.currenttime - Current timestamp
• zoho.appuri - Application URI
• input.field_name - Form input values
• info message; - Display info message
• alert message; - Display alert
• success message; - Display success message

✅ Best Practices:

• Batch Operations: Use bulk insert/update instead of loops
• Efficient Queries: Use specific WHERE conditions to limit records
• Index Fields: Index frequently queried fields
• Minimize API Calls: Batch API requests when possible
• Cache Results: Store frequently accessed data
• Avoid Nested Loops: Use collection functions instead

⚠️ Performance Considerations:

• Large Datasets: Use pagination for large record sets
• Complex Calculations: Consider pre-calculating values
• File Operations: Handle large files asynchronously
• API Limits: Respect rate limits and implement retry logic

Get Started with Zoho Creator:

Ready to implement these functions in your applications? Start your free Zoho Creator trial and begin building powerful business applications with Deluge scripting.

Advanced Development Support:

Need help implementing complex Deluge solutions? Our expert developers can assist with custom script development, performance optimization, and advanced integrations.