var resultsSpreadsheet = 'https://docs.google.com/spreadsheets/d/1xqGTbkgosPqSRCkZ6xKj1c01sRRZkg0qeNeN2hrkFSI/pubhtml?gid=1847002595'; var videoSpreadsheet = 'https://docs.google.com/spreadsheets/d/1JaOe5PF9YC_A6c5ntP2YKPdGvTNqruq4ohsmSvlnK1U/pubhtml?gid=1953654254'; var bandsTemplate = Handlebars.compile($('#bands-template').html()); var searchTerm = new Date().getFullYear(); loadResults(); function loadResults() { $('#bands').sheetrock({ url: resultsSpreadsheet, query: "select A,B,C,D,E,F,M,L,V,W,G,H,I,J,K,X,Q,R,S,T where (A like '%" + searchTerm + "%') order by A desc, B asc", rowTemplate: bandsTemplate, callback: function(error, options, response) { if (!error) { $('#bands').tablesorter(); document.getElementById("results-header").innerHTML = searchTerm + " Results" if ($('#bands tr').length == 1) { $('#bands').append("

No results.

") } } else { $('#bands').append('

Error.

'); } } }); } function loadRandom(){ $('#themes').sheetrock({ url: videoSpreadsheet, query: "select A,B order by A desc", callback: function(error, options, response) { if (error) { return; } randomVid = chance.pickone(response.rows); randomVid = randomVid.cellsArray[1]; document.getElementById('video').innerHTML = '' } }); } Handlebars.registerHelper("normalize", function(input) { return input.toLowerCase().replace(/ +/g, "+").replace(/\\.+|,.+|'.+/g, ""); }); $(document).ready(function() { loadRandom(); $("td.note:contains('dq')").siblings(".prize").addClass("dq"); if ($(".dq").length != 0) { $(".dqNote").show(); } });