Deluge or Data Enriched Language for the Universal Grid Environment is an online scripting language integrated with Zoho Creator. It helps you to add different types of business logic to the function and make it more powerful. The entire database layer is abstracted and you will only map the arguments with fields, while scripting in Deluge. See Also Deluge Script - Reference Guide

Target Audience

• CRM Users with Manage Automation permissions
• Programmers with Deluge Script knowledge

Availability

To test the function integration

1. Add test data in CRM according to your workflow rule criteria.
2. In your application check for the data received from Zoho CRM via function.
3. If there is an error or data mismatch, modify your function code in Zoho CRM.
4. Continue this test until you obtain the required data from Zoho CRM to your Application.

Important Notes

• You can associate up to 6 (1 Instant Action and 5 Time-Based Actions) Functions per workflow rule.
• You can transfer data for a maximum of 10 CRM fields from Zoho CRM to third-party applications using function.
• You can retrieve data from other Apps to Zoho CRM using function.
• You must update the API ticket regularly according to limits in third-party applications.
• You will not receive any email notification, if the function integration stopped functioning due to any issue in a third-party API.
• If there is any failure in the process, function will send a notification first, Zoho CRM system will send a second notification after 15 min. Thereafter, the system will not send any notifications for that particular workflow trigger.
• If you exceed the maximum count per day, the system will not send remaining function notifications to third-party applications and will notify thw failure to Administrator. 
• Zoho CRM will the send the data in following standard format for Date and Date Time fields to third-party applications:
  • Date: yyyy-MM-dd
  • Date Time: yyyy-MM-dd hh:mm

Understanding Deluge Script Builder

The Deluge Script Builder helps you to program the Functions using drag & drop user interface and execute the function within CRM. It enables you to convert the complex application logic into simple deluge code, without remembering the syntax and functions of Deluge Script. It contains the following components:

• Delug Script Code
• Deluge Tasks
  • Conditions
  • Miscellaneous
  • Debug
  • List Manipulation
  • Map Manipulation
  • Web Data
  • XML Manipulation
• Code Execution

List of Deluge Tasks

Example

Business Scenario: Roll up the amount field to parent account when the potential status is "closed won"

Summary

Roll-up amount from each potential (status is closed won) to Total Revenue (custom field) field of the related Account. If customer buys 10 times, you can view the total revenue from Account page, instead of pulling a report linking Potentials and Accounts. Based on the revenue from customer, later you can grade them type A, type B, or type C customers.

Programming Steps

• void is the return type that will return nothing
• workflowspace is the namespace in the creator just like a folder to group functions
• Rollup_the_Potential_Amount_to_Accounts is the name of the function
• AccountId is a parameter, which holds the ID of Account in CRM
• SumUpField is another parameter, which holds the field label in Account to which the sum amount is updated while triggering the workflow rule.

• Here we are type casting account id to a string    

• This is a built in method in Deluge Script, which will get the records by searching the field values.
• Here we specified to search rgw Potential record type which matches the Account Id with the value that is passed as a parameter.    

• Initialising a local variable to calculate the sum of amount.

• Iterating all potentials returned by the above method call.

• Fetching the stage field value of each potential.

• Checking the stage value contains "won" for each potential. If it is true, then it will enter to the next line, otherwise go to the next potential.

• Now adding the amount field's value to the local variable       

• This method will update the record in CRM. We mentioned the record type as Account matching the field account id with the passed value with the local variable, which currently holds the sum up value.

Complete Program

1. Log in to Zoho CRM.
2. Go to Setup > Automation > Workflow Rules.
3. Select Deals from the Module drop-down. Enter the name and description to the workflow rule.
   
4. Choose when you want to execute this rule. Select Create or Edit option under execute based on a record action.
   
5. Click Done.
6. Choose to which records you want to execute the rule. Select Records Matcing the conditon option and set the criteria as "Stage contains closed won"
   
7. Click Done.
8. Now choose function as Instant action
   
9. In the Configure function pop-up, click the Customized Functions link.
   
10. In the Customized Functions page, click Configure for Roll-up Potential Amount to Account function.
    
11. Select Potential as your module.
12. Specify values for the arguments as mentioned below:
    • AccountId: Choose "AccountId" column from the list of fields.
    • SumUpField: Specify the field you have in accounts module for the summation.
    • Click "Specify custom value" link and type your field name.
      
13. Save the configuration. This will now automatically update the sum of the revenue generated by all the potentials of an account in the account module.