All Collections
Hidden Filters
Hidden Filters

Use hidden filters to segment your data with a single block!

Patrick avatar
Written by Patrick
Updated over a week ago

If you need to limit the data a user can see in your app based on who is logged in, you can create a Hidden Filter using custom user fields.

With this simple feature, you can build a dynamic application that shows different data to different users, while keeping all data in a single sheet.

Example: Filter By A Custom 'Team' Field

Your company has three distinct teams accessing the same page in your Frontly app, but you want them to only see the records that relate to their team.

Step 1. Create a Custom User Field called 'Team' on the Users page:

Step 2: Edit the Team field for a specific user

Next, click on a user and adjust the newly created 'Team' field, entering the desired value, which would be a 'Team' name in this case:

Step 3: Create a Hidden Filter

1. From your editing panel, click 'Filters' and you will see the 'Hidden Filter' option. Click 'Add Filter' and it will show the fields for you to set your conditions.

2. In this example, the 'Field' value will be the column that you've created to establish the differentiating data relationship between your defined teams.

3. You will want the 'Operator' here to be 'Equal' to the 'Value' you will establish, but there are many other operators to choose from depending on how you wish to apply the conditions for your hidden filters.

4. Lastly, for the 'Value' field, click the plus symbol on the right of the field to inject a dynamic variable for user Team. In this scenario, you will want to select the 'User' data source and select your custom 'Team' field.


The {{user.Team}} variable in the value field tells the system to grab the Team value from the logged-in user when the app is running live.

This Hidden Filter will compare that value to the Team field in each row of the spreadsheet displayed in this block, and only display records that match.

Additional References

Click here to learn about all the Dynamic Variables
โ€‹Click here to learn about the Data Sources you can use inside your Hidden Filters

Did this answer your question?