I am new to Airtable and haven’t had luck finding a solution for this use case. Is there a native or third-party function that automatically populates a Single-Select or Multi-Select field with the values from a column as selectable options? A manual copy/paste would not work, as the data would need to be dynamic in cases where new data is added to the source column or if one of the column’s values change.
Does it need to be a dropdown? What you’re describing sounds like it could be implemented as a linked record – with the caveat that the “column” that populates the dropdown would have to be its own table, or the primary/name field of an existing table.
Right, linked fields have the same behavior, with the advantage of each option is its own record in another table.
Since you’re new to Airtable, I would highly recommend checking out my free Airtable training course, which covers all of these topics:
I am happy to give this a try, entirely possible I am missing a common function.
Using a form attached to Table B, would a user be able to interact with this Single-Select drop-down field and select a fruit name from it, all of which will be dynamically-populated from the “Fruit” field in Table A? If the value “Apple” in Table A were changed to read as “Green Apple” and the form page was refreshed, would the Single-Select drop-down field display the updated value “Green Apple” rather than the original “Apple” value?
After trying this suggestion, this does not appear to be the behavior I describe above, there may be a misunderstanding as to what is being asked (thank you for your patient responses). An example may be easier to follow:
Is this a function I can achieve natively within Airtable?
Unfortunately, this is not possible in Airtable.
As far as I can tell, this is the #1 most requested feature over the last 5 years in this forum, but it has fallen on deaf ears so far.
Be absolutely sure to send this feature request to email@example.com.
We likely won’t get anywhere if people don’t keep writing to them about this, although we still might not get anywhere even if people do keep writing them about this.
Bro, i was having the same issue and i could solve it with a simple automation:
- Step 1 (When a record matches condition): If "Column B" is empty and "Column A" name is not empty
- Step 2 (Update record):
- Record ID: "Step 1 Record ID"
- "Column B" (Choosing a Dynamic value): "Column A Value"
That will update the field and also create the new value for a single select field