Zoho Creator and Deluge Script integrate cloud applications

What is Zoho Deluge Script?

Deluge or Data Enriched Language for the Universal Grid Environment as we call it, is an online scripting language integrated with Zoho Creator.

It enables users to add logic to the application, incrementally, making it more powerful and robust.

The entire database layer is abstracted and you will only speak in terms of forms and fields, while scripting in Deluge.

Zoho Creator creates seamless integrations with the apps and services you need

We begin with your actual situation with prebuilt integrations or powerful APIs custom functions, Zoho Creator works with the apps and services your business needs.

Explore Zoho Creator integration with Zoho Flow and save time

What is Zoho Creator?

Zoho Creator is a low-code app development platform that lets you launch custom, mobile-ready apps.

You can create your own applications to automate workflows, automate internal processes, and manage databases.

What is Zoho Flow?

Zoho Flow is an integration platform that helps you connect your apps without any code.

Automate complex business workflows within minutes.

Set a trigger, add actions, use Delays and Decisions to create your entire workflow on an easy to use builder.

Which app do you want to integrate with your Zoho CRM?

You will see custom connectors designed to integrate Zoho CRM with other business applications. These APi connectors help you transfer data between applications and automate tedious tasks. We continue to add new connectors on a regular basis. So if you can’t find the connector you want, contact us and make your request.


Zoho Creator APi + Zoho Flow to integrate with 550+ apps without writing code.
Automate any tasks that keep you away from what you do best.

Understand integration field

The Integration field enables your users to look up data that’s stored in an external service — another Zoho app or third-party SaaS.

The field features a dropdown menu that displays data from the selected service. It allows your users to select one value from the displayed data. Consequently, the integration field enables you to establish a relationship between the data in your Zoho Creator app and the data in the selected service.


Adding an integration field

Adding an integration field to your form requires you to define (or select, if already defined) a connection to the target external service. You will need to define a few parameters in addition to the Module and Field from which you intend to lookup data.
Integration field lookup data from the following services:

  • Zoho CRM
  • Zoho Recruit
  • Salesforce
  • QuickBooks


Customizing the display fields

Customize the manner in which the integration field displays data. You can have the integration field display the data from up to three fields of selected module. When displaying multiple fields, you can define if any separator is to appear between the field values.

Accessing the field and searching for data

Each time your users access the integration field on your form, Zoho Creator fetches data in real time from the selected module of the external service.

Note: The integration field will display data only when your subscription to the target service (eg: Salesforce, Zoho CRM) allows accessing the target module. For example, imagine that you've subscribed to Zoho CRM's Standard edition and that you've added an integration field that displays data from Zoho CRM's Purchase Orders module. This integration field will not display any data as the Purchase Order module isn't available in Zoho CRM's Standard edition.
With regard to searching the integration field:

  • Your users can search in all the display fields you set
  • At least two characters are to be entered to initiate search
  • Searching more than one display fields is supported. Records that match the inputs in all display fields will be displayed.

The kind of search that will happen depends on the target service and the type of data.


Other field properties

You can perform the following customizations for the user experience of the integration field on your form:
- Change the Connection: You can switch to any other Connection that you have added for the same service

  • Customize the field name and field link name of this field
  • Make it mandatory for your users to select a value in this field
  • Show this field only to the app’s admin (and hide it from other users).
  • Set the field size.
  • Describe this field using a tooltip or help text.


In simple terms, a function is a set of statements grouped together under a name and can be invoked from anywhere within a program. Deluge Scripting supports Functions, using which we can structure the deluge script in a more modular way, accessing all the potential that structured programming can offer. Related functions can also be grouped under a common category based on their purpose, called namespace, which helps in easy maintenance. Functions can be invoked from form/field action scripts or on selected records in a view.


  • A function calling itself (also known as recursive function) cannot be called more than 75 times. If the limit of 75 is crossed, it throws an error “Call Stack limit exceeded”.

 Advantages of using Deluge Functions

  1. Write once and reuse utilities‘Functions’ promote code re-usability of deluge script within an application and even across applications (same user’s applications). It makes the code modular and easy to understand. When you feel like repeating certain scripting functionality across different parts of an application, you can define them as a function and reuse it. With the help of built-in functions provided in deluge, you can create numerous util functions on your own, using the ‘Functions’ support.
  2. Serves as bridge between applications (created by the same user)Not only can you define generic utilities as functions, you can even manipulate the application data from within the functions. Till now, it was not possible to manipulate the data in one application from the script in another application. This is now made possible with the help of functions. In this respect, we can consider application as an object with its data and we can define functions to operate on this data which compares to member functions in an ‘object oriented’ world. The applications can communicate with each other using functions.
  3. Custom action integration in views‘Functions’ has the potential to be integrated into various GUI actions, taking the scripting integration in Zoho Creator to next level. It makes the applications created, much more powerful and alive. As a first step, it is integrated into views under the terminology ‘Custom Actions’. It enables the user to invoke a specific function on selected records in a view.

