
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2023 06:14 AM
Hi there. Has anyone figured out how to filter records in Interfaces for current week? I want to summarize values for this ongoing week and don't really know how right now. Thanks!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2023 12:02 PM
OK, I was a dumb***. Of course we can still use formulas and have a formula calculate if it is the current week.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2023 09:19 AM
The only way I have been able to do this was to create a filter with 2 conditions. one that has a Starts on or after x date and another that starts on or before x date.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2023 11:49 AM
Thanks. But the date you're comparing to is not dynamic, right? So the user has to set the current week, it's not automatically assigned by Airtable.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2023 12:02 PM
OK, I was a dumb***. Of course we can still use formulas and have a formula calculate if it is the current week.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2023 03:48 AM
But does the table update itself? So it puts all of the numbers to 0 that were 1 previus week?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2023 03:57 AM
Yes 🙂 Airtable formulas are instantaneous
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2023 04:53 AM
Oh ok thanks helped a lot actually.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2023 07:54 AM
I found a problem with this tacric so when a new year starts You will have 2 weeks with the same week number.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 24, 2023 02:22 AM
You mean that different years can span across the same week?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 24, 2023 04:24 AM
Yes so next year when the same week comes you will have this week and the same week from a year ago both labeled with 1. Hope that makes sense
