Hi @Anxious

If you add the scripting app (this is available in the free plan) to the right side panel. Open it up from scratch and remove all of the default scripts. then add this script

let table = base.getTable("Table")

let multipleSelectField = table.getField('Dropdown');

for (let choice of multipleSelectField.options.choices){

output.markdown(`

${choice.name}

`)

}

Change the Table and Dropdown parts in my script to match the names of your table and dropdown. Then run it. It will output all the options in text.

let table = base.getTable("Table")

let multipleSelectField = table.getField('Dropdown');

for (let choice of multipleSelectField.options.choices){

output.markdown(`

${choice.name}

`)

}

That code was fantastic, thank you! I was able to grab all available choices and format them.

On another note, how do you get the choices that are currently in the fields to be formatted like this: “Choice”, “Choice2”.

I duplicated the multichoice field and converted it to text.

Result:

Choice1, Choice2, Choice3

Now I am looking for a formula field to format the output text.

“Choice1”, “Choice2”, “Choice3”

I have hundreds and hundreds of rows, so doing this by hand is not an option.

Importing and exporting between platforms is a NIGHTMARE. XD

Hi @Anxious

You should be able to take that into a text editing program to format it the way you want.

or you can try something like this

let table = base.getTable("Episodes")

let multipleSelectField = table.getField('Status');

let array = []

for (let choice of multipleSelectField.options.choices){

    array.push(choice.name)

}

output.markdown(`${array}`)