The edit record statement modifies one or more field values on an existing record in a Creator form without requiring the user to open and re-submit the form. Scripts use it to update status fields, increment counters, populate calculated values, or synchronise field data based on changes elsewhere in the application.
The syntax is FormName[ID == targetRecordID].update({"FieldName": newValue});. The criteria in square brackets identifies which record or records to update. If the criteria matches multiple records, all matching records are updated. The update triggers the target form’s On Edit trigger unless the disable workflow clause is used.
A common Deluge pattern is to use add record to create a child record and then immediately use edit record on the parent to update a related field such as a count or status. For example, when an approval record is created, an edit record statement on the parent request sets its Status field to Under Review. This keeps data consistent across related forms without requiring separate user actions.
Aaxonix is a certified Zoho implementation partner based in Pune. Architecture-first, no surprises.