Page History
...
Code Block | ||
---|---|---|
| ||
/*member employeeid, firstname, lastname, password, user, results*/ var x; if (Connect.clicked) { var headers = {"user":"<google id>","password":"<access token>"}; var readquery = '/google/spreadsheets/query/key/<your spreadsheet key>?wsname=<the name of your worksheet>'; var results = http.get(readquery,headers); GSResults.value = results; eval('x=' + results); var opts = ['']; if (x.results) { for (var i = 0; i < x.results.length; i++) { if (x.results[i].employeeid) { opts[i + 1] = .push(x.results[i].employeeid + '=' + x.results[i].firstname + ' ' + x.results[i].lastname); } } } EId.options = opts; } |
- It’s triggered by clicking on the Connect button.
- We setup headers and a query using your access token and spreadsheet key (the long ID in the URL of the Google Sheet).
- Run the query – perform an http.get() and eval the results.
- Parse the results into an array. The array elements are “hagen=Walter Hagen” etc.
- Set the options to the array.
Tip |
---|
The column name on a Google sheet must match the control name. The matching is case-insensitive and any spaces in the column name are ignored. A control named "FirstName" matches a column header "first name." However, references to Google Sheet columns in your rule must be lower case and cannot contain spaces. The correct reference for this example is "firstname." |
...
Overview
Content Tools