Is it possible to automatically change view filters at a set interval?

[kts]

I have a view that contains records filtered just by the coming week. Is there a way, maybe with scripting, to automatically advance the dates in the filter by 7 days, so each week the filter automatically updates with the current week’s records?

Thank you!

[kuovonne · Accepted solution]

Welcome to the Airtable community!

You cannot automatically change the condition, but you can use a flexible condition that is relative to the current date so you do not need to change the condition.

You can set the condition for the formula to be within a set number of days. That way you do not need to edit the filter.

If you condition is more complex than the view conditions can handle, you can create a formula field based on TODAY() and filter on the results of the formula.