Sheetward User Guide

Form specification

Every Form_ sheet describes one form. Sheetward reads the sheet's layout to work out the fields, their order and the form's shape — this page shows the layouts it supports, from a quick single-section form to the classic header-plus-line-items document.

Form title. Enter the form's display title in cell A1 and leave an empty row below it. The title becomes the form's heading in the app, and the empty row tells Sheetward where the title ends and the fields begin.

Single-section forms — one set of fields, two ways to write them:

• Fields in columns. Field names across one row, with sample values in the row (or rows) beneath — one column per field, like a small table. Sample values are used only to detect each field's data type; they are never imported as records.
• Field : value pairs. One field per row — the field name in column A with a sample value beside it. Reads like a paper form.

Two-section forms — the classic document: a header (one record) with a repeating line-items table beneath it, marked with HEADER and LINE ITEMS rows:

• Header section: its fields may use either arrangement — columns or field : value pairs.
• Line-items section: always the column arrangement — a row of field names above the item rows, placed below the header section.