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!
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)
