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中 |