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!