I actually used CodeAcademy's JavaScript course way back when and really liked it, so you could check that out if you want! It's been awhile though, so I don't know whether it's still as good as I remember, you know what I mean?
Personally, I learn faster when I'm working on something that I actually need to use instead of a more abstract course, and a lot faster when I've got something to poke at heh, and in that spirit I threw something together for you here which should do what you want (You should be able to view the code in the automation I created). It doesn't handle the case of the JSON including a sales rep ID that doesn't exist in your table though!
And here's the code itself:
let jsonData = [
{ "A_Salesrep ID": "A1", "YTD Sales": "5.1" },
{ "A_Salesrep ID": "B2", "YTD Sales": "3.08" },
{ "A_Salesrep ID": "C3", "YTD Sales": "81" }
];
let table = base.getTable("Table 1");
let query = await table.selectRecordsAsync();
let salesRepRecords = {};
query.records.forEach(record => {
salesRepRecords[record.getCellValue("P21 Salesrep ID")] = record.id;
});
let updates = jsonData.map(data => ({
id: salesRepRecords[data["A_Salesrep ID"]],
fields: {
"YTD Sales": parseFloat(data["YTD Sales"])
}
}));
while (updates.length > 0) {
await table.updateRecordsAsync(updates.slice(0, 50));
updates = updates.slice(50);
}
I'm sure there's a more elegant way to handle this / write it and would love any feedback too!
