Skip to content

Instantly share code, notes, and snippets.

@wchiquito

wchiquito/gist:6105659

Created July 29, 2013 16:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wchiquito/6105659 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wchiquito/6105659 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.js
/* CODE FOR DEMONSTRATION PURPOSES */
function getAvailableTags() {
var ss = SpreadsheetApp.openById([SS-ID]);
var s = ss.getSheetByName([S-NAME]);
var data = s.getDataRange().getValues();
var headers = 1; // number of header rows to skip at top
var tagColumn = 2; // column # (0-based) containing tag
var availableTags = [], availableTag;
for (var row = headers, len = data.length; row < len; row++) {
availableTag = data[row][tagColumn];
if (availableTag) availableTags.push(availableTag);
}
return availableTags;
}
/* CODE FOR DEMONSTRATION PURPOSES */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment