Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Integrations
22527 14
cancel
Showing results for 
Search instead for 
Did you mean: 
brent_flanders
5 - Automation Enthusiast
5 - Automation Enthusiast

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

14 Replies 14
Jonathan_Fuller
6 - Interface Innovator
6 - Interface Innovator

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.

brent_flanders
5 - Automation Enthusiast
5 - Automation Enthusiast

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)

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…)

brent_flanders
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Bryan_Douglas-H
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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

Jarno_Nousiaine
4 - Data Explorer
4 - Data Explorer

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

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

Shannon_Johlic
5 - Automation Enthusiast
5 - Automation Enthusiast

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.