Skip to main content

Hello Airtable community, not sure it is possible, but Gemini says it is)) but when Gemini gives me the sample script and I adjust it and try to use it, it does not work. Here is what I am trying to do. I have a record (contacts database) where I have a multiple select “Status” for this record. And I have another multiple select “Services” with let’s say “Option A”, “Option B”, “Option C” and “Option D”.

When I choose the option “Available” in this multiple select “Status”, I want to the script or automation to limit the options shown in the field “Services”. For example when “Status” is choosen for “Available”, my field “Services” will only display “Option B” and Option D” as an available options to choose from.

Anyone thinks you can help me with some advise?

That is called “dynamic filtering”, but that does not work with single-select fields nor multiple select fields.

That feature only works with linked record fields.

You can read more about this feature in Airtable’s support article here.

- ScottWorld, Expert Airtable Consultant

Hmm I don’t think this is possible with a script or automation I’m afraid.  If you have a paid plan you could try a workaround using new tables and linked fields that should do what you need though!

To get this to work you’ll need to link the Services to each Status like so:

If this looks right to you I’ve set it up here for you to check out! 

 

 

Terms & ConditionsAccessibility statement