Hi @The_Focus_Forward_Pr - I think a then...catch approach should do what you want, something like:

await table.updateRecordAsync(a, {
        'Single select': {name: selectValue}
    })
    .then(() => {console.log('this worked')})
    .catch(err => console.log('this failed', err))   

A good article here explains it better than I can :slightly_smiling_face:

https://lucymarmitchell.medium.com/using-then-catch-finally-to-handle-errors-in-javascript-promises-6de92bce3afc

You can check if the option exists for the single-select field.

You can get the list of choices from the field.

const singleSelectField = table.getField("Name of Single Select Field")
const choiceNames = singleSelectField.options.choices.map(choice => choice.name)

You can then do different actions depending on whether or not the choice exists.

let myValue = "something"
if (choiceNames.includes(myValue)) {
  await table.updateRecordAsync(record, {
    [singleSelectField.name]: {name: myValue}
  }
} else {
  console.log(`Choice ${myValue} does not exist for field ${singleSelectField.name}`)
}

By the way, you indicate that you are updating records one at a time in a loop. As you get more comfortable with coding, you may want to consider reworking the script so that the loop creates an array of records to update, and then updates them in bulk outside of the loop. Updating records in bulk will speed up your script execution time.

const singleSelectField = table.getField("Name of Single Select Field")
const choiceNames = singleSelectField.options.choices.map(choice => choice.name)

let myValue = "something"
if (choiceNames.includes(myValue)) {
  await table.updateRecordAsync(record, {
    [singleSelectField.name]: {name: myValue}
  }
} else {
  console.log(`Choice ${myValue} does not exist for field ${singleSelectField.name}`)
}

Thanks, I tried this, but I’m getting a type error:

Argument of type ‘string’ is not assignable to parameter of type '“Alderson FPC” | “Aliceville FCI” | “Allenwood Low FCI” |…

My constants are set up like so:

const knownPrisonsField = table.getField("Post-Sentence Prison");
const knownPrisons = knownPrisonsField.options.choices.map(choice => choice.name)

And the relevant part of what’s left is here:

                        if (postSentencePrison != newPrison){
                            if (knownPrisons.includes(newPrison)){
                                output.markdown(`*Updating location of ${name} from ${postSentencePrison} to ${newPrison}*`)
                                await table.updateRecordAsync(record, {
                                    "Post-Sentence Prison": { name: newPrison},
                                }
                            } else {
                                output.markdown(`${newPrison} not found in list of prisons. You may need to add it manually.`)
                            }
                            };

I can also include how I set vars like newPrison from the API and existing records if helpful

await table.updateRecordAsync(a, {
        'Single select': {name: selectValue}
    })
    .then(() => {console.log('this worked')})
    .catch(err => console.log('this failed', err))   

Thanks! Would I need to declare a Promise or something before putting something like this in, or is that implied? I’m not familiar with the promise-then-catch syntax

Can you post a screen shot of the issue? If you try to run the script, does it run?

Sometimes the editor puts squiggly red underlines on code that actually runs just fine.

Never mind. It wasn’t running but I tried erasing and re-writing it and it works fine now. Must’ve been a misplaced bracket or something somewhere. You’re right, that error tooltip is still present, but the script now seems to work. Thanks for your help!