Customize

Delete Rows From Table Providing Conditions

Summary

Delete rows from the table that match the specified conditions.

How to use

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.

Parameters

Set the Condition Field, Criteria, and Comparison value.

Condition Field(1)

Select the field to be the first condition. The table that includes this field will be the target table.

Criteria(1)

Choose the comparison method that will be used to evaluate the reference value.

Comparison value(1)

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.

Condition Field(2)

Condition Field(3)

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).

Criteria(2)

Criteria(3)

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.

Comparison value(2)

Comparison value(3)

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.

Compatibility with krewSheet

This Do is not compatible with krewSheet

Restrictions

  • 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.

    • If there are no rows to delete, an error will occur if the above conditions are met.
    • This action can be performed at any time except right before saving the record.
    • If the table does not contain Lookup fields, it can be executed right before saving the record.