Filtering a relation table column based on the value of another column

I have a Main Table which I will call Table A that has a long list of names in the Name column as well as another column that has a checkbox we will call Checkbox1. I have a second table that we will call Table B where I want to create a Relation column where I can pick from the list of names from Table A. I was able to do this first part, but what I want is to only have names show up in the list where the Checkbox1 is checked/true. This is what I have not been able to figure out. I even created of view of Table A that filters it based on Checkbox1 being checked. The problem is you cannot select the table view from the Relation column. I am sure there is a way to do it with a formula, but I can’t seem to make it work.

Any help would be appreciated. Thanks

Hi @Jennifer_Biggs,

please let me know if that is how you visualized it:

I simply set a filter at the Relation column in the second table that only lets you select rows where the checkbox is true.

I look forward to hearing from you.


Thanks for your quick reply. That is exactly what I needed and I got it working in my doc.

Thank you so much!

Hi @Jennifer_Biggs,

I’m really happy to hear that you got it running and everything is working now.


@Christiaan_Huizer Solved :white_check_mark:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.