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

*SOLVED* COUNTALL records from the last X days

Topic Labels: Formulas
243 1
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 1

I did this in the end using a COUNT field with a CONDITION