It’s possible to copy single select & multi select options from one field to another base or table as a side effect of copying and pasting cells.

First, in a grid view on your source table, click the field header for the select field (which selects all cells in the field), and press Cmd+C or Ctrl+C to copy the cells.

Then, in a grid view on your destination table, create a new field. Select the topmost cell in the field, and press Cmd+V or Ctrl+V to paste. So long as the destination field is empty and Single Line Text type, pasting a range of cells will also replace the field type and options to be the same as the field you copied.

You can then hit Delete or Backspace to clear the values you just entered in. Even after clearing the values, the type and options for the field that you pasted will remain.

It’s possible to copy single select & multi select options from one field to another base or table as a side effect of copying and pasting cells.

First, in a grid view on your source table, click the field header for the select field (which selects all cells in the field), and press Cmd+C or Ctrl+C to copy the cells.

Then, in a grid view on your destination table, create a new field. Select the topmost cell in the field, and press Cmd+V or Ctrl+V to paste. So long as the destination field is empty and Single Line Text type, pasting a range of cells will also replace the field type and options to be the same as the field you copied.

You can then hit Delete or Backspace to clear the values you just entered in. Even after clearing the values, the type and options for the field that you pasted will remain.

It’s possible to copy single select & multi select options from one field to another base or table as a side effect of copying and pasting cells.

First, in a grid view on your source table, click the field header for the select field (which selects all cells in the field), and press Cmd+C or Ctrl+C to copy the cells.

Then, in a grid view on your destination table, create a new field. Select the topmost cell in the field, and press Cmd+V or Ctrl+V to paste. So long as the destination field is empty and Single Line Text type, pasting a range of cells will also replace the field type and options to be the same as the field you copied.

You can then hit Delete or Backspace to clear the values you just entered in. Even after clearing the values, the type and options for the field that you pasted will remain.

It’s possible to copy single select & multi select options from one field to another base or table as a side effect of copying and pasting cells.

First, in a grid view on your source table, click the field header for the select field (which selects all cells in the field), and press Cmd+C or Ctrl+C to copy the cells.

Then, in a grid view on your destination table, create a new field. Select the topmost cell in the field, and press Cmd+V or Ctrl+V to paste. So long as the destination field is empty and Single Line Text type, pasting a range of cells will also replace the field type and options to be the same as the field you copied.

You can then hit Delete or Backspace to clear the values you just entered in. Even after clearing the values, the type and options for the field that you pasted will remain.

I was surprised to see this worked, but it’s only a temporary solution if your intent is for the options to stay synced across tables even as the single select field of the original is added to or modified. In the absence of support for look up fields to be used for color coding records, a feature I feel should really exist, I’m trying to copy a large single select list to another table, but this work around doesn’t seem like a viable way to maintain keeping single select list consistent and color coded in the same way as the original changes. I mean maybe an automation could deploy this work around to create a new field every single time on a child table when the original changes, and copy and delete all the data every single time, but that seems like a really clunky work around to just try and keep a list usable for color coding across tables.

Hi

Use this to add options and update color. Change table and fields name

const [T1,F1,T2,F2]=['SourceTable','Field1','DestTable','Field2'];

const id_out=({id,...rest})=>({...rest})

await base.getTable(T2).getField(F2).updateOptionsAsync({'choices':

base.getTable(T1).getField(F1).options.choices.map(id_out)});

by way, workaround for single select is that you can generate a list of unique values for every field and also check duplicates and their quantity.

just don’t press “Save”, press “Cancel”. Note that primary field should be duplicated first for such action.