利用 Google 問卷(試算表)當小型資料庫__更新版__(一)製作資料庫
https://docs.google.com/spreadsheets/d/1vUKbIhXPdoct6HXrBlvYJWRtX4KiUIMy1ICMuWAOgp8/pubhtml
https://spreadsheets.google.com/feeds/list/1vUKbIhXPdoct6HXrBlvYJWRtX4KiUIMy1ICMuWAOgp8/od6/public/values?alt=json
Use a Google Spreadsheet as your JSON backend
Using the Google Spreadsheets Data API to build a Recommended Reading List - Code Words
items.push('
'+entry.gsx$name.$t+'
JavaScript 存取 google spreadsheets 試算表
https://docs.google.com/spreadsheet/pub?key=0Asp3dPzRohcndHE4dE0xNXFWWTI2d0dvN1g4VmRQOWc&single=true&gid=1&tq=select%20d&output=html
https://spreadsheets.google.com/tq?tqx=out:html&key=0Asp3dPzRohcndHE4dE0xNXFWWTI2d0dvN1g4VmRQOWc&gid=1&tq=select%20D%20limit%205
PS. 新版Google Sheets生成的key不能使用Google Sheets API的語法
Query Language Reference (Version 0.7) Use the tool to encode or decode a query string:
Getting JSON data from Google spreadsheets and using it in Google maps
json 1000 limit $.getJSON('https://spreadsheets.google.com/feeds/list//od6/public/values?alt=json', function(data) { for (var i = 0; i < data.feed.entry.length; i++) { var id = data.feed.entry[i].gsx$benchid.$t; var photo = data.feed.entry[i].gsx$photourl.$t; var caption = data.feed.entry[i].gsx$captionoptional.$t; var string = '' + caption + '
'; var lat = data.feed.entry[i].gsx$lat.$t; var long = data.feed.entry[i].gsx$long.$t; createMarker(lat, long); createInfoWindow(id, string); };
沒有留言:
張貼留言
注意:只有此網誌的成員可以留言。