let l3s = [];
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;
}
text = text.replace(/\n/, '<br />');
let subtext = response.values[i][3];
if (subtext === undefined || subtext === '') {
- subtext = 'Norwegian Ultimate Championships 2018';
+ subtext = 'Trøndisk 2018';
}
l3s[prefix + number] = {
};
let image = response.values[i][4];
if (image !== undefined && image.match(/^file:/) !== null) {
- l3s[prefix + number].image = image;
+ l3s[prefix + number].image = image.match(/^file:(.*)/)[1];
}
}
cb(l3s, sheet);
};
- 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/18pTqrwSoqrb9_M9HJkiijMBAPppuSnFDAYEezZTKh00/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
req.send();
};