Delete rows from the table that match the specified conditions.
You can specify up to three conditions with parameters. Delete rows from the table that meet all specified conditions.
Unlike the “Filter Display Rows of Table” action, this action deletes both the appearance and the actual data.
Set the Condition Field, Criteria, and Comparison value.
Select the field to be the first condition. The table that includes this field will be the target table.
Choose the comparison method that will be used to evaluate the reference value.
Enter the value to compare with the field’s value. When you make it empty, it compares with the empty value.
You can either specify a direct value or use an expression.
When using an expression, if you specify the field code in the target table, the “Condition Field” and the field specified by the expression will be retrieved from the same row.
Choose these options when you want to define the second and third conditions. If you only need one condition, you can leave out the others.
You must select from the same table as the field specified in Condition Field(1).
Choose these options when you want to define the second and third conditions. If you only need one condition, you can leave out the others.
Choose these options when you want to define the second and third conditions. You can omit these if you only require one condition or want to compare with an empty value.
This Do is not compatible with krewSheet
This action can only run on the “Edit Record” and the “New Record” pages. If executed on other pages, it will result in an error.
You cannot specify more than four conditions.
If the table contains a Lookup field, performing “Delete Rows From Table Providing Conditions” just before saving the record will result in an error.