Ragic Logo
<< Link fields from parent sheets Table of Contents Custom action buttons >>

Dynamic Filtering

Similar to Ragic's cascaded selections, you can set options connected to another linked field in a different sheet, depending on what is selected previously. The values in these fields can update dynamically according to values on other sheets that they are linked from.

You can set this type of dynamic filter for fields that already have a link created with link & load, or alternatively, link from another sheet with the select from other sheet field type.

To create this dynamic filter, navigate to your form page's design mode, and from Form Tools, click on the gear next to the related sheet name under the Link & Load category.

This will show you the setting to create a dynamic filter. Select a field value on the sheet that you're linking from, and match it depending on your requirements with the value or criteria that is going to be filtered from the sheet you're linking to. You can set multiple conditions by clicking on the + sign below the configuration, or enter a custom criteria with the pen tool next on the right.

Example: Display fields that have the same status

In our example below, we want to offer VIP services depending on the customers' loyalty program. The service request form can only select customers that belong to a certain loyalty program so we set the "VIP Club Membership" field on the Customers sheet to be filtered by the service type offered on the Service Request field.

After a Service Type is selected, only the customers that belong to the related VIP club are displayed.

These dynamic filter rules can be set on fields that are linked as a subtable as well.

Example: Display fields that fit into a date range

In our example below, the sales order form can only display products in the subtable that is linked from the product sheet that are currently running under a sales promotion. This promotion date range is set on the products sheet, and we check to see if the current date is between the start date and end date. This allows you to set promotion dates beforehand for products.

Top of Page
<< Link fields from parent sheetsTable of ContentsCustom action buttons >>
Learn more about Ragic: Why we created Ragic | Webinars | User Guide.
Keep in touch: Blog | Email | Facebook | Twitter.
Ragic, Inc. | +1 888-666-8037 | Terms | Privacy