Can't Update a linked field for a record, error

[jonathan_conrad]

I’ve written the following script code to update the linked field for a given record in a list, but the script view is giving me an error.

Script:

jonathan_conrad:

I’ve written the following script code to update the linked field for a given record in a list, but the script view is giving me an error.

Script:
let table = base.getTable(“Order Line Items”);
let inputConfig = input.config();
for (let record of inputConfig.Records) {
await table.updateRecordAsync(record, {
“Custom Location”: inputConfig.customLocationID[0]
});
}

Error: The expected type comes from property ‘Custom Location’ which is declared here on type ‘{ “Add-on Bronze Medals”?: string; fld13Q43cUf7VfuBG?: string; Location?: string; fld2SoBeNE8RPE6bX?: string; “95 Paracord”?: string; fld2cl7RGT9zRifPW?: string; “Custom Notes”?: any; fld3Pev0cukPjrrRM?: any; … 79 more …; fldzp8aQGfuWXm1aT?: { …; }; }’

Type ‘string’ is not assignable to type ‘{ id: string; }’.(2322)

[kuovonne]

The write format for a linked record field is different for Scripting App/Automations compared to Update Automations and the REST API. You need to use an array of objects with record ids.

It isn’t clear what value you are receiving from inputConfig.customLocationID[0], but it is probably a string, and not an array of of objects. Are you using the search automation action to get the customLocationID? If so, I recommend that you do the search within the script itself, instead of using the search action. That will give you better access to the actual records and their ids.