Help

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

Field w/ Dynamic Field Conditions possible?

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

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!

1 Reply 1

This is a great question, and one I'm still trying to answer myself. Does anyone have a workaround for this?