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
Apr 08, 2020 10:32 AM
Scenario:
Airtable is used to track visits to a facility.
I have a base set up with 3 tables:
People
Visits
Punch Cards
People is linked to Visits and Punch cards
I’m pulling an array of all dates a person visited the facility via a rollup function into the People table.
In the Punch Card table, I’m using a lookup to bring in the array.
In the Punch Cards table, I want to return the count of all visits that took place within a specified date range (the valid range of the punch card before it expires).
For example, if a person visits the facility 3 times- in April, May, and Jun, but the date range the punch card is valid is for April, the count should be 1.
Example base here: https://airtable.com/shrmvP5cBpAknjW1f
Jan 12, 2021 06:47 AM
I’m looking for something very similar. Creating a database for a food pantry and they want to track new Visitors each week. I have a an Events table that tracks each Visitor and then I want to count the number of Visitors by Create Date. So Count the number of visitors where the Event Date is the same as the Visitor Create Date.
With no CountIf function, I can’t find a way.