Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Manual selection of Lookup Field Values in Linked Records

Solved
Jump to Solution
109 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rob_Jameson
6 - Interface Innovator
6 - Interface Innovator

hi Airtable users!

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

I have 2 tables (A and B). 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

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2025-01-23 at 8.45.02 AM.png

Screenshot 2025-01-23 at 8.45.09 AM.png

Screenshot 2025-01-23 at 8.49.00 AM.png

Link to base

See Solution in Thread

3 Replies 3
Mike_AutomaticN
10 - Mercury
10 - Mercury

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

TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2025-01-23 at 8.45.02 AM.png

Screenshot 2025-01-23 at 8.45.09 AM.png

Screenshot 2025-01-23 at 8.49.00 AM.png

Link to base

Rob_Jameson
6 - Interface Innovator
6 - Interface Innovator

Fantastic, thank you @TheTimeSavingCo