How to use the typecast parameter in an automation using createRecordAsync

[Lee_Mandell]

I have the following piece of code in an automation.

            plantingsWateringsRecordId = await plantingWateringTable.createRecordAsync({
                "Watering": [{ id: recordId }],
                "Planting": [{ id: planting.id }],
                "Crop Picker" : {name: planting.getCellValueAsString("Sort Name & Category")}
            })

The Crop Picker field is a single select field and I want it to expand the selections if the value passed in is not already there. It appears that this can be done using typecast:true but I can't for the life of me figure out where to put it. The documentation is not very clear about this.

Any help would be much appreciated.

Thanks

[TheTimeSavingCo]

Ah, `typecast` is available in the Web API, but not in Scripting (which you're using as you're running this in an automation)

In Scripting, you'll need to run updateOptionsAsync like so:

const table = base.getTable("Tasks");
const selectField = table.getField("Priority");
await selectField.updateOptionsAsync({
    choices: [...selectField.options.choices, {name: "Urgent"}],
});

https://airtable.com/developers/scripting/api/field#update-options-async

[Lee_Mandell]

Thank you. It makes sense now. One additional question. if the option is already there will it duplicate it?

[TheTimeSavingCo]

Yeap, that script just creates a new option every time.  If you want to handle duplicates you'll need to pull the current options and check whether the one you want to create already exists I'm afraid