I am having issues showing only certain records from a different table.
Table A: Pets
Table B: Medications (2 views: all medications & active medications)
Active Medications view is filtered to where ‘Currently Taking?’ is checked. I successfully cannot see unchecked records in this view.
In Table Pets, I have created a Link to Table Medications. I have allowed linking to multiple records. Record selection is limited to ‘Active Medications’ view. They are all grid views. In Table Pets, it lists all medications, not just the ones marked active.
I have looked at: support.airtable. com/hc/en-us/articles/206452848#limit-selection
I see the notice in the Medications filter that it is linked.
I tried to look at if it is possible with a formula since this didn’t seem to be working for me.
What am I doing wrong?