Hey @rcrema!
I'm a bit tired, so apologies if I'm a bit scattered.
First, I would advise that you change the names of your input variables to be lowercase instead of capitalized.
You'll find that the use of capitalization is reserved for use by other JavaScript conventions. This is why the editor colored your input variable names differently.
This code snippet assumes that you've changed the input variable names to be lowercase.
const config = input.config();
const { students, goal } = config;
const table = base.getTable("Enrollment");
const allStudents = await table.selectRecordsAsync({
fields: ["Record ID (from Students)"],
})
.then((records) => records.records);
const filteredStudents = allStudents.filter((studentRecord) =>
studentRecord.getCellValueAsString("Record ID (from Students)" === students[0]))
.map((filteredRecord) => ({
id: filteredRecord.id,
"SEB Goals 2": [
...filteredRecord.getCellValue("SEB Goals 2"),
{ id: goal },
],
}));
if (filteredStudents) {
await table.updateRecordsAsync(filteredStudents);
};
In this script, we query the "Enrollment" table for every student record. All of the record objects are then returned to the allStudents variable.
Next, we filter all the student records to only return the records that match the first entry in the record id lookup.
Once we've filtered our applicable records, we create an array of objects containing the record id and the new linked record value that we will update the record with.
Finally, we conduct a bulk update to all the found records.
Since there is a limit on the number of records we can update at a time (50 per operation), I would normally write in a quick layer to handle the bulk updates when we have more than 50 records.
I've forgone this because you indicated that you're only ever really working with an average of 4-5 records at a time.
If you'd like to continue to use the general script structure that you already have, then you can use something like this:
const settings = input.config();
const table = base.getTable("Enrollment");
let goal = settings["Goal"];
let students = settings["Students"];
const allStudents = await table.selectRecordsAsync({fields: ["Record ID (from Students)"]}).then(records => records.records);
const filteredStudents = allStudents.filter(student => student.getCellValueAsString("Record ID (from Students)") === students[0]);
for (let i = 0; i < filteredStudents.length; i++) {
let recordToUpdate = filteredStudents[i];
await recordToUpdate.updateRecordAsync(recordToUpdate.id, {
"SEB Goals 2": [
...recordToUpdate.getCellValue("SEB Goals 2"),
{id: goal}
]
});
};
I'm currently unable to test either of these scripts, so it's possible that I'm missing something or have messed up some of the formatting, but the idea is the same.
If you want to use either of these, I recommend you read it over and make sure that all the field names, variables, and input variables in your script are compatible.
