Delete rows of a table field
You can delete table field rows when you open the record add screen or edit screen or edit the field. Creation is done from the "actions" tab of the app settings screen.
Configuring an Action
-
Select either a button trigger or a value change trigger and click the "Add new action" button.
-
Enter the Action Name and select the table fields you want to delete rows from the "Delete Table Rows" section.
If you specify an in-table field in the condition of the record in which the action is executed and the in-table field is targeted for execution, the range is limited to the table row that meets the condition.
If you do "Delete Table Rows" and "Formula" at the same time, you need to run the "Delete Table Rows" section first to get the desired result, so be careful about the order of operations.
-
After completing the settings, click the "OK" button at the bottom of the screen, and then click the "Update App" button on the app settings screen.
- References:
Configure conditions for records that perform actions
If you configure a condition, you can execute the action only when the record meets the set condition. Click the filter button to set the conditions for the record for which you want to perform the action.
- References:
-
Notes when specifying the date period in the record filtering condition
Notes when specifying the dropdown field in the record filtering condition
Notes when specifying the lookup field in the record filtering condition
Notes when entering double quotation in the record filtering condition
Configure users who can perform actions
If you configure the execute users, you can execute the action only when the logged-in user matches those users. Click the user button to set the user who has the permission to perform the action.
Execute an Action
In the case of a value change trigger action, the action is executed when the record add screen or edit screen is opened or the field is edited.
- References:
In the case of a button trigger action, the action is executed by clicking the button placed on the record add screen, edit screen, or read-only list view.
Both the button trigger and the value change trigger have a "Delete Table Rows" section, but if the button trigger and the value change trigger have actions on the same field, the value change trigger's result will overwrite it.
If you do "Delete Table Rows" and "Formula" at the same time, you need to run the "Delete Table Rows" section first to get the desired result, so be careful about the order of operations.