...
| Code Block | ||
|---|---|---|
| ||
/*member password, user*/
if (UpdateGoogleSheet.clicked) {
var eid = EId.value; // Unique key in the Google Sheet row
var headers = {"user":"<google id>","password":"<your access token>"};
var updatequery = '/google/spreadsheets/update/key/<your spreadsheet key>?wsname=<the name of your worksheet tab>Locations&query=employeeid="' + eid + '"';
var updateparams = '&updates=location=' + Location.value + ',extension=' + Extension.value;
eval('x=' + http.put(updatequery + updateparams, null, headers, false));
} |
- It’s triggered by clicking on the Update Google Sheet button.
- We setup headers and an update query using your access token and spreadsheet key (the long ID in the URL of the Google Sheet). In this example, the name of the Google Sheet tab is Locations. Change the wsname= parameter to the name of your Google Sheet tab if you named the tab something different.
- Add updateparams: we’re updating location and extension with new values.
- Run the update – perform an http.put() and eval the results.
...