req.onload = function(e) {
cb(JSON.parse(req.responseText), group_name);
};
- req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1ygfeR6njBUmLyuLRq7zfYW5slMWBGnj4XxzQQ4WJklU/values/\'' + group_name + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
+ req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1DSRRcV6d6Dx9KbCZgOSFF0MX9wKRex9nHcUjjOG4DNE/values/\'' + group_name + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
req.send();
}
<p>
<select onchange="javascript:updatequickhelp('team1', 'A');" id="team1select">
<option>TFK</option>
- <option>TFK2</option>
+ <option>TFK+</option>
<option>ESK</option>
<option>PCL</option>
+ <option>PCL2</option>
<option>BSI</option>
<option>BSI2</option>
- <option>NHHI</option>
- <option>NHHI2</option>
+ <option>BFK</option>
<option>OSI</option>
<option>OSI2</option>
<option>LAB</option>
<p>
<select onchange="javascript:updatequickhelp('team2', 'B');" id="team2select">
<option>TFK</option>
- <option>TFK2</option>
+ <option>TFK+</option>
<option>ESK</option>
<option>PCL</option>
+ <option>PCL2</option>
<option>BSI</option>
<option>BSI2</option>
- <option>NHHI</option>
- <option>NHHI2</option>
+ <option>BFK</option>
<option>OSI</option>
<option>OSI2</option>
<option>LAB</option>
}
cb(l3s, sheet);
};
- req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/18pTqrwSoqrb9_M9HJkiijMBAPppuSnFDAYEezZTKh00/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
+ req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1Mp6sWSxxvRl3YCCx4-RPlnCyuzkgNbJW1iCHnsH-9Ks/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
req.send();
};
}
cb(team_name, roster);
};
- req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/18pTqrwSoqrb9_M9HJkiijMBAPppuSnFDAYEezZTKh00/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
+ req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1Mp6sWSxxvRl3YCCx4-RPlnCyuzkgNbJW1iCHnsH-9Ks/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
req.send();
};
"data": updates
};
possibly_update_oauth_key(function() {
- post_json('https://sheets.googleapis.com/v4/spreadsheets/1ygfeR6njBUmLyuLRq7zfYW5slMWBGnj4XxzQQ4WJklU/values:batchUpdate?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU', json, function(response) {}, current_oauth_access_token);
+ post_json('https://sheets.googleapis.com/v4/spreadsheets/1DSRRcV6d6Dx9KbCZgOSFF0MX9wKRex9nHcUjjOG4DNE/values:batchUpdate?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU', json, function(response) {}, current_oauth_access_token);
});
});