Search Loop
The Search Loop block allows you to search a table and filter the results based on a specific field and condition.
For example, when searching for a duplicate, you can search on a text value for a match.
To use the Search Loop block, you need to:
- Select a table.
- Choose a field from the table.
- Select a condition from the following options:
- Equal to
- Not equal to
- Contains
- Does not contain
- Greater than
- Less than
- Greater than or equal to
- Less than or equal to
- Enter a value for the condition.
The Search Loop block will filter the table based on the selected field and condition, and then loop through all of the records that meet the criteria.
For example,
Suppose you want to loop through all of the customers in the Customers table who live in the state of California. You could use the Search Loop block to do this by selecting the Customers table, the State field, and the Equal to condition. Then, you would enter the value California in the value field. The Search Loop block would then loop through all of the records in the Customers table where the State field is equal to California.
Every Search Loop block must be closed using a Continue (For/Search) block. Anything between these two blocks is considered part of the loop.
