Profile cover photo
Profile photo
Andrew Roberts
Freelance Web/Google Apps Script Developer
Freelance Web/Google Apps Script Developer
About
Posts

Let's see if we can't make this the definitive list of Apps Script resources:

https://github.com/oshliaer/google-apps-script-awesome-list

Get making those pull requests!

GitHub Assistant Update Needed

Due to a Google update it stopped working yesterday with "get apps script code failed" (for me). You have to force the extension to update to get v4.04 (Extensions>Developer Mode>Update).

Thanks @leonhartx for such a quick fix :)

Post has attachment
Using DeepCode.ai with Apps Script

If you use the .js config option in GitHub Assistant (https://goo.gl/ewZzXL) to push your Apps Script files as .js files toGitHub you can automatically analyse your repos with DeepCode.ai (https://www.deepcode.ai). DeepCode.ai uses machine learning to not only lint your code but look for issues that might cause problems down the line!

Google Apps Script Dev Flow

Here's a writeup of a GitHub work flow for multiple devs with various things we've picked up along the way.

What do you think? It is a little prescriptive, but they are all things I've found useful, just takes a little concentration and discipline to implement them all (anyone got any further automation??) You should be able to comment in the doc so go crazy!

https://docs.google.com/document/d/1GgTZmY4VFzejVl7cTeKOc7PWtyZnhu-fFhysZ2ShRN4/edit#heading=h.v2f4oyhmg3cs.

Google Apps Script Dev Flow

Here's a writeup of a GitHub dev flow for multiple devs with various things we've picked up along the way.

What do you think? It is a little prescriptive, but they are all things I've found useful, just takes a little concentration and discipline to implement them all (anyone got any further automation??) You should be able to comment in the doc so go crazy!

https://docs.google.com/document/d/1GgTZmY4VFzejVl7cTeKOc7PWtyZnhu-fFhysZ2ShRN4/edit#heading=h.v2f4oyhmg3cs.

Google Apps Script Dev Flow

Here's a writeup of a GitHub work flow for multiple devs with various things we've picked up along the way.

What do you think? It is a little prescriptive, but they are all things I've found useful, just takes a little concentration and discipline to implement them all (anyone got any further automation??) You should be able to comment in the doc so go crazy!

https://goo.gl/AMDVvo

+Bruce Mcpherson +Martin Hawksey +Romain Vialard +Steve Webster +Rudi +GitHubAssistantPerson (please tag them if you know their G+ handles)

Post has attachment

WANTED - Apps Script Devs for various projects

I am looking for experienced Google Apps Script developers to help me with various projects.

If you are interested send me (andrew@roberts.net):

- your hourly rate
- availability
- examples of script you have written (links to existing projects, GitHub, BitBucket, etc).
- your general and Apps Script experience

Must be a fluent English speaker.

Look forward to hearing from you.

Andrew

http://www.andrewroberts.net

Record macros in Google Sheets!!!

Automatic Apps Script production - New feature coming where you can record macros that automatically get converted into Apps Script!

Can't wait to play with this one.

https://www.blog.google/products/g-suite/think-macro-record-actions-google-sheets-skip-repetitive-work/?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+blogspot%2FMKuf+%28The+Keyword+%7C+Official+Google+Blog%29

Post has attachment
Using JsFiddle.net to find tricky syntax errors

The script editor isn't always great at highlighting obscure syntax errors, so try copying the whole script into jsfiddle.net which is a lot better at it!
Wait while more posts are being loaded