re: Also, the "A_Salesrep ID" is the same thing as the P21 Salesrep ID. They are the same thing so I need to find the sales rep id in airtable and match it with the data in the screenshot and update the YTD sales field. Ex for the picture: Salesrep ID 66902 is in airtable and when this automation is triggered it will find the salesrep ID in airtable and map in & updated the YTD sales of "1010899.750..."
Yeap, on the same page!
re: To make sure I follow, I will have to manually put the below piece into my airtable fields and the script?
Oh nah, the `jsonData` variable in my script is used as an example and needs to be replaced by the result of your API call, and yeap you'll need to update it with your field names and table names!
And so your code should look a little like below:
let jsonData = await [FETCH CODE]
let table = base.getTable("Sales Team");
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);
}
There's going to be a tricky bit here where you need to return the JSON from your API call; if you can DM me a link to a duplicated example base I could install the script for you real quick! I totally understand if there's a security concern, and if it works better we could hop on a quick call with screenshare and we could set it up together!
