...
| Code Block | ||
|---|---|---|
| ||
if (UpdateGoogleSheet.clicked) {
var eid = EId.value; // Unique key in the Google Sheet row
var headers = ‘ {“user”:”<google id>” ” < google id > ”,”password”:”<access token>” ” < access token > ”}’;
var updatequery = ‘/google/spreadsheets / update / key/<spreadsheetkey>?wsname=Locations&query=employeeid=”‘ + / < spreadsheetkey > ? wsname = 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).
- Add updateparams: we’re updating location and extension with new values.
- Run the update – perform an http.put() and eval the results.
...