Free Dynamic CRUD Web App – Google Sheets Apps Script

R35 is the base dynamic CRUD app the rest of this series builds on. Create, read, update and delete against a Google Sheet — with the crucial difference that the fields are not written into the code. They come from the sheet, so the app reshapes itself when your data does.

Fields defined by you, in the spreadsheet

Start with a student ID and a name. Decide you need a father's name: add it to the form sheet with its type, add the matching column to the database sheet, refresh once, and it is on the add form and in the table. Add city, state, province, continent the same way. The only refresh you ever need is after changing the structure — adding, editing and deleting records need no reload at all.

Edit and delete follow the row

This is worth knowing because it is where similar apps go wrong. The edit and delete actions operate on the row whose button you pressed, not on a matched ID. Change an ID and press submit and that same row updates, rather than the app going looking for a different record with the new value.

What it does not do

Field types are text and number. Dropdown fields are not implemented in this version, so a column that should be a fixed list is a free-text box here. Worth knowing before you plan a form around it — the later files in this series add filters, passwords and multi-sheet support on top of this base.

Speed and placement

The walkthrough loads a deliberately large dataset to show it still responds quickly. The deployed app embeds into Blogger or any website through an iframe, so it can live inside a site rather than as a bare script link.