Help

Re: Populating drop-down list with values from a field

396 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Comerford
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

14 Replies 14

Thank you for clarifying. I will take care to make this request, I’m sure the importance of this feature has been stressed by many users over the years.

Coda does it beautifully

Bro, i was having the same issue and i could solve it with a simple automation:

IF

- Step 1 (When a record matches condition): If "Column B" is empty and "Column A" name is not empty

Then

- 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

But the trouble there is that Column A and Column B in Sean Comerford's scenario come from 2 different tables. Your Step 1 has two conditions based on a single table. 

That's exactly what I came here looking for. I have a long and frequently changing list of ongoing projects that users must select from. If I have to maintain the dropdown by typing in and deleting the choices for "Option 1" "Option 2" "Option 3" etc in that field, it's not going to work. No movement from Airtable yet?