Yagisanatode · @yagisanatode
3 followers · 8 posts · Server qoto.org

Create Google Sheets Dropdowns with Google Apps Script youtu.be/rQXPl-hZxzQ?si=OjT1xe via @YouTube @workspacedevs

#googlesheets #googleappsscript

Last updated 1 year ago

Mariette Timmer · @mariettetimmer
25 followers · 514 posts · Server mastodon.nl

For this toots and the HAT collections are arrayed. Indexes are 'chosen' with JS Math Random and Round. A small bot-script does the rest

#googleappsscript #metmuseum #VAM #haturday

Last updated 1 year ago

Philip Allfrey · @dr_pda
127 followers · 147 posts · Server hcommons.social

Those of you who followed my bot @UPressSalesBot on the other platform may be interested to know it's now up and running here on Mastodon, tooting out discounts from university presses.

I'm using a new infrastructure which is social-media-platform agnostic (subscribe to all the mailing lists, parse out sentences with a discount code, toot [or whatever], repeat). I'll post my code shortly.

I also discovered two new tools:

1) Gmail (and other providers) support plus addressing in emails. This means if your email is first.last@gmail.com then first.last+whatever@gmail.com will also go to your inbox.

2) Google Apps Script among other things lets you run javascript code on your inbox, so you can do proper parsing with regular expressions and all sorts of other automation
google.com/script/start/

#bot #discount #phdchat #googleappsscript #universitypress

Last updated 1 year ago

Mariette Timmer · @mariettetimmer
22 followers · 455 posts · Server mastodon.nl

Heb een scriptje geschreven dat populariteit van arresten van het EU HvJ over Vo 2016/679 in kaart brengt. Hoe vaker door het EU HvJ naar een arrest wordt verwezen hoe populairder dat arrest. De grote winnaar is 62019CJ0439 (54 verwijzingen; eur-lex.europa.eu/legal-conten). Als het scriptje spoort tenminst ;-).

#googleappsscript #gdpr #ecj

Last updated 1 year ago

【Qiitaアナリティクス】"自分の記事がどれだけ見てもらえているか" を見える化するスプレッドシートを作りました 🚀
qiita.com/Ryo-Nakano/items/0d7

#qiita #javascript #googleappsscript #spreadsheet #データ分析 #個人開発

Last updated 1 year ago

Mariette Timmer · @mariettetimmer
20 followers · 429 posts · Server mastodon.nl

Is it possible to scrape dynamic webpages with ?

#scraping #dtv #googleappsscript

Last updated 1 year ago

Todd A. Jacobs · @todd_a_jacobs
13 followers · 117 posts · Server ruby.social

Can anyone recommend a good for working with ? I'd prefer to avoid working directly in , but transpilers like and others have their own problems.

#rubylang #sdk #googleappsscript #javascript #coffeescript

Last updated 1 year ago

Mariette Timmer · @mariettetimmer
13 followers · 380 posts · Server mastodon.nl

😂 Het is me gelukt om met Google Apps Script te tooten.
Mijn dag is weer helemaal goed.
Nu een 'echte' bot maken van werkgerelateerde rss-feeds.

#bot #googleappsscript

Last updated 1 year ago

Yagisanatode · @yagisanatode
2 followers · 6 posts · Server qoto.org

Auto-Add Date and Time to an Adjacent Cell Upon Edit in Google Sheets with Apps Script. This a long-awaited update to a 5-year-old tutorial.

@workspacedevs

youtu.be/GrRmapAPdg4

#googleappsscript #googlesheets

Last updated 1 year ago

Yagisanatode · @yagisanatode
1 followers · 4 posts · Server qoto.org

List all files and folders in a folders directory tree in Google Drive: Apps Script. @WorkspaceDevs

yagisanatode.com/list-all-files-and-folders-in-a-folders-directory-tree-in-google-drive-apps-script/

#AppsScript #googledrive #googleappsscript #googledriveapi

Last updated 1 year ago

Hackernoon · @hackernoon_bot
353 followers · 6636 posts · Server social.platypush.tech

Referenced link: hackernoon.com/removing-duplic
Discuss on discu.eu/q/https://hackernoon.

Originally posted by HackerNoon | Learn Any Technology / @hackernoon: nitter.platypush.tech/hackerno

Highlight and Remove duplicate rows in your google spreadsheet with this script for free. Works with any type and length of sheets. - by @KhadkaNibesh hackernoon.com/removing-duplic

#googleappsscript #googlesheets

Last updated 2 years ago

gotofritz · @gotofritz
832 followers · 93 posts · Server fosstodon.org

: It is possible to develop projects locally, on your machine, in , and sync them with Drive. Excited? Don't be. I am still not sure it's a good idea. Anyhow, here's a starter project using Python's

gotofritz.net/blog/clasp-templ

#blog #googleappsscript #typescript #copier

Last updated 2 years ago

ゆでだこのこひな🐙 · @37coHiNa
77 followers · 20484 posts · Server pawoo.net

って 使えるのか。
WASI on GAS 作ろうぜ!

#wasm #googleappsscript

Last updated 2 years ago

Hackernoon · @hackernoon_bot
334 followers · 6229 posts · Server social.platypush.tech
Yagisanatode · @yagisanatode
1 followers · 3 posts · Server qoto.org

Find and hide Rows by Grouping Ranges in Google Sheets with Apps Script - A faster approach.
Got a large Google Sheets dataset that you want to hide rows by cell value on? @WorkspaceDevs
youtu.be/WTImNqHkl1k

#googleappsscript #SpreadsheetAutomation #googlesheets

Last updated 2 years ago

ゆでだこのこひな🐙 · @37coHiNa
76 followers · 20267 posts · Server pawoo.net

を .ts で書いて clasp push するとトランスパイルされて clasp pull で .js しか持って来られないので、.ts で書く場合は別途 git とか使ってソース管理した方が良さそう。個人だとあまり気にならないかもだが。

#googleappsscript

Last updated 2 years ago

ゆでだこのこひな🐙 · @37coHiNa
76 followers · 20233 posts · Server pawoo.net

「 clasp 使えば .ts も自動でトランスパイルされるよ!」って言うから試しに ES6 private field 定義したら無茶苦茶頑張っててワロタ。 くん ES6 に対応しなさいよ。

#googleappsscript

Last updated 2 years ago

ゆでだこのこひな🐙 · @37coHiNa
76 followers · 20233 posts · Server pawoo.net

Google 先生、はやくなおして。

ScriptApp.getService().getUrl() doesn't work for versioned deployments
issuetracker.google.com/issues

#googleappsscript

Last updated 2 years ago

ゆでだこのこひな🐙 · @37coHiNa
76 followers · 20233 posts · Server pawoo.net

Google くん のことあんまり好きじゃなさそう。切り捨てられないか心配。

#googleappsscript

Last updated 2 years ago