Page History

...

Code Block

language	js

/*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."

...

Versions Compared

Old Version 2

New Version 3

Key