How to create a drop-down list from a lookup field

When creating a record, in a table such as an Opportunity, and the Company has been entered (related/lookup table), how do you display a field based on the Contacts related to the Company - in a drop-down menu - to pick a single or multi value

3 Likes

Ive asked about this as well! Definitely a much needed function as it is literally the ONLY thing keeping me from being able to convince my colleagues to use this as our CRM…

I’d actually go a step further and say that there needs to be the ability to “Call” a Related/Lookup within the Formula field as well as be able to use the current Lookup field as a “Link” to the record rather than just Text.

1 Like

Agreed, and this with a few more functions (events, triggers, etc.) I could make this a full functioning CRM, especially with the Slack integration (that also needs some customization)

1 Like

I’m looking forward to when they get the cross-base capability rolling so that we can setup specific Bases for the information and can clean up the general look of the Base being used.

Have you found any integration (other than just designing a PHP/similar API triggered page) for using as a more polished Front End facade? Most of our users just get overwhelmed by the sheer amount of information immediately presented that they end up not inputting things correctly (or at all…)

1 Like

Even when using the “Form” view to customize an input UI?

Yes, mainly because the Form View doesn’t allow for updating an existing record… Most of the input that’s needed for their part is updates and linking to existing records.

1 Like

Did you ever get an answer to this - or get it working?
Thanks

1 Like

Did you get the answer guys? Really need to do this to use Airtable as a backend service for data collection app. Any help or direction would be much appreciated.

Thanks

2 Likes

Hello, just purchased the plus plan to try this out bit more.

I thought this would definitely be a feature, it is not?

Sadly, this is a MUCH needed feature and yet not supported yet. Would love to get this kind of feature rolled in (or a way to do it with some fancy formulas.)

Been recommending this to colleagues who don’t code and all of them have been wanting this ability.

Just to clarify - I have an organization table and a contact table associated with the organization table. I have multiple contacts per each organization. I then have a communication table and I want to choose the organization and then have a drop down that shows only the contacts from that organization to choose from - so I guess you are all saying that this would be a drop down list based on choosing the organization. Yes - I want the same thing and I would like this available in a form so when I add a communication record in a form view I would choose the organization I am talking with and would only want to view the contacts with that organization and choose one contact only from a drop down list. At present a form will not even let me add a lookup table to the form. any input will be appreciated.

No solution for you using a form view — but your base layout seems ready-made for this approach for grid views. You should be able to implement it with minimal change to your existing tables (but do so first on a duplicate of your working base! :wink: )