Jun 10, 2022 09:06 AM
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.
Jun 14, 2022 07:52 AM
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.
Jun 14, 2022 08:41 AM
Coda does it beautifully
May 10, 2023 12:30 PM
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
Sep 17, 2024 09:56 PM
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.
Sep 17, 2024 10:04 PM
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?