N: Can’t set cell values: invalid cell value for field ‘famille’.
Cell value has invalid format: must be a string
this is my script
//Replace “Code cable” with column name which has the values you want to look up
for (let record of mainTableRecords.records) {
let lookupValue = record.getCellValue("Code cable");
//Replace "Name" with column name which is the range to search in
//Replace "Famille" with columnn name which value should be returned
for (let rangeRecord of lookupRangeRecords.records) {
if (rangeRecord.getCellValue("Name") === lookupValue) {
let returnValue = rangeRecord.getCellValue("Famille");
//Replace "famille" with column name from mainTable which should contain the link
await mainTable.updateRecordAsync(record, {"famille":returnValue
});
}
}
}