Deluge Scripting

Unique features

  • User-friendly SyntaxThe Deluge Script syntax is easy to read and understand. So the process of creating powerful application is fun, easy and quick.
  • Code is DataDeluge Script has no concrete syntax. The syntax you see is just a “skin”. The actual code is stored as abstract syntax (i.e a whole bunch of tables) in the database. So in future users will be able to generate the same code in their own favorable syntax. For e.g., Sam can edit the code in the standard Deluge syntax while Lucy can edit the same code in her favorable Perl syntax.
  • Relational Data ModelApplications built by users have a fully normalized relational data models.
  • Query Integrated LanguageDeluge Script bridges the gap between the program logic written in a high level programming language and the data that it operates upon. It brings the expressiveness of SQL closer to the core application logic. i.e. query is integrated at the language levels.

Save billable and non-billable hours with the Projects Time Sheet module. Save every minute of your hard work, manually or with timers, and our built-in integration with Zoho Invoice will automatically generate invoices from your timesheets.

Perform Form Actions - Deluge Scripting

Perform Form Actions

  • Validate form data before persisting it. For example, in a recruitment application, accept only those applicants who have more than two years of experience.
  • Perform an action after a form data is persisted, both while adding/editing a row. For example, you might want to receive email notifications as and when a row is added.
  • Perform actions on click of the form button using Stateless Forms. For example, fetch data from an external website, on form submit.

Perform Field Actions - Deluge Scripting

Perform Field Actions

  • Modify the form contents dynamically whenever the value of a field in the form is changed. For example, in a Bug Tracker application, display only those team members who belong to the module chosen in the Module picklist field.
  • Perform an action only when the value of a field is modified and persisted in the database. For example, in the case of a bug tracker, you might want to receive email notifications whenever the status of the issue gets modified.

Define Formula Fields - Deluge Scripting

Define Formula Fields

  • Define formula fields for calculations. For example, assume a student database has marks obtained by students in all the subjects and you want to display the total and average marks also.

Create Complex Filters - Deluge Scripting

Create Complex Filters

  • Create complex filters in views.

Define Functions - Deluge Scripting

Define Functions

  • Define Functions and invoke Functions from form/field action scripts or on selected records in a view.

Create Mashups

Create Mashups

  • Deluge Scripting supports tasks that get the web data from one place to another, manipulate and publish XML data to easily create sophisticated web applications.

I've been working with OceanData to customize Zoho CRM Plus for 2 years. It was an absolute pleasure to work with Bruno and his team. The project was delivered on time and in accordance with specifications. OceanData exceeded my expectations in every respect. I will work with them again in the future as well.

Christian G.General Manager of Graphic Communications

Thank you in collaboration, to set up our CRM system and to the continuous assistance of our learning in the use of this powerful tool. The team appreciates your efforts and will recommend your services. Thank you from all of us at SpotEv!

Colin D. HendryFounder-Founder & CSO at SpotEv Specialized in Innovative technologies for Cultural, tourism, hospitality sectors

Few people have the opportunity to report to a manager who is also a coach and mentor — but I did when I worked for Bruno.
I had the pleasure of working with Bruno at Ocean Data, collaborating on project teams.
I was always in awe of Bruno’s ability to command a room and get people on board with ideas — even people who were initially on completely different pages. No matter how tense a meeting, he made sure everyone left with a smile.
As a team member or a leader, Bruno earns my highest recommendation.

Akhil KhanijoMBA, Business Development Manager at Givex

Bruno is customer focused and will deliver a great solution for your needs.

Simon PouliotCommercial accounts manager, Heavy Duty sector