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

1

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

2

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.

scrnli_26-4-2024_06-31-44
scrnli_26-4-2024_06-31-442880×1508 422 KB

scrnli_26-4-2024_06-31-58
scrnli_26-4-2024_06-31-582880×1508 381 KB

I look forward to hearing from you.

Jannis

3

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

Thank you so much!

4

Hi @Jennifer_Biggs,

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

Jannis