Help

Re: Error: Field [linked record] cannot accept the provided value

Solved
Jump to Solution
970 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Anton_Pettersso
6 - Interface Innovator
6 - Interface Innovator
Hello! I don't understand why the linked field won't accept the value. What am I missing?
Screenshot 2023-09-08 at 11.44.31.png
 
 
//Setup Start
let tableName = "🎵 Tracks"
let linkedField1Name = "Composer(s)"
let linkedField2Name = "Producer(s)"
let compiledLinkedFieldName = "Contributors (-mix)"
//Setup End

let {linkedField1Values, linkedField2Values, recordId} = input.config()

let table = base.getTable(tableName)

let compiledObject = new Object;

for (let record of linkedField1Values){
compiledObject[record] = recordId
console.log(record)
}

for (let record of linkedField2Values){
compiledObject[record] = recordId
}

let compiledArray = new Array;

for (let record in compiledObject){
compiledArray.push({id: record})
}

await table.updateRecordAsync(recordId, {
"Contributors (-mix)": compiledArray
})
10 Replies 10

Rad, this helped me solve a similar issue I was facing regarding linked records in the automation environment.

 

Custom builds for your needs. Reach out if you want to talk!