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
Sep 22, 2020 11:58 AM
Hello,
I am looking for a solution to having dynamic conditions for fields.
Example:
I have a table with attendees and another table with events. I want a count of how many events an attendee has gone to (which is created via a linked field in the “events” table, to the “Attendees” table).
However, I only want a count of how many events they’ve been to AFTER a certain date. That date is dynamic and unique to each participant and lives in the “Attendee” table.
How can I filter the “count” field so that I can only see events that they have attended, but only after a certain unique date?
The current filters in fields are static, meaning any value applied in the field applies to ALL records equally.
Thanks so much for your help!
Dec 06, 2022 04:46 PM
This is a great question, and one I'm still trying to answer myself. Does anyone have a workaround for this?