如何在試算表中以特定值觸發自動寄信? - Google
![Vanessa avatar](/img/girl5.jpg)
By Vanessa
at 2017-03-13T21:02
at 2017-03-13T21:02
Table of Contents
我設計了一個借用物品的 Google 試算表如連結:
https://goo.gl/qlDXlY
我想要的效果是:若 I 欄的值變成「逾期」,則自動寄信到 G 欄內的借用者 E-mail,
通知借用者該還物品了。
https://productforums.google.com/forum/#!topic/docs/wNPae26EtGI
其實我已經搜尋到討論區解答,但是因為沒有寫 Script 的基礎,不了解這篇文章的解答
要如何實際套用?
解答者說要
1. go to Tools –> Script Editor. You will see some 'code'.
2.Go to the Run menu and choose Initialize. The Google Script will now require
you to authorize the script – just click the Accept button and you’re done.
問題在於我的 Run menu 並沒有 Initialize 這個選項,只有一個 myFunction
方便請問先進們,要如何套用此解答裡的 Script 呢?感恩!
--
https://goo.gl/qlDXlY
我想要的效果是:若 I 欄的值變成「逾期」,則自動寄信到 G 欄內的借用者 E-mail,
通知借用者該還物品了。
https://productforums.google.com/forum/#!topic/docs/wNPae26EtGI
其實我已經搜尋到討論區解答,但是因為沒有寫 Script 的基礎,不了解這篇文章的解答
要如何實際套用?
解答者說要
1. go to Tools –> Script Editor. You will see some 'code'.
2.Go to the Run menu and choose Initialize. The Google Script will now require
you to authorize the script – just click the Accept button and you’re done.
問題在於我的 Run menu 並沒有 Initialize 這個選項,只有一個 myFunction
方便請問先進們,要如何套用此解答裡的 Script 呢?感恩!
--
Tags:
Google
All Comments
![Thomas avatar](/img/boy2.jpg)
By Thomas
at 2017-03-15T17:43
at 2017-03-15T17:43
![Eartha avatar](/img/cat1.jpg)
By Eartha
at 2017-03-19T04:08
at 2017-03-19T04:08
![Poppy avatar](/img/cat2.jpg)
By Poppy
at 2017-03-20T18:38
at 2017-03-20T18:38
![Robert avatar](/img/cat3.jpg)
By Robert
at 2017-03-22T05:20
at 2017-03-22T05:20
![Rae avatar](/img/woman.jpg)
By Rae
at 2017-03-23T01:41
at 2017-03-23T01:41
![Thomas avatar](/img/cat4.jpg)
By Thomas
at 2017-03-25T09:22
at 2017-03-25T09:22
![Sierra Rose avatar](/img/woman-biz.jpg)
By Sierra Rose
at 2017-03-25T22:59
at 2017-03-25T22:59
Related Posts
雲端硬碟存取問題
![Delia avatar](/img/woman-biz.jpg)
By Delia
at 2017-03-13T17:11
at 2017-03-13T17:11
Google Map顏色對比很低
![Dinah avatar](/img/girl1.jpg)
By Dinah
at 2017-03-11T22:55
at 2017-03-11T22:55
google keep無法存檔
![Ivy avatar](/img/cat4.jpg)
By Ivy
at 2017-03-11T19:38
at 2017-03-11T19:38
CHROME擴充功能頁面不能開
![Zora avatar](/img/cat2.jpg)
By Zora
at 2017-03-11T14:17
at 2017-03-11T14:17
設定共用的檔案 別人能google搜尋到嗎?
![Quanna avatar](/img/girl5.jpg)
By Quanna
at 2017-03-11T13:52
at 2017-03-11T13:52