Skip to main content
Solved

Manual selection of Lookup Field Values in Linked Records

R

hi Airtable users!

I have a question regarding custom selection of Lookup Field Values in Linked Records.

I have 2 tables (A and 😎. I setup a Linked Field and then 2 lookup fields in table A. This pulls in a Group name Category names from B.

Now in Table A, I'd like to manually choose a specific Categories (based on categories from the lookup field).  The steps I'm trying: I choose a group (in the linked field), and then choose categories manually... but I can only see how to show ALL categories in the lookup field OR categories that meet certain conditions. 

But this is not what I want... I want to choose only specific categories, which vary for each record. There are no conditions for this.

How would I do this? Maybe there is a formula?  Please help!

How can I choose specific values based on a lookup field?

Thank you

Best answer by TheTimeSavingCo

Hmm if you're open to creating a new table, you could use dynamic linked record filtering for this:

Link to base

View original
Did this topic help you find an answer to your question?

3 replies

Mike_AutomaticN

Hey @Rob_Jameson!

You cannot choose what to show on the lookup, other than with the setting of conditions within the lookup.

If you'd need to manually select or choose a given Category in Table A, you could have:
(i) A formula for it in Table A, where the format is shown as single select. This would only be possible if there is some logic around what option should be shown.
(ii) A single select field in Table A, which could be updated via automation also depending on given logic. -by having a single select field you could make changes to the selection as needed.

I feel that I am still missing some context, so feel free to share the actual use case or an example with real values, and maybe even screenshots (can be showing dummy data).

Hope this helps!

Mike, Consultant @ Automatic Nation

R
1 person likes this
  • R
    Rob_Jameson
TheTimeSavingCo
Forum|alt.badge.img+18

Hmm if you're open to creating a new table, you could use dynamic linked record filtering for this:

Link to base

Adam, Consultant @ The Time Saving Co
R
1 person likes this
  • R
    Rob_Jameson
R
  • Rob_Jameson
  • Author
  • Known Participant
  • 10 replies
  • February 5, 2025

Fantastic, thank you @TheTimeSavingCo 

TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo

Reply


Most helpful members this week

Terms & Conditions