One thing is missing: the await keyword in front of the update command. Not waiting for each record to update before attempting to update the next record is likely why only a handful of records were updated. Try this modification:
let tb = base.getTable("Curators");
let query = await tb.selectRecordsAsync();
for (let record of query.records) {
let url = record.getCellValue("Curator Link");
let text = record.getCellValue("Curator Name");
if (url) {
await tb.updateRecordAsync(record, {
"Curator with Link": "[" + text + "](" + url + ")\n"
})
}
}
The downside to this method is that the total update will take a long time. Waiting for records to update means that only 2-3 records per second can be updated. A better option is to collect all updates into an array, and update them in batches of 50. Here’s the change to make that happen:
let tb = base.getTable("Curators");
let query = await tb.selectRecordsAsync();
let updates = [];
for (let record of query.records) {
let url = record.getCellValue("Curator Link");
let text = record.getCellValue("Curator Name");
if (url) {
updates.push({
id: record.id,
fields: {
"Curator with Link": "[" + text + "](" + url + ")\n"
}
});
}
}
while (updates.length > 0) {
await tb.updateRecordsAsync(updates.slice(0, 50));
updates = updates.slice(50);
}
