- JavaScript 90.9%
- HTML 8.3%
- Python 0.6%
- GLSL 0.2%
| Filename | Latest commit message | Latest commit date |
|---|---|---|
Added comprehensive formula storage validation and hardening including atomic sheet resets, auto-recovery mechanisms, dropdown capacity optimization, and custom key formula experimentation. Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com> |
||
| scripts | ||
| test | ||
| .gitattributes | ||
| .gitignore | ||
| .md5-deployed | ||
| .zipignore | ||
| appsscript.json | ||
| ATOMIC_SHEET_RESETS_20261106.md | ||
| AUTO_RECOVERY_HARDENING_20261105.md | ||
| Code.gs | ||
| config.py | ||
| CUSTOM_KEY_FORMULA_EXPERIMENT.md | ||
| DROPDOWN_CAPACITY_AND_TAB_ORDER_20261105.md | ||
| DROPDOWN_DEPTH_REFACTOR.md | ||
| DROPDOWN_JOIN_FASTPATH.md | ||
| DropdownLocal.gs | ||
| ENV.md | ||
| FilterBatch.gs | ||
| FilterConsole.gs | ||
| FilterConsoleCustomTest.gs | ||
| FilterDetails.gs | ||
| FilterDropdownDepth.gs | ||
| FilterDropdownRecovery.gs | ||
| FilterDropdownSmart.gs | ||
| FilterEdit.gs | ||
| FilterEdits.gs | ||
| FilterHelpers.gs | ||
| FilterImport.html | ||
| FilterImportEmailGroups.gs | ||
| FilterImportRecovery.gs | ||
| FilterImportReports.gs | ||
| FilterImportSorterReset.gs | ||
| FilterImportStaging.gs | ||
| FilterImportVisibility.gs | ||
| FilterLogging.gs | ||
| FilterPriority.gs | ||
| FilterRecovery.html | ||
| FilterReset.gs | ||
| FilterResetProcess.gs | ||
| FilterRowBuffer.gs | ||
| FilterStage.gs | ||
| FilterWorkflow.gs | ||
| FilterWriteCoordinator.gs | ||
| FIX_MISSING_RESIZE_20261106.md | ||
| FORMULA_STORAGE_TEST.md | ||
| GMAIL_CONSOLE_DIRECT_REVERT.md | ||
| IMPORT_25_ROW_CHUNK_OPTIMIZATION_20261104.md | ||
| IMPORT_AUTORUN_CHANGELOG.md | ||
| IMPORT_CHUNK_SIZE_FROM_SETTINGS_20261104.md | ||
| IMPORT_CONSOLE_CHECKPOINTS.md | ||
| IMPORT_DYNAMIC_DROPDOWN_CAPACITY_20261104.md | ||
| IMPORT_EMAIL_BATCH_SUBSTEPS.md | ||
| IMPORT_EMAIL_GROUP_CHECKPOINTS.md | ||
| IMPORT_FINAL_REPORT_ORDER_CHECKPOINTS_20261105.md | ||
| IMPORT_FULL_RESET_SHARED_WITH_SHEET_RESET_20261106.md | ||
| IMPORT_LABEL_MODEL_CACHE.md | ||
| IMPORT_LIVE_CHUNK_RESIZE_20261104.md | ||
| IMPORT_LOGGING_AUDIT.md | ||
| IMPORT_RESUME_RECOVERY.md | ||
| IMPORT_RUN_CONTROL_RECONNECT_20261104.md | ||
| IMPORT_SAVED_XML_DIALOG_LOADING_20261104.md | ||
| IMPORT_SENDER_TIMING_20261104.md | ||
| IMPORT_SESSION_TAKEOVER_FIX.md | ||
| IMPORT_STAGING_BATCH_RECOVERY.md | ||
| IMPORT_STAGING_FINISH_SPLIT_20261105.md | ||
| IMPORT_TRUST_SETUP_NO_REVERIFY_20261104.md | ||
| IMPORT_VISIBILITY_REPORT_CHECKPOINTS.md | ||
| KEYS_A3_SERVER_PERSISTENCE_FIX.md | ||
| KEYS_DIRECT_CREATE_FIX.md | ||
| KEYS_RESET_STALE_SHEET_ID_FIX.md | ||
| KEYS_SHEET_HEADER_PERSISTENCE_FIX.md | ||
| KEYS_SHEET_PHYSICAL_RESET_FIX.md | ||
| LABELS_MENU_PRIORITY_TIMEOUT_FIX_20261106.md | ||
| LABELS_NAMED_EXECUTIONS_20261105.md | ||
| LABELS_REBUILD_CHECKPOINTS.md | ||
| LABELS_RESET_TIMEOUT_FIX_20261105.md | ||
| LabelsLookupImport.gs | ||
| LabelsRebuild.gs | ||
| LabelsRebuildDialog.html | ||
| LabelsRebuildSteps.gs | ||
| let-prompt.html | ||
| let-prompt.md | ||
| LOCAL_FULL_LOOKUP_TEST.md | ||
| LOCAL_GROUP_DROPDOWN_FIX.md | ||
| LOGGING.md | ||
| NOV4_2026_UPDATES.md | ||
| ONEDIT_NO_AUTO_REPAIR_20261105.md | ||
| OVERLAPPING_POLL_WORKERS.md | ||
| PER_POLL_DIAGNOSTICS.md | ||
| PER_ROW_SUBFOLDER_OPTIONS_20261105.md | ||
| PerformanceTrace.gs | ||
| README.md | ||
| REMOTE_DROPDOWN_COLLISION_FIX_20261104.md | ||
| REMOTE_DROPDOWN_EXPERIMENT.md | ||
| REMOTE_KEY_SYNC_EXPERIMENT.md | ||
| REPAIR_RESET_SETTINGS_UPDATE_20261105.md | ||
| REPORT_ORDER_LOAD_FIX_20261105.md | ||
| RESET_BEGIN_FASTPATH_20261106.md | ||
| RESET_DELETE_FIRST_20261106.md | ||
| RESET_KEYS_AND_IMPORT_REPAIR.md | ||
| RESET_PROCESS_EXPERIMENT_20261106.md | ||
| RESET_PROCESS_SETUP_20261106.md | ||
| RESET_SUBFOLDER_HELPERS_BLANK_20261105.md | ||
| RESET_TIMEOUT_CHECKPOINTS_20261105.md | ||
| Resilience.gs | ||
| RESUMABLE_FILTERED_UNFILTERED_RESET.md | ||
| SCOPED_WRITE_CLAIMS_20261106.md | ||
| SEQUENTIAL_SHEET_RESET_20261106.md | ||
| SETTINGS_ADMIN_TEMPLATE_20261104.md | ||
| SETTINGS_FORMAT_RESET_FIX_20261104.md | ||
| SETTINGS_LABELS_AND_SNAKE_CASE_20261105.md | ||
| SETTINGS_NAMED_RANGE_HTTP500_FIX_20261104.md | ||
| SETTINGS_NAMED_RANGES_AND_RESET_PERF_20261106.md | ||
| SETTINGS_RESET_CHECKPOINTS.md | ||
| SETTINGS_RESET_HTTP500_FIX_20261104.md | ||
| SETTINGS_RESET_SERVICE_FIX.md | ||
| SETTINGS_TEMPLATE_SORT_20261104.md | ||
| SettingsCore.gs | ||
| SettingsFormat.gs | ||
| SettingsLabels.gs | ||
| SettingsRangeNames.gs | ||
| SettingsRead.gs | ||
| SettingsReset.gs | ||
| SettingsResetDialog.html | ||
| SheetOrder.gs | ||
| SheetRepairCheckpoint.gs | ||
| SheetRepairDialog.html | ||
| SheetResetStandards.gs | ||
| SINGLE_OPTIONS_SPILL_20261104.md | ||
| SMART_REFRESH_NOTES.md | ||
| SorterResetCheckpoint.gs | ||
| SorterResetDialog.html | ||
| SorterResetFastClear.gs | ||
| SorterResetReplace.gs | ||
| SorterResetSequential.gs | ||
| STAGING_IMPORT_CHECKPOINTS.md | ||
| STATIC_TOP_LEVEL_DROPDOWNS_20261105.md | ||
| StorageFormulaTest.gs | ||
| SyncProgress.html | ||
| THREE_WORKER_KEY_SYNC_EXPERIMENT.md | ||
| TOP_LEVEL_LIVE_ROW_20261106.md | ||
Gmail Inbox Sorter — current local dropdown architecture
Updated November 5, 2026. Deploy the .gs, .html, and appsscript.json files as a complete Apps Script project. This build expects the current sheet layout; it does not migrate legacy dropdown sheets, Gmail Console companion tabs, or remote dropdown engines. An import with incompatible saved checkpoints should be restarted from the source XML rather than replayed against the new layout.
Important: updating an already-installed Apps Script project
The failing stack DropdownRemote:206 means the live project still contains
an obsolete script file. Delete DropdownRemote.gs, DropdownKeySync.gs,
and DropdownKeyCustom.gs from the existing project; replacing files from
this ZIP does not necessarily delete removed scripts. Remove the retired
fwDdSync... installable triggers, then restart the XML import instead of
resuming its prior checkpoint. See REMOTE_DROPDOWN_COLLISION_FIX_20261104.md.
The active engine now uses unique fwDdLocal... function names so an old
remote implementation cannot override the canonical Keys / option handlers.
lookupEnsureRows also resolves current physical tab identity by name before
expanding rows, avoiding errors from deleted/recreated cached sheet objects.
Dropdown sheets
DD_Filtered: KeysandDD_Unfiltered: Keysare hidden two-column tabs (A2 =Key, B2 =Lookup Index). They retain per-filter physical row mappings, including after row insertion/deletion. Lookup Index searches the complete alignedDD_Lookup: Sub Folder 1key list when descendants exist.- Top Level Folder dropdowns on both sorters share the unbounded
DD_Lookup: Top Level!B2:2validation.DD_Filtered: Top LevelandDD_Unfiltered: Top Levelno longer exist. DD_Filtered: Sub Folder NandDD_Unfiltered: Sub Folder Nare hidden option helpers. A2 containsOptions; A3, A4, A5, ... each hold their ownIFERROR(INDEX(...), "")lookup formula, spilling horizontally to match the actual depth option width. The matching row inDD_Filtered: KeysorDD_Unfiltered: Keys, column B, provides the lookup row index. Each sheet has precisely the number of option columns required for that level.DD_Lookup: Top LevelIMPORTRANGE imports only rows 1–2, ending at the actual last output column. Descendant lookup imports remain open-ended by row and retain their key columns. No redundant(Full)sheets are used.
Why the row formulas are slightly narrower than INDEX(B:ZZ, …, 0)
Google Sheets' INDEX(range, row, 0) returns all columns in the input range. B:ZZ is 701 columns, so the generated expression uses B:<actual last options column> from lookup metadata to avoid unnecessary spills. The outer IF(key="","",...) guard was removed at user request: formulas now use exactly IFERROR(INDEX(...), ""). Note: IFERROR only handles errors; if Sheets interprets a blank lookup index as 0, INDEX(...,0,0) can spill the source array instead of erroring.
Import / Format / Reset
- Format Sheet: Labels, Format/Reset of each sorter, and Refresh: Dropdowns support independent per-row option formulas. Existing legacy LET/MAP helper tabs are rebuilt in place on Format/Refresh, retaining their sheet IDs and live validation row references.
- Full XML import writes Keys formulas plus the corresponding option formulas in a single retryable sender-batch substep. Option formulas for all descendant levels are sent as one bulk Sheets API call, not as one call per row. Validation links and the shared top-level rule are then installed as before.
- Reset clears Keys data rows and trims them to 22 physical rows (2 headers + 20 data). New Sub Folder helpers contain only the styled Options header; their data rows have no formulas or values until Import or Format fills them.
- Inserted buffer rows and non-import label writes also populate the related option formulas. Labels Format/Reset and Refresh: Dropdowns repair missing formulas on the actual, validation-linked physical rows without rewriting healthy rows. The repair reads formulas through Sheets REST to avoid stale Apps Script sheet handles after grid growth.
- Import capacity checks, resumable checkpoints, hidden-until-committed sender groups, Gmail Console direct output, and Top Level dropdown behavior remain unchanged.
Local validation
Run node test/test-per-row-subfolder-options.js for the targeted architecture tests or node test/test-nov4-layout-and-template.js for the updated layout regression. The broader test/ suite contains pre-existing stale tests for older architectures; see the per-row changelog. Mocked tests cannot measure live Google Sheets dropdown latency, so test in a disposable workbook before production use.
2026-11-04 — 25-row optimized Full Reset import
See IMPORT_25_ROW_CHUNK_OPTIMIZATION_20261104.md for compact multi-sender
chunks, Drive Staging-page cache, consolidated dropdown validation, safe
single-pass verification/commit, timing diagnostics and resumability.
2026-11-04 — Trust helpers after setup; remove import verification
See IMPORT_TRUST_SETUP_NO_REVERIFY_20261104.md. Full Reset chunks now skip
all generated helper/header/validation audits and go straight from a Sheets
flush to commit. Add Missing batch validation also uses the expected metadata,
not live helper formula inspections. Repair Sheet / Refresh Dropdowns still
provide explicit verification when needed. Already-saved verify checkpoints
are accepted and skipped on resume.
2026-11-04 — Import chunk size read directly from Settings
Batch Size: Filters Import (Administrator, named range batch_size_filters_import) now controls both new imports and v3 live resizing without a code override. See IMPORT_CHUNK_SIZE_FROM_SETTINGS_20261104.md.
2026-11-04 — Saved XML history visible at dialog startup
The Import Filters modal paints the saved-run section immediately with a loading
placeholder while fetching Drive history. History and active-run detection run in
parallel, and Resume/Restart stay disabled until both are ready. See
IMPORT_SAVED_XML_DIALOG_LOADING_20261104.md.