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 ...

Get Going GAS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.