Getting data from Google spreadsheet

« 17 Martsa 2014 | 18:00 | Uncategorized | No Comments »

Having this spreadsheet from Google: https://docs.google.com/spreadshee… This is what I did to show the quote daily: <script src=”http://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js”> </script> <div id=”result”>loading</div> <script> var today = new Date(); var aday = today.getDate(); var amonth = today.getMonth(); var sq = “amonth=” + amonth + ” and aday=” + aday; var url = “https://spreadsheets.google.com/feeds/list/0AjgIgMIuXFo2dF9fQnUybkFLeE5ybHE0bVJ4Z3F0Unc/od6/public/values?alt=json”; $.getJSON(url, { “sq”: sq }, […]