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!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.