let roster = [];
let i;
for (i = 0; i < response.values.length; ++i) {
- if (response.values[i][0] === 'Number') {
+ if (response.values[i][0] === 'Number' ||
+ response.values[i][0] === 'Fake #') {
++i;
break;
}
"name": name
});
}
+ roster.sort(function(a, b) {
+ let an = a['number'];
+ let bn = b['number'];
+ if (!(parseInt(an) > 0)) an = 1000;
+ if (!(parseInt(bn) > 0)) bn = 1000;
+ if (an !== bn) {
+ return an - bn;
+ }
+ return a['name'].localeCompare(b['name']);
+ });
cb(team_name, roster);
};
- req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1RciMlauWxqM9LYKdsY6lPjJbIAcHJpCXTqyZSEHxH3U/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
+ req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/' + ultimateconfig['roster_sheet_id'] + '/values/\'' + sheet + '\'!A1:J50?key=' + ultimateconfig['api_key']);
req.send();
};