-
Notifications
You must be signed in to change notification settings - Fork 10
/
program2assignmentsClassroom.gs
39 lines (33 loc) · 1.44 KB
/
program2assignmentsClassroom.gs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
function addAssignments () {
var s = SpreadsheetApp.getActiveSpreadsheet();
var sh = s.getSheetByName('PROGRAM');
var r = sh.getDataRange();
var n = r.getNumRows();
var d = r.getValues();
for (x=0; x<n; x++) {var i=d[x][0]; if(i==''){continue;}
else if (i=='DD'){
var assignment = {
workType: d[x][13], state: d[x][14], title: d[x][16],description: d[x][17],
materials: [{ driveFile: { driveFile: { id: d[x][9], title: d[x][19] }, shareMode: d[x][18] } }],
maxPoints: d[x][20], scheduledTime: d[x][23],
dueDate: { year: d[x][24], month: d[x][25], day: d[x][26]},
dueTime: { hours: d[x][27],minutes: d[x][28], seconds: d[x][29]}
};
var a = Classroom.Courses.CourseWork.create(assignment, d[x][10]);
var c = a.id;
var id = sh.getRange(d[x][11]).setValue(c);
}
else if (i=='LD'){
var assignment = {
workType: d[x][13], state: d[x][14], title: d[x][16],description: d[x][17],
materials: [{ link:{ url: d[x][9], title: d[x][19] } }],
maxPoints: d[x][20], scheduledTime: d[x][23],
dueDate: { year: d[x][24], month: d[x][25], day: d[x][26]},
dueTime: { hours: d[x][27],minutes: d[x][28], seconds: d[x][29]}
};
var a = Classroom.Courses.CourseWork.create(assignment, d[x][10]);
var c = a.id;
var id = sh.getRange(d[x][11]).setValue(c);
}
}
}