Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Feb 05, 2021 11:36 AM
I am building a gym membership system.
People pay for X visits which they can use in a 30 day period.
When they arrive, they check in (which adds a record).
I want to count the number of records for a member (COUNTALL)…
…but I only want to see how many records in the last 30 days.
Blaggin my head trying to work out how I can do it.
Any ideas?
Feb 05, 2021 01:48 PM
EDIT
I did this in the end using a COUNT field with a CONDITION