O'Reilly logo

Going GAS by Bruce Mcpherson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A. Further Resources

There are many code snippets throughout this book, and they are presented to illustrate a point or a technique. Some of the apps can be reconstructed from the snippets given, but it may be easier to pick up the code for each of the completed apps from the companion GitHub repository. Each dataset and spreadsheet used is also in that same repository.

GitHub Repository

The repository can be found at https://github.com/brucemcpherson/GoingGas.

Repository Structure

Each set of material for each project is in a separate directory structure, organized as shown in Figure A-1 when cloned from Git.

If there is standalone Apps Script content for any topic, it will be in a subdirectory /gas/scripts and the expanded source will be in /gas/<source>/<thenameofthescript> as in Figure A-2.

When topics are container-bound, regardless of whether they are VBA or Apps Script, they will be in the containerbound folder.

Structure of a repository cloned from Git
Figure A-1. Structure of a repository cloned from Git
Directory structure for standalone Apps Script content
Figure A-2. Directory structure for standalone Apps Script content

gscript Files

A gscript file is a pointer to the cloud-hosted script file, rather than the file itself. On GitHub it will look like Figure A-3.

Figure A-3. gscript file

When opened in GitHub, it will show the URL of the script (Figure A-4 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required