The Update function replaces existing data in a record with new data from the app using a reference value.
¶ 1. Steps to create an Update function
- Go to Admin Menu → Database → Data Tables. You will land on the Data Tables List page.
- Select the required data table and click the f(x) icon under the Actions column. You will land on the Data Table Function page.
3. Click + Add New Function. You will land on the Add Data Table Function page.
4. Select Update as the function type and enter a name for the function.
5. Under Input Functions, select the element that should be used to identify the record to be updated.
6. Once an input element is selected, Mapping and Condition fields appear.
7. Set the Mapping value for the selected element. Mapping supports Mapped and Static options.
8. Click the + icon to add more input conditions if required.
9. Set the Condition value for the selected element. Conditions include:
| Condition | When it becomes true |
|---|---|
| Contains | When the field contains the specified value |
| Not Contains | When the field does not contain the specified value |
| Empty | When the field has no value |
| Not Empty | When the field has any value |
| Equal | When the field value matches the selected value |
| Not Equal | When the field value does not match the selected value |
| Starts With | When the field value begins with the selected value |
| Ends With | When the field value ends with the selected value |
10. Select a field from Split on Field if you want to store multi-select or checklist values as separate rows.
11. Under Output Functions, select the element that should be updated.
12. Click the + icon to add more output elements if multiple fields need to be updated.
13. Set the Type as Replace for elements that should overwrite existing values.
14. Click Save to store the update function.
