Skip to content
aeropage-round-dark
Aeropage Documentation
Queries and Filters

Filters Guide

You can filter a query within the page using variables as well as hardcoded values. Dynamic filters (using variables) can be applied based on the user, dynamic page, calculations or any of the many variables available.

Filter with Components

Let users apply filters in the frontend by adding input components to the page.

‘Quick’ Filter Components

In the components menu, some items allow you to skip the manual process of connecting components, variables, actions etc and simply follow a guided setup.

Untitled.png

Apply on change
By default, filters will be applied automatically whenever the user changes the value. You can have the option toggled off to submit filters by adding a submit filters action.

Untitled 1.png

Apply to Multiple Fields
After setting up the component, you can open it in the editor and apply more than one field to the same filter.

Untitled 2.png


Custom Inputs + Variables

You can also create customized filters by adding input components, then referencing their values (as variables) into the query filter. If you use this method - remember to also add a Reload Query action to make sure the data is refreshed each time the value changes.

Create the input component.

Untitled 3.png

Apply the Input variable to the filter.

Untitled 4.png

The query will not automatically reload when the input value changes. Add a Reload Query action On Change to achieve this functionality.

megaphone
Dont forget to make the query reload when the input value changes.


Create a Filter

You create your filters in the query using the customary logic (find xxx where yyy) and either static or dynamic values (variables). With this method, we are fetching records from the query table and filtering them to only return the records that match the conditions

Click to edit the query, then click to apply filters.

Untitled 5.png

Choose a field to apply the filter to, the operator and the variable or value to filter by.

Untitled 6.png

The resulting query will be :

Get records from [orders] where [customers] contains [customer.id]

blunt-bulb
The records will be returned in the same order as they are displayed in the view.


Records Array

You can also specify which records to fetch from the query table, by providing the ids of the records from a variable.

In this example we are on a dynamic page for a product which has a list of upgrades linked to it.

Untitled 7.png

By passing the Product Upgrades as a variable, we tell the query to fetch only those records.

Untitled 8.png

The resulting query will be :

Get [page.upgrades] from [Upgrades]

blunt-bulb
Because it is more direct, this method is faster and more efficient - but records will be returned in the same order as the linked field, and you can only use one variable in the filter.

Dynamic View (ID)

To use Airtable’s powerful view, sorting and filtering you can pass the view ids into your query.

Steps
Add buttons to the layout for each view.
Create a variable to store the view ID.
Set the value of the variable when a button is clicked.
Add the variable with the view ID to the dynamic view setting.
Test the functionality in preview mode.

Untitled 9.png


Advanced Filtering

By combining the methods above with custom inputs, actions and variables you can achieve a number of advanced filter behaviours.

Filter by Page Relationship

During the setup of a dynamic page, if it’s on a dynamic path you can create an embedded filter based on the relationship between the current page’s data source and any other dynamic page in the path.

blunt-bulb
Because these filters are applied to the page itself, they are always applied before any filters that happen inside the page..

Dynamic Filtering with Active Records

You can create complex, multi stage selection interfaces by connecting the active record from one card to the filter of another. This method can be used to control the display of records, or connected to forms and navigation.

blunt-bulb
Use active records to make dynamic, multi level selections .

Filters with Cards & Custom Arrays

Display cards which when clicked, add or remove the card id from a custom array variable (with Run a function → Toggle Array) then use the custom array in the filters. By doing this you can create your own customized filter components with multiple values.

blunt-bulb
Make a cards filter using custom arrays.

Search multiple fields with Custom Inputs

In some cases, you may want to apply the same variable to multiple filters. You can do this with a custom input.

Create a custom text input.

chrome_d070zzoMHg.gif

In the query filter use the input variable, and apply it as many times as you need.


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.