Form builder

At a glance

The form builder lets you create input interfaces linked to your spreadsheets. Responses submitted via a form are automatically added as new rows in the associated spreadsheet.

Before you begin

• Have an existing spreadsheet with defined columns
• Have editing permissions on the workspace

Creating a form

1. Open the target spreadsheet.
2. Click on the ... menu (three dots) at the top right.
3. Select Create a form.

The form editor opens with one field per spreadsheet column.

Configuring fields

Field structure

Each form field is linked to a spreadsheet column and has the following properties:

Property	Description
Label	Name displayed to the user (default: column name)
Description	Help text displayed below the field
Required	If enabled, the form cannot be submitted without this field
Default value	Pre-filled value
Placeholder	Hint text in the empty field

Field types

The field type is automatically determined by the spreadsheet column type:

Column type	Form field
Text	Text field (single line or multiline)
Number	Numeric field with +/- arrows
Date	Date picker
Checkbox	Checkbox
Selection	Dropdown menu
Multiple selection	Multi-choice dropdown menu
Email	Email field with validation
URL	URL field with validation
File	File drop zone

Reordering fields

Drag and drop fields to change their order of appearance in the form. The field order in the form is independent from the column order in the spreadsheet.

Hiding fields

Uncheck a field to exclude it from the form. This allows you to collect only a subset of the spreadsheet columns.

Customizing the appearance

Option	Description
Title	Title displayed at the top of the form
Description	Introduction text before the fields
Confirmation message	Text displayed after successful submission
Submit button	Button text (default: "Submit")

Publishing the form

Internal sharing

The form is accessible to members of your workspace via the internal link. No additional configuration is needed.

Public form

To collect responses from external people:

1. Enable the Public form option.
2. Copy the generated public link.
3. Share this link by email, chat or embed it in a website.

info

Public forms do not require sign-in. Anyone with the link can submit a response.

Viewing responses

Submitted responses appear as new rows in the spreadsheet, with a Submission date column added automatically. You can use filters to sort and organize responses.

Editing or deleting a form

• Edit: open the form from the spreadsheet menu and adjust the fields.
• Delete: in the spreadsheet menu, select Delete form. The public link stops working immediately. Data already collected remains in the spreadsheet.

See also

• Column types — Define types for form fields
• Editing data — Edit collected responses
• Filters and views — Organize responses

Need help?

Contact us: Support and contact.