+7I need help writing the following script:
Tables:
Each time an Enrollment form creates a new record in the Classes table, the script creates a record for each Student in the Grades table. Grades table is a junction table linking Classes and Students tables.
I know there are several community scripts regarding junction tables but I need one that works from just one Class record at a time.
Best answer by Jim_Bain
I finally figured it out:
//Generate Grade record for each Student registered in user-selected Class
let classesT = base.getTable('Class');
let eachClass = await input.recordAsync ('Select the Class', classesT);
let gradesT = base.getTable('Grades');
// for each student in the students array
for (let student of eachClass.getCellValue('Students')) {
// create a grade record
await gradesT.createRecordAsync({
'Class': [{id: eachClass.id}],
'Student': [{id: student.id}]
})
}I finally figured it out:
//Generate Grade record for each Student registered in user-selected Class
let classesT = base.getTable('Class');
let eachClass = await input.recordAsync ('Select the Class', classesT);
let gradesT = base.getTable('Grades');
// for each student in the students array
for (let student of eachClass.getCellValue('Students')) {
// create a grade record
await gradesT.createRecordAsync({
'Class': [{id: eachClass.id}],
'Student': [{id: student.id}]
})
}Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.