+3I 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!
Best answer by kuovonne
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.
+29Welcome 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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
