I am looking for a solution to having dynamic conditions for fields.
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.