Since actually downloading and learning to use the scripts I’ve made requires some time and effort, over the next few weeks I’d like to post a series of comments to help readers understand what the scripts do and why I think they may be useful.
My main pitch is “If you like AppSheet’s Application Documentation.html feature, you’ll love these scripts.” In other words, I think the scripts make the HTML documentation much easier to understand and use. Here’s an example from my main app, which has gotten quite big:
It says “16 Tables” but that is not actually correct – at least not correct from my perspective as an app creator. Here’s what my script produces:
====================================
PHASE 1: Parsing Tables and Slices
====================================
📊 Extracting data sources...
✓ Found 16 tables (9 regular, 1 system, 6 process)
📊 Complete Table Summary:
📁 Regular Tables: 9 (1,027 columns total)
├─ Archive: 78 columns
├─ Kankaku: 156 columns
├─ Options: 65 columns
├─ Overall: 116 columns
├─ Progress: 168 columns
├─ Seminar: 40 columns
├─ Settings: 173 columns
├─ Stats: 217 columns
├─ Welcome: 14 columns
📁 System Table: 1 (15 columns total)
└─ _Per User Settings: 15 columns
📁 Process Tables: 6 (1,008 columns total)
├─ Handle updated Kankaku record Process Table: 157 columns
├─ Process for Language change Bot Process Table: 176 columns
├─ Switch Enum Output: 173 columns
├─ Switch cram language Output: 173 columns
├─ Switch size language Output: 173 columns
└─ trigger update Output: 156 columns
📊 Total number of columns: 2,050 ✓
📊 Total number of tables: 16 ✓
📋 Loaded 56 slice-to-table mappings
✅ Slices saved to: appsheet_slices.csv
So it turns out that 6 of the tables are processing tables for bots and one is a system table.
The script only analyzes the 9 tables I call “Regular Tables” – the ones I made myself. It goes on to analyze them as follows:
📊 Regular tables to be analyzed (system and process tables excluded):
📁 Number of tables: 8
├─ Archive (4 slices)
├─ Archive 1: 14 actions, 78 columns
├─ Archive table 2: 1 action, 50 columns
├─ Archive table 3: 1 action, 48 columns
└─ Graph: 1 action, 78 columns
├─ Kankaku (8 slices)
├─ All Cards for menu: 23 actions, 105 columns
├─ Card stats: 1 action, 89 columns
├─ D to W: 8 actions, 54 columns
├─ Definition: 22 actions, 59 columns
├─ Finished cards: 0 actions, 83 columns
├─ Todays Cards: 11 actions, 137 columns
├─ W to D: 16 actions, 57 columns
└─ Word: 20 actions, 61 columns
├─ Options (4 slices)
├─ Add menu 1: 24 actions, 65 columns
├─ Archive index: 1 action, 38 columns
├─ Browse Archive: 7 actions, 40 columns
└─ Seminar 2: 13 actions, 65 columns
├─ Progress (1 slice)
└─ Last in progress: 1 action, 168 columns
├─ Seminar (2 slices)
├─ Seminar slice: 19 actions, 40 columns
└─ Seminar slice all: 12 actions, 40 columns
├─ Settings (26 slices)
├─ Cram: 7 actions, 93 columns
├─ Cram 2: 7 actions, 173 columns
├─ DWend: 2 actions, 65 columns
├─ Dictionary: 7 actions, 83 columns
├─ Dictionary list: 7 actions, 83 columns
├─ Error: 8 actions, 173 columns
├─ Error 2: 1 action, 173 columns
├─ Help: 6 actions, 173 columns
├─ Language flag: 3 actions, 69 columns
├─ Mail: 1 action, 173 columns
├─ Movie list: 11 actions, 95 columns
├─ NoCards: 1 action, 69 columns
├─ NoCardsCram: 1 action, 69 columns
├─ NoDtoW: 1 action, 173 columns
├─ NoWtoD: 1 action, 173 columns
├─ Number to add: 1 action, 65 columns
├─ Position: 1 action, 61 columns
├─ Schedule: 4 actions, 105 columns
├─ Session slice: 13 actions, 74 columns
├─ Settings import: 5 actions, 71 columns
├─ System language: 1 action, 173 columns
├─ Time zone: 1 action, 92 columns
├─ WDend: 2 actions, 67 columns
├─ Web cards: 1 action, 173 columns
├─ Word size: 1 action, 63 columns
└─ YouGlish: 7 actions, 83 columns
├─ Stats (5 slices)
├─ Card statistics: 2 actions, 18 columns
├─ Dictionaries: 182 actions, 217 columns
├─ Stats Explanation: 0 actions, 217 columns
├─ Stats index: 1 action, 18 columns
└─ Stats index J: 1 action, 18 columns
└─ Welcome (6 slices)
├─ Good job images: 1 action, 14 columns
├─ Hang in there images: 1 action, 14 columns
├─ Hello: 1 action, 14 columns
├─ Misc images: 1 action, 14 columns
├─ Morning: 1 action, 14 columns
└─ Welcome slice: 4 actions, 14 columns
📊 Total number of slices: 56
📊 Total number of columns in regular tables: 1,027
So, in fact, there are 1,027 columns that I made either in the spreadsheets the app uses or as virtual columns.
I had wondered about the huge number of columns (2050 in the Application Documentation HTML) but wasn’t sure how to check it. Now I know. 
Documentation: AppSheet Parser Suite - Technical Documentation
GitHub Repository: 
)
).
Why It Matters
How to Get Started
Real-World Impact