
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 06:19 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 04:49 PM
Hmm if you're open to creating a new table, you could use dynamic linked record filtering for this:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 11:35 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 04:49 PM
Hmm if you're open to creating a new table, you could use dynamic linked record filtering for this:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 05:38 PM
Fantastic, thank you @TheTimeSavingCo
