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.

Blank Interface - Limiting dropdown selection to linked records

Solved
Jump to Solution
273 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

I have created a blank interface where submissions that come in to the "Requests" table are used as the basis for creating records in the "Jobs" table.
I've identified that the biggest potential for user error is not having the correct Job selected in the right-side dropdown. I'd like to limit the dropdown's selection to only Jobs that are linked to the Request that is selected in the left-side dropdown.
Nothing I've tried so far has worked. Any ideas?Screenshot 2025-01-25 at 9.48.44 AM.png

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, what if you added the record picker from the Request table instead?  Then the available options will be limited to the ones linked to the selected Request, and as an added bonus they won't have to manually link them after that; created Jobs will be automatically linked to the request

Screenshot 2025-01-26 at 10.36.09 AM.png

Screen Recording 2025-01-26 at 10.35.06 AM.gif

Link to base

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

@Ron_Daniel 

Airtable gives a very small amount of control when it comes to limiting the selections in a linked record field based on another field.

This feature is called dynamic filtering in linked record fields, and you can learn more about it here.

However, the much more powerful way to completely unleash this feature is to use Fillout’s advanced forms for Airtable instead of Airtable for your forms.

Fillout is 100% free and it offers significantly more more power & control when it comes to dynamically filtering linked record fields.

Fillout also offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, and much more.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, what if you added the record picker from the Request table instead?  Then the available options will be limited to the ones linked to the selected Request, and as an added bonus they won't have to manually link them after that; created Jobs will be automatically linked to the request

Screenshot 2025-01-26 at 10.36.09 AM.png

Screen Recording 2025-01-26 at 10.35.06 AM.gif

Link to base

Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

@TheTimeSavingCo - I am certain I would not have thought of that solution - THANK YOU!