Description
The add record Deluge task is used in Form action and Field action scripts to insert a new record to a given form with values specified in the expression.
Syntax
on add { on success { <ID> = insert into <formname> [ <fieldname1> = <expression> <fieldname2> = <expression> <fieldname3> = <expression> ];
} } |
where,
<formname> - name of the form to insert a new record.
<fieldname> - the name of the field in the form
<ID> - ID value of the inserted record
<expression> - the field value or a deluge expression that returns a value
Using Script Builder
To add the add record task in Script Builder,
- Select the Form/Field action.
- Drag-n-drop the add record task from the left-side task tree.
- Click on Edit to specify the form name, field names and value in the Edit dialog.
- All the forms in the current application will be listed in the Select Form list-box.
- To specify field values, the Deluge expression builder can be invoked for each field by selecting the "Write Expression" button.
- Click Done to update the values.

Example
The sample code given below adds a new record in the form named "Sample" with fields named Added_User, EmailId and Name. The script is added to the on add -> on success block of the Contact form and will be executed when a new record is added to the Contact form.
form Contact { Name ( type = text )
EmailId ( displayname = "Email 1" type = email )
actions { on add { Submit ( type = submit on success { insert into Sample2 [ Added_User = zoho.loginuser Email_1 = input.Email_1 Name = input.Name ]; } ) Reset ( type = reset displayname = "Reset" ) } } } |
Related Links
Tips & Tricks -> Add Record using Add Record Task