Multi-Step Form with Draft Auto-Save – Google Apps Script

A multi-step form that behaves like a real application form rather than a long list of inputs. The fields are configured from Google Sheets, the answers land in Sheets, uploaded files go to Google Drive, and the person filling it in gets a confirmation email. No backend database anywhere.

What it does

The form is split into steps with a preview before submission, which is what stops half-finished entries, and it auto-saves a draft as the user goes — the single most important feature on any form long enough to need steps, because a lost form is usually a lost applicant. The field types cover what real forms actually ask for: file uploads by drag and drop, a signature pad, star ratings, date and time pickers, toggles and sliders, phone numbers that format themselves and a password strength indicator. Because the configuration comes from the sheet, changing the questions does not mean changing the code.

Highlights

• Dynamic form configuration from Google Sheets
• Multi-step flow with a preview step
• Drag-and-drop file upload to Google Drive
• Signature pad, star ratings, sliders and toggles
• Date and time picker, phone auto-formatting
• Draft auto-save
• Automated email confirmation
• Mobile responsive

Who it is for

Admissions, job applications, registrations, onboarding, surveys and service requests — anywhere the form is too long or too detailed for a basic form tool, and the answers need to end up in a spreadsheet you control.