Guest User

Google Spreadsheet easy update website

a guest
Aug 14th, 2016
20
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function googleSpreadsheetAgenda (spreadsheetID){
  2.        
  3.          // ID of the Google Spreadsheet
  4.          //var spreadsheetID = "GET THIS FROM GOOGLE SPREADSHEETS!!!!";
  5.          
  6.          // Make sure it is public or set to Anyone with link can view
  7.          var url = "https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/od6/public/values?alt=json";
  8.        
  9.          $.getJSON(url, function(data) {
  10.          
  11.           var entry = data.feed.entry;
  12.          
  13.           $(entry).each(function(){
  14.               var date = '<div class="dailyPostBellringer"><h3 class="dailyPostDate">'+this.gsx$date.$t;
  15.               var dayType = ' <small class="muted">'+this.gsx$daytype.$t+'</small></h3>';
  16.               var bellringer = '<div><span class="dailyPostTitle" style="font-size:1.3em;">Bellwork: </span>' +this.gsx$bellringer.$t+ bellworkButton+'</div>';
  17.               var lessonObjective = '<p><span class="dailyPostTitle" style="font-size:1.3em;">Objective: </span></p><p>'+this.gsx$lessonobjective.$t+'</p>';
  18.               var studentGoal = '<p><span class="dailyPostTitle" style="font-size:1.3em;">Student Goal: </span>'+this.gsx$studentgoal.$t+'</p>';
  19.              
  20.               var dailyPostBellringer = date + dayType + bellringer + lessonObjective + studentGoal + '</div>';
  21.              
  22.               var agenda1 = '<div class="dailyPostAgenda"><h4 class="dailyPostTitle">Agenda: </h4><p>'+this.gsx$agenda1.$t+'</p>';
  23.               var agenda2 = '<p>'+this.gsx$agenda2.$t+'</p>';
  24.               var agenda3 = '<p>'+this.gsx$agenda3.$t+'</p>';
  25.               var agenda4 = '<p>'+this.gsx$agenda4.$t+'</p>';
  26.               var agenda5 = '<p>'+this.gsx$agenda5.$t+'</p>';
  27.               var agenda6 = '<p>'+this.gsx$agenda6.$t+'</p>';
  28.               var agenda7 = '<p>'+this.gsx$agenda7.$t+'</p>';
  29.               var agenda8 = '<p>'+this.gsx$agenda8.$t+'</p>';
  30.               var agenda9 = '<p>'+this.gsx$agenda9.$t+'</p>';
  31.               var homework = '<p><span class="dailyPostTitle" style="font-size:1.3em;">Homework: </span>'+this.gsx$homework.$t+'</p>';
  32.              
  33.               var dailyPostAgenda = agenda1+agenda2+agenda3+agenda4+agenda5+agenda6+agenda7+agenda8+agenda9+homework+'</div>';
  34.              
  35.             // Column names are name, age, etc.
  36.             $('.dailies').prepend('<div class="dailyPost">'+ dailyPostBellringer + dailyPostAgenda + '<hr><\/div>');
  37.           });
  38.          
  39.          });
  40. }
Add Comment
Please, Sign In to add comment