Sheetgo Forms collect information straight into your spreadsheet, but a long or repetitive form is hard to fill out. Three configurations help you organize the layout: section divides the form into titled blocks, page spreads the questions across several pages, and grouped makes a set of questions repeatable. This article covers all three. For the full list of configurations, see Configure your Sheetgo Forms.
Sections
Divide your form into sections to separate questions by the type of information you need, and give each section a description that explains what to enter. Add these tags to the desired sheet columns:
section creates a section with the title you specify. The section renders right before the question it's added to.
sectiondescription adds a description under the section title. It only works on a column that also has section.
On your spreadsheet, the configuration looks like this:
Name of borrower [section:"Borrower", sectiondescription:"Enter the name of the company that is borrowing an item"] Item name [dropdown, section:"Items", sectiondescription:"Select the item and specify the quantity that will be borrowed"] Quantity
Pages
If your form is long or covers different topics, page splits the questions across several pages while all the answers stay in the same spreadsheet. Add the tag to each column with the page it belongs to: every question on the same page carries the same value. A page tag written without a value is ignored, so it doesn't move the question anywhere.
You can name the pages:
Question one [required, page:"Personal data"] Question two [required, page:"Personal data"] Question three [required, page:"Invoice data"] Question four [required, page:"Invoice data"]
Or use a numeric sequence:
Question one [required, page:1] Question two [required, page:1] Question three [required, page:2] Question four [required, page:2]
Either way, the form shows a row of dots at the bottom indicating the number of pages, and the person clicks Next to move to the next page.
Grouped questions
grouped makes a set of questions repeatable, so one submission can register several items without adding new columns to your spreadsheet. Add grouped to every question in the repeatable set; the form shows the whole set together at the end, inside a box separated from the other questions.
Each repeat writes its own row to the spreadsheet. Answers to ungrouped questions repeat on every one of those rows, so each row stays complete on its own.
This works well for an invoice form, which has fixed questions such as date, email, and name, and repeatable ones such as item, quantity, and price. Grouping the repeatable questions lets one person submit several products at once. On your spreadsheet, the configuration looks like this:
Invoice date * [default:today] Client email address * Client name Item description * [grouped] Item quantity * [grouped] Item price * [grouped]
In the form, the grouped questions sit inside a box at the end, separated from the other questions.
To add another set of answers, the person clicks the blue button at the top right corner of the box.
One rule to keep in mind: grouped and page do not mix on the same questions. A page tag on a grouped question silently ungroups the whole set, so keep the repeatable block free of page markers.
Give each repeat its own identifier
You can pair grouped with default:incremental or default:random. On a column that also has grouped, either one assigns a different identifier to each repeat. On a column without grouped, they generate the same identifier for every row of the submission, which helps you track the rows that were submitted together.
You can combine both strategies in one form. For example, use default:random on an ungrouped column to generate an ID for the whole submission, and another default:random inside the group to give each added item its own ID.
Not sure how to structure a long form? Open the chat in the bottom-right corner of this page and describe what you're collecting. We'll suggest a layout.
Related articles