Nov 02, 2021
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?
Go to Solution.
Nov 03, 2021
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