Adding Records

Overview

Zoho Creator offers you the flexibility to add new records to your database, in multiple ways.  You can add records directly through your ZC Forms, add records by sending an email to your ZC Form's email address, add records by importing data from excel files, add records by executing Deluge Sript or add records using Zoho Creator APIs.

1. Add records through online HTML Forms

Zoho Creator provides drag-n-drop Web Form Builder to easily create custom HTML Forms in minutes. You can access the online HTML form from your PC or right from your mobile. The data submitted through these forms will be directly added to your database. Refer the Help Link Zoho Creator User Guide > Access the application > Add Records   for more information.

If you do not like the default positioning of the form fields, you can customize the same using the Zoho Creator Client API and create your own custom form. The Client API allows field level embedding to customize the look of your HTML forms to suite your website. Each field in the form can be individually positioned, providing a perfect fit and finish to your web page. Refer the Help Link Zoho Creator Client API for more information.

2. Add records through Email

Every form in Zoho Creator has its own email address, so you can just sent an email to submit form data. Zoho Creator checks for form updates via e-mail, once in every ten minutes. The data submitted through e-mail will be directly added to your database. Refer the Help Link Zoho Creator User Guide > Access the application > Email Data  for more information.

3. Add record by importing from an Excel file

If you want to create an online database application from your .XLS files, you can paste data from these files and directly create your application with Form and Data. Comma separated values (.csv) or Tab separated values (.tsv) stored in other file formats can also be used to create your application with data. Refer the Help Link Create New Application -> Importing Data for more information.

You can also add new records to an existing application by importing data from a .xls, .csv, .tsv file. Refer the Help Link Access the application -> Import and Export Data for more information.

4. Add records dynamically by adding Deluge Script

Zoho Creator offers the flexibility to add dynamic data to your web forms by writing a bit of Deluge Scripting. The add record Deluge task offers the flexibility to add new records to a form, with the given values or with dynamic values and is triggered by form actions, field actions or functions. For example, the script can be executed when form data is submitted or when a field value is updated or from user-defined functions . A few common scenarios where the add record Deluge task can be used:

• To add data submitted from different Stateless forms in one main table. Refer the Help topic  Stateless forms for more information.
• To add a record to a form by invoking a Custom Action in the view. Refer the Help topic Tips & Tricks -> Adding Records for more information.

5. Add records using Zoho Creator APIs

Zoho Creator - RPC Web API allows client applications to add record to a Zoho Creator form, using the HTTP POST method. You can add multiple records to multiple applications and multiple forms, at a time.

The Deluge postURL task can be used to add a new record to another Zoho Creator application, using Zoho Creator API. Refer the Help topic Tips & Tricks -> Add Record using API, for more information on using the POST URL task with Zoho Creator XML RPC API.