Delete many records
The "Delete Many Records" allows users to remove several records from a specified table by one tap on the action button.
What is it?
The "Delete Many Records" action is a powerful feature that allows your app to delete multiple records from a specified table in one go.
This action is useful when you need to clear out data based on specific criteria, such as removing outdated entries, cleaning up test data, or managing records in bulk.
How it works
When you enable the action to the Record View, there is a menu of action buttons added to the bottom bar of the record view.
You will configure the table whose records will be deleted and set the condition to filter which records will be removed as the result of the action.
The action first evaluates the records in the table against the conditions you’ve set. Only those records that match the specified conditions or condition groups are deleted.
Add the action
From the Design tab, in the Tables section of the left sidebar, click on the Record view of any table.
Go to the Action section on the right sidebar, and click the + button.
Enter the name and icon for the action button, then click Configure...
Click + Then... and choose Delete many records.
Configure the action
In Table, choose the table from which you want to delete records as the result of the action. Ensure you select the correct table, as the deletion process cannot be undone.
In Delete all records that match, you define the conditions to filter the records that will be deleted.
To add a new condition, choose + Add condition or + Add condition group
What is condition and condition group?
Condition: A single criterion that defines a filter. It consists of a column, a condition type, and a condition value.
Condition Group: A set of conditions grouped together. You can link multiple condition groups using logical operators (OR or AND) to refine your filter further.
To add a condition
Click + Add condition
Choose a column as the filtering criteria
Choose the condition type that best suits your needs such as equals, contains, greater than, less than, etc.
Input the specific value or range of values that will be used for filtering.
If you need to apply multiple filters:
Click the “Add Condition” button and modify the same steps as the previous one
Configure the relation between conditions using :
"and" to require all conditions must be true, or
"or" to require any condition must be true.
To add a group filer
Click + Add condition group
Within the group field, click the + button on the right end to add a new condition to the group
Configure the condition of the group with the same steps as the single condition configuration.
Configure the relation between a single condition-group, group-group, and condition-condition inside a group using the:
"and" to require all conditions must be true, or
"or" to require any condition must be true.
the relation is configured by once to be applied for all the following
Require confirmation
Requiring a confirmation on the execution of the action can give users the chance to reconsider and avoid accidental taps.
You can also customize the confirmation message or use the default one.
Completion
In the settings of completion, you will configure
The message on succession to your users can be a way to communicate as well as engage with your users, elevating the user experience with your app.
Checkbox to enable the Confetti interaction like a celebration for the succession, making the experience more fun and rewarding.
Last updated
