Trigger: On record deleted

Language: English

The On record deleted trigger starts an automation each time a record is deleted from a specific form. It fires once per record, after the deletion has been successfully saved, including deletions made through data entry, the mobile app, and the API.

The trigger is configured with a single Form. Deleting records of other forms, including sub-forms of the selected form, does not fire the trigger. Note that deleting a record also deletes its sub-form records; only the record of the selected form fires this trigger.

Step data

Every trigger produces a single row of step data: the values that the later steps of the automation — the filter, email, and webhook steps — can reference in formulas and templates.

For this trigger, the row describes the record's state at the moment of deletion. There is no separate _previous snapshot: a deletion has no before-and-after to compare, so the deleted record's last values are the row itself. This means filters like STATUS == "Recovered" or ISBLANK(REGDATE) behave exactly as they would on the record's last saved state.

Column Type Description
one column per form field the field's type The value of each field at the moment of deletion.
_id Text The record ID of the deleted record.
_lastEditTime Date and time The time of the deletion.
_user.name Text The name of the user who deleted the record.
_user.email Text The email address of the user who deleted the record.
_user.id Text The user ID of the user who deleted the record.
_trigger.type Text Always RECORD_DELETED for this trigger.
_trigger.time Date and time The time the event occurred.

If the form is a sub-form, the row also includes a Parent column referencing the parent record.

Formulas referencing _previous are rejected by the editor when the trigger is On record deleted.

Referencing fields

Fields can be referenced by code, by label, or by field ID; we strongly recommend codes. See Trigger: On record added for the full table of field types and their step data values — the values are identical for this trigger.

Reference fields can still be navigated (CLINIC.NAME): the deleted record's reference values point at records that still exist, and navigation joins to their current state.

Because the record no longer exists, notification emails sent by an email step link to the form rather than to the deleted record.

See also

Next item
Filter step