Filter rows
Purpose of this building block
When inserting a table, all of the rows will be inserted. Use the Filter rows building block to display a subset of the rows matching a certain criteria. As JavaScript is used to define the filter you can enter complex conditions or even JavaScript snippets to create the desired filter.
Possible use cases
- Display rows for a certain branch only
Configuration
Click on the reload icon to scan the Google Form for modified, added or removed fields.
Specify the table that you want to filter. If you for example want to apply the filter to data loaded from a worksheet, the table name will be the name of the worksheet.
The script will remove all rows from the table that do not match the given filter criteria. The filtered data is not stored in a new variable, it will alter the table data directly so that you can keep your existing template and simply add the filter to an existing flow.
Only unbound input parameters are activated in the form dialog, so if you are using the script multiple times you may need to activate the table and filter parameters.
Please note that you will have to access the columns by using the row prefix. If you for example have a column called orderid you'll have to use row.orderid in your filter.
Questions and Feedback
If you have any comments on this guide, feel free to add them right to the Google document that we are using to create this site.
If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.
Last Updated:
