Skip to main content

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

});

}

}

}

Be the first to reply!

Reply