Help

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

Solved
Jump to Solution
737 0
cancel
Showing results for 
Search instead for 
Did you mean: 
kts
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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.

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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.