Can't get 'Limit record selection to a view' to 'limit'

The important thing to note about limiting record selection to a view is that the limiting behavior isn’t a “live” feature. This has two implications:

First, if records are already linked when you turn that feature on, but they don’t appear in the specified view tied to the limit, they won’t be taken away. The limiting feature only works when adding new linked records to that field, which is why the wording says “Limit record selection to a view” (emphasis mine). For example, the “Research suggests…” article isn’t in the limiting view. If you remove that link, then try to add it again, it won’t appear as an option. You can’t select it as a new choice, but if it was there prior to the limit setting being activated, it still stays.

Second, the limiting feature is only honored in the table where the limit is set. In your base, you’ve set the limit on the {Related reading} field in the [My research topics] table, which means that it will only apply when adding links from that table. Going back to the example above, if you added the link to Topic B on the “Research suggests…” record in [Reading log], Airtable didn’t look to see if it matches the limit set in [My research topics] before allowing it to be added. It just adds it.

@Justin_Barrett Thank you for this beautiful breakdown. Some of this I know, applied before, but totally blanked on. I was trying to force my use case on the feature.

Seems I’ll have to sacrifice linked records if I want the Related Reading field to be “live” as you described, and not a selection of articles associated with topics to choose from. I can isolate the read and relevant articles in the Reading Log table via a formula I’ve used before, then lookup the output in the My Research Topics table. It’s not a tidy solution because eventually, that will result in a huge wall of comma-separated text.

I tried a couple of formulas in the Mock fx field and neither worked. Any idea what the hiccup might be? I appreciate all the help!

Option 1

IF(AND(🧾 Read?,AND({Relevant?}="✔ yes"))(Title),BLANK())

Option 2

IF((🧾 Read?),AND({Relevant?}="✔ yes"))(Title),BLANK())

Option 3

IF(AND({🧾 Read?},AND({Relevant?})="✔ yes")),(Title),BLANK())

IF(AND({🧾 Read?}, {Relevant?}="✔ yes"), Title)

@Justin_Barrett thanks for that! I was over-stuffing :slightly_smiling_face:

…which reminds me, I should probably get off this thing and turn my attention to Thanksgiving. :winking_face:

you should @Justin_Barrett. Enjoy.