A•Reyes · @darkade
257 followers · 1748 posts · Server dice.campOk :P #AskMeAbout
-- #FastSaga #FastAndFurious
— weird use cases with google #appsscript
— getting into #ttrpg or #boardgames
#askmeabout #fastsaga #fastandfurious #appsscript #ttrpg #boardgames
Aitor Roma · @aitorroma
21 followers · 24 posts · Server mastodon.hiveagile.com⭕️ FormEasy, Formularios para tu web estatica!.
#formeasy #appsscript #formularios #web #codigoabierto
ITHCWY · @ithcwy
47 followers · 294 posts · Server botsin.spaceAnimation of a year of Global Cloud Cover #code #software #video #animation #appsscript #drive #earth #nasa #xplanet https://ithoughthecamewithyou.com/post/animation-of-a-year-of-global-cloud-cover?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#code #software #video #animation #appsscript #drive #earth #nasa #xplanet
ITHCWY · @ithcwy
46 followers · 291 posts · Server botsin.spaceControl LIFX WiFi light bulbs from Google Apps Script #software #appsscript #drive #philips https://ithoughthecamewithyou.com/post/control-lifx-wifi-light-bulbs-from-google-apps-script?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#software #appsscript #drive #philips
ITHCWY · @ithcwy
21 followers · 201 posts · Server botsin.space
Animation of a year of Global Cloud Cover #code #software #video #animation #appsscript #drive #earth #nasa #xplanet https://ithoughthecamewithyou.com/post/animation-of-a-year-of-global-cloud-cover?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#code #software #video #animation #appsscript #drive #earth #nasa #xplanet
ITHCWY · @ithcwy
8 followers · 158 posts · Server botsin.spaceEmail Alerts for new Referers in Google Analytics using Apps Script #code #googleanalytics #appsscript #gas https://ithoughthecamewithyou.com/post/email-alerts-for-new-referers-in-google-analytics-using-apps-script?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#code #googleanalytics #appsscript #gas
ITHCWY · @ithcwy
8 followers · 158 posts · Server botsin.space
Automate Google PageSpeed Insights and Core Web Vitals Logging with Apps Script #code #google #appsscript #gas #pagespeed https://ithoughthecamewithyou.com/post/automate-google-pagespeed-insights-with-apps-script?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#code #google #appsscript #gas #pagespeed
ITHCWY · @ithcwy
8 followers · 158 posts · Server botsin.space
Get an email if your site stops being mobile friendly #code #mobile #appsscript #gas https://ithoughthecamewithyou.com/post/get-an-email-if-your-site-stops-being-mobile-friendly?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#code #mobile #appsscript #gas
RyanWright · @RyanWright
2 followers · 39 posts · Server social.vivaldi.net
3/ Есть список общих трат. У каждой строки такой траты есть дедлайн для удобства. Надоело постоянно контролировать ссылки в формулах и я написал макрос #appsscript Его код на скриншоте. Привязал его к кнопке (в google sheets это называется "рисунок"; можно привязать функцию из gs файла к нему).
ITHCWY · @ithcwy
5 followers · 140 posts · Server botsin.space
Get an email if your site stops being mobile friendly #code #mobile #appsscript #gas https://ithoughthecamewithyou.com/post/get-an-email-if-your-site-stops-being-mobile-friendly?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#code #mobile #appsscript #gas
Robert · @robert
34 followers · 86 posts · Server metasocial.com
Hacked up something pretty today using three of my favorite hammers:
* #GoogleSheets
* #AppsScript
* #GraphViz (via d3-graphviz)
The picture is not that exciting, but the process of getting a nearly real-time chart powered by a spreadsheet was fun.
#googlesheets #appsscript #graphviz
ITHCWY · @ithcwy
3 followers · 99 posts · Server botsin.space
How to backup Google Photos to Google Drive automatically after July 2019 with Apps Script #code #software #photos #appsscript #google #sheets #drive #api https://ithoughthecamewithyou.com/post/how-to-backup-google-photos-to-google-drive-automatically-after-july-2019-with-apps-script?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#code #software #photos #appsscript #google #sheets #drive #api
ITHCWY · @ithcwy
3 followers · 93 posts · Server botsin.space
How to backup Google Photos to Google Drive automatically after July 2019 with Apps Script #code #software #photos #appsscript #google #sheets #drive #api https://ithoughthecamewithyou.com/post/how-to-backup-google-photos-to-google-drive-automatically-after-july-2019-with-apps-script?utm_source=botsin.space&utm_medium=referral&utm_campaign=tootone
#code #software #photos #appsscript #google #sheets #drive #api
Casey · @casey
14 followers · 43 posts · Server hachyderm.ioFinished first pass of my first #appsscript to pull data from thebluealliance.com to #GoogleSheets for #frcRobotics
https://github.com/AusTINCANsProgrammingTeam/canalytics/tree/scouting-charts/appscripts
Sharp edges: caching service is goofy, it takes so long to execute a function from a sheet cell, and really don't like using =query() in sheets.
Now that the initial work is done, the hope is to get the team involved in updating the script for kickoff, and then more engaged on scouting during competition.
#appsscript #GoogleSheets #frcrobotics
Casey · @casey
14 followers · 60 posts · Server hachyderm.io
Finished first pass of my first #appsscript to pull data from thebluealliance.com to #GoogleSheets for #frcRobotics
https://github.com/AusTINCANsProgrammingTeam/canalytics/tree/scouting-charts/appscripts
Sharp edges: caching service is goofy, it takes so long to execute a function from a sheet cell, and really don't like using =query() in sheets.
Now that the initial work is done, the hope is to get the team involved in updating the script for kickoff, and then more engaged on scouting during competition.
#appsscript #GoogleSheets #frcrobotics
Jeffrey Yasskin · @jyasskin
316 followers · 304 posts · Server hachyderm.io#TIL that you can implement your own #GoogleSheets functions in #AppsScript and then use them as =MyFunction(stuff) in your spreadsheet.
https://developers.google.com/apps-script/guides/sheets/functions
And while I was looking up the citation for this, I also found https://support.google.com/docs/answer/12504534 about naming combinations of built-in functions!
#til #GoogleSheets #appsscript
Casey · @casey
14 followers · 39 posts · Server hachyderm.ioWorking on an #appsscript to make rest calls and store data in a google sheet for a #frcrobotics scouting project. Painful.
1. Examples in official docs were not practical.
How can I read this entire spreadsheet and log each value? Said no one. Ever.
2. I tried to put JSON into the Cache Service, instead of a string. ( My bad ) And it silently failed.
But it takes a special flag to be able to handle HTTP error codes without an exception.
consistent #UX is important
Jomar Tigcal · @jomartigcal
1 followers · 11 posts · Server androiddev.socialA few weeks ago, I developed an Exchange Gift Generator with Google Forms/Spreadsheets and Apps Script: https://jomartigcal.medium.com/developing-exchange-gift-generator-with-forms-spreadsheets-and-apps-script-95c4b9c1f26d
#appsscript #googlesheets #exchangegift #secretsanta
I Thought He Came With You · @ithcwy
1 followers · 44 posts · Server botsin.space
Using the Todoist API to set a due date on the Alexa integration to-do list (with Apps Script) #code #appsscript #google #drive #todoist #productivity https://ithoughthecamewithyou.com/post/using-the-todoist-api-to-set-a-due-date-on-the-alexa-integration-todo-list-with-apps-script
#code #appsscript #google #drive #todoist #productivity
Landsil · @Landsil
1 followers · 8 posts · Server infosec.exchangeWould it be hard for Google Forms to provide their output via JSON or something reasonable?
Working with apps script to fully make and process data via them is harder than it should be.