readme

1. 近期活動(upcoming events)、活動表單(event posting form)與名錄查詢(query teacher info/directory)都是使用google gadgets, 其網址分別為

http://lilliantseng.github.io/magnified-healing/show-event.xml 
http://lilliantseng.github.io/magnified-healing/event-posting-form.xml
http://lilliantseng.github.io/magnified-healing/query-teacher-info.xml


2. 近期活動從Google Sheets擷取資料,data source (Prefs設定) 為
https://spreadsheets.google.com/ccc?key=0ApAHxU34jqiRdE4tbHk5MWozVV9LTHFwanEwXzloX3c&hl=en&authkey=COG2zIwB&gid=1

3. 名錄查詢從Google Sheets擷取資料,data source (Prefs設定) 為
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 (目前hard code)

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中


Comments