CRUD Web App with 5-File Upload – Google Sheets Apps Script

A records system where the documents come with the record. Five files can be uploaded at once against one person — CV, ID scan, certificate, contract, photograph — and opened again from their row.

Files and the record together

Every employee carries ID, name, gender, address, email, phone, organisation and position, plus their uploaded files. The uploads land in a Google Drive folder, and the script finds that folder by name rather than by a pasted ID — so configuration is typing "assets" instead of hunting through a URL for a long string. A file icon in the row opens what was uploaded.

Editing without losing the attachments

Records edit in place and delete with a confirmation, and the files stay attached through the edit. That is the part that usually breaks in sheet-based CRUD builds: an update writes the row back without its file references and the documents are orphaned in Drive.

A table that works on a phone

Search covers the whole table, and the page size runs from five rows to a hundred. On a narrow screen the table does not spill sideways — an expander appears on each row that opens the columns which do not fit, including the files and the action buttons. A desktop table squeezed onto a phone is the most common reason these apps go unused on the floor.

Deploying

Deploy it as a web app and embed the URL in WordPress, Google Sites or any page you can edit, so staff reach it through your own site.