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!!!