Skip to main content

I want an interface with filters and a list of records, but I don’t want the list of records to be visible by default before applying a filter. How can I do this?”

Hey ​@stephane,

 

A workaround you could use is apply a default filter that no record matches. Eg. You found have a “Search” single select field with 2 options (“Draft” and “Search”). Have all you records set to Search. 
 

Set the filter to filter by default field Search to “Draft”. Therefore, no records will load initially. User will need to change the pre set filter from Draft to Search. Only then records will show. 


@stephane 

To clarify what ​@Mike_AutomaticN is saying above:

This won’t work if you apply a default filter to the entire page (at the top of the screen), because the users can’t remove that filter.

With an “entire page filter”, users are only allowed to filter further within the records that are already shown on the screen.

So you can only set a changeable/removable default filter by adding “user filters” to your list — either tabs or dropdowns:

  • Dropdowns would be the best option, because you can set a default filter that the users can change or remove.
  • Tabs are not a good option, because tabs can’t be changed by the user. So you would need to setup the first tab to show nothing, and then they would have to navigate to the other tabs. This is not desirable in your situation.

So the best solution is to set a dropdown user filter, and set the default dropdown search to show no records to start with.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld