Airtable will automatically turn all of your field values into drop-down options when you convert the field to single-select or multi-select.

Thank you for replying. I have read of this, though I don’t believe this is a solution as it is a one-time only, manual event. When the data in the original column is added to or changes, those changes would not be reflected in the drop-down options.

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.

Airtable will automatically turn all of your field values into drop-down options when you convert the field to single-select or multi-select.

I am happy to give this a try, entirely possible I am missing a common function.

To clarify:

• Table A contains a “Fruit” field/column listing 50 fruit names (Apple, Orange, etc.).



• Table B is an empty table which will ideally contain a “Fruit Selection” field (or “column” - I like to use both terms as many users who eventually read this may be coming from an Excel/Sheets or SQL environment, all of which use “column”), which will be a Single-Select drop-down field.

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?

Airtable will automatically turn all of your field values into drop-down options when you convert the field to single-select or multi-select.

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:

• Table A features a single “Fruit” column featuring a list of fruit names.



• Table B features a “Fruit Selection” field/column and does not contain any data - all rows are blank and should remain blank, as this table exists to collect user input from a Form



• The Fruit Selection field is a Single-Select field. The user will select a fruit name from a drop-down field on a Form, and their selections will populate in the Fruit Selection field in Table B



• The Fruit Selection field in Table B should be a dynamic drop-down field that populates its options using the data from the Fruit field in Table A without any manual action by the user. If a value in Table A’s Fruit field is updated or removed, that change is then reflected in the Fruit Selection drop-down field automatically

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 support@airtable.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.

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 support@airtable.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.

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:

• Table A features a single “Fruit” column featuring a list of fruit names.



• Table B features a “Fruit Selection” field/column and does not contain any data - all rows are blank and should remain blank, as this table exists to collect user input from a Form



• The Fruit Selection field is a Single-Select field. The user will select a fruit name from a drop-down field on a Form, and their selections will populate in the Fruit Selection field in Table B



• The Fruit Selection field in Table B should be a dynamic drop-down field that populates its options using the data from the Fruit field in Table A without any manual action by the user. If a value in Table A’s Fruit field is updated or removed, that change is then reflected in the Fruit Selection drop-down field automatically

Is this a function I can achieve natively within Airtable?

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

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 support@airtable.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.