The Sheetgo Form is a tool that can be used to collect a variety of information and data in an easy way. But, if your form is either too long or repetitive it might become difficult for a user or client to fill it out. To avoid this you can use some of Sheetgo configurations to optimize your forms and build a more streamlined layout.

You can divide your form into different sections, this will allow you to separate the fields by the type of information that you need, making them more intuitive to complete. You can also add specific descriptions for each sections, explain what type of information is needed to complete the section. To use this configuration, just add the following tags on the desired sheet columns:

On your spreadsheet, the configuration will look like this:

The final result will look like the image below.

If your form is too long or it has different sections you can use the [page] configuration. This will separate the question into different pages when showing the form, maintaining all the collected data in the same spreadsheet. To create the pagination you need to add a tag in each column with the page label:

You can also use a numeric sequence instead of a name:

Either way, the final layout will look the same, with a series of dots at the bottom of the form showing the number of pages. As the fields are completed the user can go to the next page by clicking on the Next button.

If your form has a series of repeatable fields you can use the [grouped] configuration. This will allow the user to submit several answers at once by duplicating the questions grouped and typing new answers independently from the previous one, without the need to add new columns to your spreadsheet. Each column with this tag will be grouped at the end of the form.

When a client/user fills out the form, each item of this repeatable group will generate a new line on the spreadsheet and the fields that are not grouped by this feature will have the same value appended to each of these new lines.

This configuration can be used on an invoice form, which has fixed fields such as date, email, and name, and repeatable fields such as product, quantity, and price, that would be grouped by this configuration, allowing the user to submit more products at once.

On your spreadsheet, this configuration would look like this:

While the form layout will look like the image below.

The grouped fields are placed inside a box, separating them from the other fields. To add a new set of fields you just need to click on the blue button at the top right corner of the box.