Help

Silent Failure of updateRecordsAsync

Topic Labels: Scripting extentions
867 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Hannah_Cussen
4 - Data Explorer
4 - Data Explorer

I am trying to write a script that will look at 4 fields from an older version, and copy the contents of those 4 fields to a newer version of the same data.
When I run this, the script finishes super fast, and no records are updated. I know that some matches are being found due to the console.log statement. However, when I check my table that is supposed to be receiving the updates, there are no changes.
What is going wrong when I try to update the records?

let oldTable = base.getTable("Updated 4/15/21");
let newTable = base.getTable("Imported 4/29/21");

let oldRecordsQuery = await oldTable.selectRecordsAsync();
let newRecordsQuery = await newTable.selectRecordsAsync();

let oldRecords = oldRecordsQuery.records;
let newRecords = newRecordsQuery.records;

newRecords.forEach((record) => {
  let found = oldRecords.find((old) => old.name === record.name);
  console.log(found);
  
  if (found) {
    let newCalledBy = found.getCellValueAsString("Called By");
    let newCalled = found.getCellValue("Called?");
    let newTexted = found.getCellValue("Texted?");
    let newNotes = found.getCellValueAsString("Notes");
    newTable.updateRecordAsync(record, {
      "Called By": newCalledBy,
      "Called?": newCalled,
      "Texted?": newTexted,
      "Notes": newNotes,
    });
  }
});
1 Reply 1
Hannah_Cussen
4 - Data Explorer
4 - Data Explorer

I solved my own issue, here’s how:
First, I needed an await keyword before the call to updateRecordAsync.
Then, I also had to change the for loop so that it was a for (let i in newRecords) rather than a forEach. Not doing so gave me an error with the await keyword.
Finally, the for (let i in newRecords) gave me an index, rather than the record object, so I had to make sure I was indexing into the newRecords array.

Final code that works (but is very slow):

let oldTable = base.getTable("Updated 4/15/21");
let newTable = base.getTable("Imported 4/29/21");

let oldRecordsQuery = await oldTable.selectRecordsAsync();
let newRecordsQuery = await newTable.selectRecordsAsync();

let oldRecords = oldRecordsQuery.records;
let newRecords = newRecordsQuery.records;

for (let i in newRecords) {
  let record = newRecords[i];
  let found = oldRecords.find((old) => old.name === record.name);
  console.log(found);
  
  if (found) {
    let newCalledBy = found.getCellValueAsString("Called By");
    let newCalled = found.getCellValue("Called?");
    let newTexted = found.getCellValue("Texted?");
    let newNotes = found.getCellValueAsString("Notes");
    await  newTable.updateRecordAsync(record, {
      "Called By": newCalledBy,
      "Called?": newCalled,
      "Texted?": newTexted,
      "Notes": newNotes,
    });
  }
};