CLIENT RECORDS SYSTEM WEB APP | HTML FORM DATA TO GOOGLE SHEET | R33

A client register that refuses a half-finished record. Every field is required, and the form tells you exactly which ones are still missing — by name, one at a time, until the record is complete.

Validation that guides rather than scolds

Press submit on an empty form and it lists the fields you still owe it. Fill the contact and that field drops off the list. Fill the serial number and it drops off too. You are never left staring at a generic "please complete all fields" wondering which one it means. For a register that other people fill in, that difference decides whether your sheet ends up with gaps in it.

The date rule

Records carry a start date and an expiry date, and the expiry cannot come before the start. Enter the 24th as an expiry against a 25th start and it is refused. A back-to-front date pair looks harmless in a spreadsheet and quietly breaks every report and reminder built on top of it later — catching it at entry is the only cheap place to catch it.

What it suits

Any client record with a validity period attached: vehicle documents, insurance policies, registrations, service contracts, memberships. The fields include contact, serial number and vehicle alongside the dates, and everything lands in your own Google Sheet.

One setup warning

The sheet tab name and the sheet name in the script must match exactly. It is the single most common reason this kind of build appears not to work, and the walkthrough calls it out directly.