Monthly view by default

[Richard]

I want my applicant tracking system to automatically load the rows FOR THE CURRENT MONTH. I want all other entries hidden somehow.

Users send in entries via a form, the data is sent to a base, and then staff members operate on the data. But there should be some way to set DEFAULT views so that the entire 1000+ rows are not loaded each time.

How do I do this?

[JonathanBowen]

Hi @Richard - you need a view on your table which filters out items more than a month old. You can have multiple views on the same table:

More info here:

Airtable - Support

Guide to views

This article provides an overview of views within Airtable—what they are, why they're important, and how to make new ones. This article is primarily focused on grid views—to learn more about our ot...

There’s a section within this about filtering too

JB

[Julian_Kirkness · Accepted solution]

Hi @Richard

Thinking about this, you are going to need to create a formula which works out whether each record is in the current month (because there is no filter option to do this as standard) and then filter on that formula field - this should work:

Then simply create a view with a filter if {This Month} is Yes…

Hope this helps!

Julian

[Brian_Kinney]

Here’s a statement about choosing the default view from an Airtable employee:

Change Default View Ask the community

You can reorder the views in the menu by clicking and dragging. Bring the view you want to be your default to the top of the list. [rearrange-view]

In my experience with Airtable the default view for each table doesn’t matter much because the web client remembers the view I last used and doesn’t send me back to the default when I switch tables.