Skip to main content

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!

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


Reply