The Delete Records from Table action allows you to delete one or more records from a specified table.
To specify which records to delete, you will need to set up a pattern, or a condition, which will match the records you wish to delete. In order to create this condition, you will use the criteria builder.
When you select Open criteria builder, a new page opens listing all the conditions. How does this function delete records? It will look at every record in the table and compare each record to the given conditions. If the record matches the condition, then the record gets deleted.
For more information, please check our article on The Criteria Builder.
The function will go through all the records in each table, comparing each record's RecordID field to the number 5. If it finds a record with a RecordID of 5, then that record gets deleted. Of course, since RecordIDs are unique, only one record gets deleted.
The function will go through all the records in each table, checking if its RecordID field is greater than zero. Of course, EVERY Record ID is greater than zero, so in effect, this will delete every record in the table!
Note that we have changed it to "If ANY of the following are true." The function will go through all the records in each table, checking if the name is either Bob OR Robert. If a record has either of those names, then the record is deleted.
This time, we have added three groups. Note within each group you can set it to Any or All.
A record is deleted only if all three groups are true. If any one of the groups is not true (e.g. Age is 25), then the record is not deleted.