The challenge
The team needed fast editing of two specific columns but kept accidentally overwriting formula and PK columns in the raw sheet.
The solution
A Google Apps Script project with two surfaces: a modal Data Manager opened from a sheet menu (onOpen → 'Open Manager') and a doGet web-app deployment. Code.gs exposes a CONFIG with DISPLAY_COLUMNS, FILTER_COLUMNS and EDITABLE_COLUMNS whitelists. getAllData returns a normalized JSON payload for the HTML UI; commit handlers accept writes only to whitelisted columns.
Results
2 (modal + web app)
Surfaces
13 display / 2 filter / 2 edit
Whitelist