Form views allow you to quickly create shareable and embeddable forms, where each form submission becomes a new row in the worksheet.
Forms enable you to collect responses and data from anyone whether or not they are Spreadsheet.com users, making them a powerful tool for compiling user or personnel databases, collecting signups for an event, soliciting feedback on a product or initiative, and more. Each worksheet can have multiple forms for multiple purposes.
When a user submits your form, Spreadsheet.com creates a new row in your primary sheet that captures the submitted information in the appropriate columns.
This article features Spreadsheet.com's Alumni Directory template. Explore the Template Gallery to find ready-to-use templates in over 20 different categories, or learn more about starting a new workbook from a Spreadsheet.com template.
Creating Form Views
Configuring Your Form
After creating your new Form view, you can configure the form fields and the way it will appear to those it is shared with. In the examples below, we're creating a new form view in an Alumni Directory workbook so that new alumni can submit their information and be recorded in the directory worksheet.
When creating a form, each column in your worksheet can be used as a form field. You can choose whether fields are hidden or visible, required or optional, and if they should have a default value. You can also configure column data types within the form designer, and add new columns as needed without switching back to a Sheet view.
You can add columns into your form as fields by dragging and dropping them from the Fields panel on the left side of the screen, or by clicking the + icon in the lower right corner of a selected field. From the Field settings panel on the right side of the screen, you can change the settings for each individual field in your form.
You can also brand your form with a custom logo (up to 20MB) and background color from the top of the form, as well as add text blocks for description elements.
Custom branding for forms is a premium feature available on Premium and Enterprise plans. To learn more about Spreadsheet.com's paid plans, see our suite of articles on Billing, Payment, and Credit.
At the bottom of the form view window, you can specify Submission behavior that will determine what happens on both the backend and frontend when a user submits your form. You can specify a confirmation message or redirect to a URL, allow users to resubmit a form or notify certain users that a form has been submitted.
Additionally, you can enable Security measures like requiring reCAPTCHA for submission or restricting submissions to Spreadsheet.com users, as well as toggle Spreadsheet.com branding on and off.
Once you've configured your form, click the Open form button in the Views menubar to view a live preview of your form as it will appear to those you share it with.
Sharing Your Form
When you're ready to share your form and begin collecting responses, you can do so by sharing it via a link, or embedding it in any third-party site or app that supports iframes. To access either option, click the blue Share form button in the Views menubar.
The live form uses a simple responsive design by default, enabling it to work equally well across desktop and tablet browsers...
...or mobile browsers:
What happens when a form is submitted?
When a form is submitted, Spreadsheet.com creates a new row at the bottom of your worksheet that captures the submitted information in the appropriate columns. This works with all data types, including attachments, related rows, users, and more.
Read on through the rest of our articles on Views and View Types to learn more about each of the view types Spreadsheet.com offers, as well as more information about locking views, changing view permissions, and managing your existing views.