Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Field w/ Dynamic Field Conditions possible?

Topic Labels: Formulas
1397 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Alina_Sigitova
4 - Data Explorer
4 - Data Explorer

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
Tristan_Scifo
6 - Interface Innovator
6 - Interface Innovator

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