Filter Accross Reference

User Support
1

Hello there,

So this is the scenario.
I have 3 reference tables:
-Activities
-Indicators
-Participants

I have 2 relations table:
-Activity-Indicators: giving me the list of indicators per activity
-Activity-Participant: giving me the participations of individual into activities.

My activity-Participant table has 2 reference columns:
-Activity referenced from the Activity Table
-Participant reference from the Participant Table
I want to add a third Reference column to the Activity-Participant table, referencing to the Activity-Indicator table.
But i want the reference of Activity-Indicator to be filtered by my first column of Activity.
In other word, i want to report the indicators of a specific activity, for a specific participant.

So, what i want, is that the answer from one Reference question filters the possible answers to another reference Table.

Is there a way to do so?

2

Yes, it is!

You have to enable Set validation rules and write a validation formula like this:
[Activity-Indicators].Activities.Title == Activity.Title

This will filter available options based on the selected activity.

2 Likes
3

Thanks!
It worked but with a slightly different syntax: without the […]
Activity.Activity == Activity_Indicator.Activity.Activity

4

Yes, you need brackets only if you have spaces, dashes or other non-standard symbols in the name of the table. So, [Activity-Indicators], but Activity_Indicators

2 Likes
5

Hooo understood!
Thanks!