Conditional Dropdown Selection

Hey guys,
I’m fairly new to airtable, but i’ve read all the posts i could find on this topic, but still stuck.

I have a list of clients and a list of vendors.
some clients prefer only a subset of vendors - i define the preferred vendor relationship in my base design.

I have a form that collects requests to engage a vendor for a quote.

I want :
Basic: Based on client selection to present only relevant vendors in the list.
Advanced: I want to present relevant vendor based on vendor category in addition to the above

what’s the best way to do this with the newly added functionality of logic on lookups / rollups etc?

Thank you guys in advance!!!

Welcome to the community, @Abraham_Davidson! :smiley: First off, you mentioned “the newly added functionality of logic on lookups / rollups etc”, but none of those field types are accessible via forms, or interactively driven by what a user does with a form. Those only come into play once the data from the form is added to the base.

From what I read, you want a system that will dynamically present a culled list based on user selections in a form. However, the new logic available in forms—similar to the logic added for certain field types—only affects field visibility when certain conditions are met. What you want is something that dynamically alters the choices available in Field B when a certain option is chosen in Field A, and that type of control still isn’t available natively in Airtable. For that, you’ll need to use a third-party form setup like the On2Air: Forms system built by @openside.

Hey
Thanks for the reply, definitely what i needed.
i’m pulling the trigger on the on2air i think!

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.