{ "chapters": [ { "label": "Chapter 1", "id": "1", "text": "Welcome to Programming", "sections": [ { "text": "1.1 What Programming Actually Is", "id": "what-programming-actually-is" }, { "text": "1.2 How Computers Think", "id": "how-computers-think" }, { "text": "1.3 Why JavaScript Is a Great First Language", "id": "why-javascript-is-a-great-first-language" }, { "text": "1.4 How to Run JavaScript", "id": "how-to-run-javascript" } ] }, { "label": "Chapter 2", "id": "2", "text": "Your First Lines of Code", "sections": [ { "text": "2.1 Writing and Running Simple Statements", "id": "writing-and-running-simple-statements" }, { "text": "2.2 console.log() and Basic Output", "id": "console.log-and-basic-output" }, { "text": "2.3 Understanding Errors and Debugging Early", "id": "understanding-errors-and-debugging-early" }, { "text": "2.4 The Idea of Syntax and Structure", "id": "the-idea-of-syntax-and-structure" }, { "text": "2.5 Transitioning to Google Apps Script in Google Sheets", "id": "transitioning-to-google-apps-script-in-google-sheets" } ] }, { "label": "Chapter 3", "id": "3", "text": "Getting Started with Google Apps Script in Google Sheets", "sections": [ { "text": "3.1 Welcome to Google Sheets as a Programming Environment", "id": "welcome-to-google-sheets-as-a-programming-environment" }, { "text": "3.2 Opening the Apps Script Editor", "id": "opening-the-apps-script-editor" } ] }, { "label": "Chapter 4", "id": "4", "text": "Variables and Data", "sections": [ { "text": "4.1 What Variables Are and Why They Matter", "id": "what-variables-are-and-why-they-matter" }, { "text": "4.2 Primitive Types: Strings, Numbers, Booleans", "id": "primitive-types-strings-numbers-booleans" }, { "text": "4.3 Working With Variables in Apps Script", "id": "working-with-variables-in-apps-script" }, { "text": "4.4 Working With Text and Numbers", "id": "working-with-text-and-numbers" }, { "text": "4.5 Naming Conventions and Best Practices", "id": "naming-conventions-and-best-practices" } ] }, { "label": "Chapter 5", "id": "5", "text": "Making Decisions", "sections": [ { "text": "5.1 if, else if, else", "id": "if-else-if-else" }, { "text": "5.2 Comparison and Logical Operators", "id": "comparison-and-logical-operators" }, { "text": "5.3 Real‑World Examples of Decision‑Making in Apps Script", "id": "realworld-examples-of-decisionmaking-in-apps-script" } ] }, { "label": "Chapter 6", "id": "6", "text": "Arrays", "sections": [ { "text": "6.1 Why Arrays Matter in Apps Script", "id": "why-arrays-matter-in-apps-script" }, { "text": "6.2 Understanding Arrays", "id": "understanding-arrays" }, { "text": "6.3 Arrays and Google Sheets", "id": "arrays-and-google-sheets" }, { "text": "6.4 Writing Arrays Back to the Worksheet", "id": "writing-arrays-back-to-the-worksheet" } ] }, { "label": "Chapter 7", "id": "7", "text": "Loops and Repetition", "sections": [ { "text": "7.1 Why Loops Matter", "id": "why-loops-matter" }, { "text": "7.2 The while Loop", "id": "the-while-loop" }, { "text": "7.3 Example: Using a while Loop to Process data in a Sheet", "id": "example-using-a-while-loop-to-process-data-in-a-sheet" }, { "text": "7.4 The for Loop", "id": "the-for-loop" } ] }, { "label": "Chapter 8", "id": "8", "text": "College Community Garden: Case setup", "sections": [ { "text": "8.1 Introduction", "id": "introduction" }, { "text": "8.2 The founder’s realization", "id": "the-founders-realization" }, { "text": "8.3 Pitching the idea", "id": "pitching-the-idea" }, { "text": "8.4 The Club’s Mission Takes Shape, and You Step Up", "id": "the-clubs-mission-takes-shape-and-you-step-up" }, { "text": "8.5 Your “Aha!” Moment: Apps Script to the Rescue", "id": "your-aha-moment-apps-script-to-the-rescue" }, { "text": "8.6 Setting the Stage for Automation – With Your Help", "id": "setting-the-stage-for-automation-with-your-help" } ] }, { "label": "Chapter 9", "id": "9", "text": "Introduction to Google Forms", "sections": [] } ], "bookInfo": { "title": "Personal Productivity with Javascript", "authors": [ "Gove Allen", "Mattia Allen" ], "chapterLabel": "Chapter" } }