Apr 17, 2016 06:07 PM
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
May 02, 2016 09:36 PM
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.
May 03, 2016 07:33 AM
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)
May 05, 2016 09:00 PM
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…)
May 06, 2016 08:48 AM
Even when using the “Form” view to customize an input UI?
May 09, 2016 08:32 PM
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.
Dec 21, 2017 06:21 PM
Did you ever get an answer to this - or get it working?
Thanks
Jan 08, 2018 05:02 AM
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
Apr 09, 2018 06:58 AM
Hello, just purchased the plus plan to try this out bit more.
I thought this would definitely be a feature, it is not?
Mar 18, 2019 07:49 PM
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.
Jun 07, 2019 02:55 AM
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.
Jun 07, 2019 05:46 AM
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! :winking_face: )
May 08, 2020 10:54 AM
Hello guys, I’ve also been looking for a way to do this conditional selection with categories and sub-categories.
Here’s my take on it which is working but might be hard to main if you have a lot of categories and sub-categories: Dynamic Drop down dependent on another dropdown
Let me know if it helps or if we can improve this.
Aug 12, 2021 03:02 PM
@Airtable, fix this please…so frustrated with this flaw in your system that i can’t really use the database.
Jun 16, 2022 07:56 AM
Very sad airtable, very sad.