Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
/*member colors, password, user, results */
var x;
if (form.load) {
var headers = 
{"user":"<Google user Id>","password":"<Google Account access token>"};    
 var readquery = '/google/spreadsheets/query/key/<your spreadsheet key>?wsname=<the name of the worksheet>';
    eval('x=' + http.get(readquery,headers));                                                                                   

   var opts = [];
   if (x.results) {
     for (var i = 0; i < x.results.length; i++) {
       if (x.results[i].colors) {
         opts[i] = x.results[i].colors;
       }
     }
   }
    Colors.options = opts;    //Colors is the name of the Checkbox/Radio control
}

Image Removed Image Added