Hi there, has anyone figured out a way to do this? I’m looking for the same thing… I was poking around in automations and I can see that you can theoretically add the single-select field’s color into a new single-select field, but when I do so, rather than update the color, it writes it out as a single-select option (“blueLight1”). I’ve got a two tables that do different things, but want them to have the same single-select fields and values as each other, so that at the interface level, the client sees the same colors associated with the same options across the board. Any insights appreciated!

Hey ​@annebocc,

If you get to the conclusion that that is not possible (I did not play around with it, but I believe that is the case) you might want to assess the following alternative:

Create a new table called Options.
On the Name (primary field) of such table, make sure to list all options that you would have as single selects.
Also include a colored emoji before at the very start of the option’s name.
Rather than using single select fields on your table, use linked record fields, linking to the Options table.

This is not exactly the same, but you get the best out of both worlds colors (using the emoji) and unique same values (given that both fields are linked to the exact same table).

Not ideal, but easier to maintain and scale!

Feel free to grab a slot using this link if you need help setting this up or have any other question. I’d be happy to help!

Mike, Consultant @ Automatic Nation

Oh, also you might want to submit your request for the missing feature using this Product Idea form!

Try using a script extension for it:

let settings = input.config({
    title: `Copy select field options`,
    items: [
        input.config.table("table", { label: `Table` }),
        input.config.field("copyField", { parentTable: `table`, label: `Select field to copy options from` }),
        input.config.field("pasteField", { parentTable: `table`, label: `Select field to paste options into` }),
    ],
});

let { table, copyField,pasteField } = settings;

const options = copyField.options 
const cleaned = options.choices.map(({ id, ...rest }) => rest);


await pasteField.updateOptionsAsync({choices: cleaned})

To use it, add a Script Extension block then paste in the code and select the fields you want to copy and paste into.  This is irreversible though, so I’d suggest you test it out a couple of times until you’re comfortable before using it in production!

Nice ​@TheTimeSavingCo! I like the approach!!

Mike, Consultant @ Automatic Nation 

oh wow ​@TheTimeSavingCo  this looks amazing! Is there a way to tweak it so I can do this between two different tables? I want to copy the contents of three single select fields in my “Categories” table to three single-select fields in my “Budget & Taxes” table. IS that possible?

Yeap sure, try this:

let settings = input.config({
    title: `Copy select field options`,
    items: [
        input.config.table("sourceTable", { label: `Source Table` }),
        input.config.field("copyField", { parentTable: `sourceTable`, label: `Select field to copy options from` }),
        input.config.table("destTable", { label: `Destination Table` }),
        input.config.field("pasteField", { parentTable: `destTable`, label: `Select field to paste options into` }),
    ],
});

let { table, copyField, pasteField } = settings;

const options = copyField.options 
const cleaned = options.choices.map(({ id, ...rest }) => rest);


await pasteField.updateOptionsAsync({choices: cleaned})