create account

求google app script教學 by aaronli

View this thread on: hive.blogpeakd.comecency.com
· @aaronli · (edited)
$7.71
求google app script教學
程序員很厲害,什麼程式語言都懂。

![8hhygb.jpg](https://img.esteem.app/8hhygb.jpg)

話說新公司啟動,我開始準備到時候需要用到的文件,由於啟動初期,並沒有那麼多錢和那麼大的需求去買一個客戶管理系統,所以我們現在會用google試算表去做數據管理。

作為一名懶人,我當然希望用最少功夫,輸入最少東西就能得到最大效果,那麼各類function甚至程式是少不了的。以前我玩過一點點Excel VBA,但發現google試算表的google app script又是另一種玩法,它是用JavaScript的。我學過一點點python,一點點html,一點點css,但就未接觸過JavaScript,我又要重新去學了。

雖然程式語言間都是大同小異,不過也是要學習的,求Steemit程序大神介紹好用的JavaScript、或Google App Script教學!我不打算慢慢學,想速成哈哈,邊做邊學的同時,在空餘時間也能看多一點教學視頻,如有的話,感激不盡!
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 255 others
👎  
properties (23)
authoraaronli
permlinkgoogle-app-script
categorycn
json_metadata{"image":"https://img.esteem.app/8hhygb.jpg","tags":["cn","cn-reader","cn-curation","whalepower","lifestyle","cn-stem","steemstem","cn-programming","palnet","zzan","dblog","diamondtoken","marlians","neoxian","lassecash","upfundme","busy","actnearn"],"app":"busy/2.5.4","format":"markdown","community":"hive-125125"}
created2020-03-12 14:04:42
last_update2020-03-12 14:05:24
depth0
children9
last_payout2020-03-19 14:04:42
cashout_time1969-12-31 23:59:59
total_payout_value4.092 HBD
curator_payout_value3.617 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length452
author_reputation350,925,896,936,040
root_title"求google app script教學"
beneficiaries
0.
accountesteemapp
weight300
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,290,381
net_rshares31,862,020,860,300
author_curate_reward""
vote details (320)
@abcallen ·
https://www.bilibili.com/video/av65103698/【可以看看】
https://www.wikihow.com/wikiHowTo?search=Google+Apps+Script【很多Google Apps Script的教学视频】
最后,拍拍
properties (22)
authorabcallen
permlinkq74hxw
categorycn
json_metadata{"links":["https://www.bilibili.com/video/av65103698/【可以看看】","https://www.wikihow.com/wikiHowTo?search=Google+Apps+Script【很多Google"],"app":"busy/2.5.4"}
created2020-03-13 08:22:45
last_update2020-03-13 08:22:45
depth1
children1
last_payout2020-03-20 08:22:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length141
author_reputation100,871,855,756,011
root_title"求google app script教學"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,317,591
net_rshares0
@aaronli ·
嘩真的有!
properties (22)
authoraaronli
permlinkre-abcallen-2020313t222948510z
categorycn
json_metadata{"tags":["esteem"],"app":"esteem/2.2.4-mobile","format":"markdown+html","community":"hive-125125"}
created2020-03-13 14:29:48
last_update2020-03-13 14:29:48
depth2
children0
last_payout2020-03-20 14:29:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length5
author_reputation350,925,896,936,040
root_title"求google app script教學"
beneficiaries
0.
accountesteemapp
weight300
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,324,472
net_rshares0
@ace108 ·
唔玩Python啦吗?
properties (22)
authorace108
permlinkq733kx
categorycn
json_metadata{"app":"steemit/0.2"}
created2020-03-12 14:14:57
last_update2020-03-12 14:14:57
depth1
children1
last_payout2020-03-19 14:14:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length11
author_reputation1,225,209,730,614,270
root_title"求google app script教學"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,290,689
net_rshares0
@aaronli ·
而家js有實際需要,python暫時未有實際需要😂
properties (22)
authoraaronli
permlinkre-ace108-2020312t232621727z
categorycn
json_metadata{"tags":["esteem"],"app":"esteem/2.2.4-mobile","format":"markdown+html","community":"hive-125125"}
created2020-03-12 15:26:21
last_update2020-03-12 15:26:21
depth2
children0
last_payout2020-03-19 15:26:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length25
author_reputation350,925,896,936,040
root_title"求google app script教學"
beneficiaries
0.
accountesteemapp
weight300
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,292,749
net_rshares0
@catscientist ·
Thank you for supporting @CatsMakeKittens by being a part of our community @aaronli.

Each CATS you purchase gets you daily upvotes from me @CatScientist as our community grows so do your rewards for being a member!
properties (22)
authorcatscientist
permlinkre-google-app-script-20200312t143339z
categorycn
json_metadata"{"app": "rewarding/0.1.5"}"
created2020-03-12 14:33:42
last_update2020-03-12 14:33:42
depth1
children0
last_payout2020-03-19 14:33:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length217
author_reputation785,924,402,887
root_title"求google app script教學"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,291,145
net_rshares0
@nuagnorab · (edited)
youtube 好多教學, 可以connect google app 由user user 填 form submit 完出invoice 然後自動加入 google docs 再出templated gmail 連 invoice pdf 俾客。唔洗寫code

Search automate document workflow with google 
properties (22)
authornuagnorab
permlinknuagnorab-re-aaronli-google-app-script-20200313t030017857z
categorycn
json_metadata{"app":"partiko","client":"ios"}
created2020-03-13 03:00:18
last_update2020-03-13 03:06:24
depth1
children2
last_payout2020-03-20 03:00:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length179
author_reputation125,097,310,898,849
root_title"求google app script教學"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,311,161
net_rshares0
@aaronli ·
呢啲好正,不過我搵果啲未能完全配合我需要,所以想自己寫
properties (22)
authoraaronli
permlinkre-nuagnorab-2020313t223042265z
categorycn
json_metadata{"tags":["esteem"],"app":"esteem/2.2.4-mobile","format":"markdown+html","community":"hive-125125"}
created2020-03-13 14:30:42
last_update2020-03-13 14:30:42
depth2
children1
last_payout2020-03-20 14:30:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length27
author_reputation350,925,896,936,040
root_title"求google app script教學"
beneficiaries
0.
accountesteemapp
weight300
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,324,503
net_rshares0
@nuagnorab · (edited)
都係既自己識係方便好多,不過 JS 而家都易左好多,係 async promise 煩D
btw 啪啪啪啪啪
properties (22)
authornuagnorab
permlinkq74zj4
categorycn
json_metadata{"app":"busy/2.5.4"}
created2020-03-13 14:42:42
last_update2020-03-13 14:43:00
depth3
children0
last_payout2020-03-20 14:42:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length54
author_reputation125,097,310,898,849
root_title"求google app script教學"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,324,799
net_rshares0
@steemitboard ·
Congratulations @aaronli! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

<table><tr><td><img src="https://steemitimages.com/60x70/http://steemitboard.com/@aaronli/voted.png?202003121508"></td><td>You received more than 110000 upvotes. Your next target is to reach 120000 upvotes.</td></tr>
</table>

<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@aaronli) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=aaronli)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>



**Do not miss the last post from @steemitboard:**
<table><tr><td><a href="https://steemit.com/steemitboard/@steemitboard/downvote-challenge-add-up-to-3-funny-badges-to-your-board"><img src="https://steemitimages.com/64x128/https://steemitimages.com/0x0/![](https://cdn.steemitimages.com/DQmUuJkZdnSpHVWssxF82ntymqXg4Pvk6K6bYvckUYVRsnj/image.png)"></a></td><td><a href="https://steemit.com/steemitboard/@steemitboard/downvote-challenge-add-up-to-3-funny-badges-to-your-board">Downvote challenge - Add up to 3 funny badges to your board</a></td></tr></table>

###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!
properties (22)
authorsteemitboard
permlinksteemitboard-notify-aaronli-20200312t153723000z
categorycn
json_metadata{"image":["https://steemitboard.com/img/notify.png"]}
created2020-03-12 15:37:24
last_update2020-03-12 15:37:24
depth1
children0
last_payout2020-03-19 15:37:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,403
author_reputation38,975,615,169,260
root_title"求google app script教學"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id96,293,034
net_rshares0