1. 近期活動(upcoming events)、活動表單(event posting form)與名錄查詢(query teacher info/directory)都是有使用javascript,因此使用網址嵌入, 其網址分別為 (以前都是用google gadget寫,檔案為同名的xml)
http://lilliantseng.github.io/magnified-healing/show-event.html
http://lilliantseng.github.io/magnified-healing/event-posting-form.html
http://lilliantseng.github.io/magnified-healing/query-teacher-info.html
http://lilliantseng.github.io/magnified-healing/q&a.html
這三者的code放在 https://github.com/LillianTseng/magnified-healing
2. 近期活動從Google Sheets擷取資料,data source為
https://spreadsheets.google.com/ccc?key=0ApAHxU34jqiRdE4tbHk5MWozVV9LTHFwanEwXzloX3c&hl=en&authkey=COG2zIwB&gid=1
3. 名錄查詢從Google Sheets擷取資料,data source 為
https://docs.google.com/spreadsheets/d/1UfJBgdyejQ21dr4s1fyBtkMYIqZYMUo58b6I6oCIoY0/edit?gid=1844470468&headers=1
4. 活動登錄表單連結至google form, form action url為
https://docs.google.com/forms/d/e/1FAIpQLSd6kEDKxEqb0I83R5hnv3x5AQBhrZQX98-zzhJ62I0JCC3VJQ/formResponse
5. Google Sheet中使用Script Editor來寫notice, review, periodically notice三種script,其中review要寫成web app,可在此project的editor中用publish更新版本,連結不會變,publish新版本前可以用dev連結測試新code;此web app連結會被notice & periodically notice引用
6. Periodically notice中有一個index來記錄最新未被審核的紀錄,以免每次都要從頭開始搜尋,當reset已審核紀錄時,要記得更新此index,位於project property中