Copy all oprtions from a sinlge select and paste it in a new text column

[jpghelfi]

Can someone help me figuring out how I can copy all the options in a single select (my example has 5 options, but assume a have a sigle select with 1000 options), and paste it in another table, as a regular text field? i need this because I want to create a db with all those options, and use link record.. as this info is in many of my forms, and get updated regularly , thanks!

[TheTimeSavingCo]

Try using a scripting block to output all the options:


I broke it out into new lines so you should be able to copy that and paste it into your table and it should be one record per line

let table = base.getTable("Table 1")
let field = table.getField("Type")

let options = ''

field.options.choices.forEach(x => {
    options += x.name + '\n'
})

output.text(options)