Collect data into your sheet with a customizable form. You can send a link to the form via email or embed the form in a website. When someone fills out the form, the information will be added to your sheet as a new row.
How it works
Open the Forms tab at the bottom of a sheet
Enter a title for your form and any instructions (optional)
A preview of your form is displayed on the right
Click on the Column options link to select:
Selected Columns - you can include all or a subset of the columns on your sheet as fields on the form
Display Options - for free text fields, you can choose single line entry or multi-line entry. For a dropdown list column, you can choose a dropdown list or radio button display.
Required Field - indicate any columns (fields) you want to be required to complete the form
Default Value - you can enter a default value to speed data entry
Help Text - you can also provide explanatory text for a field to help people fill out your form correctly
Click on the File attachment options link if you want people to be able to upload a file when they fill out your form. The file will be included as an attachment on the new row in your sheet.
Click on the Form options link if you want to:
customize the confirmation message that people see after completing your form
after a form is created, present a new blank form to encourage multiple entries
enter a website URL to which you want people sent after filling out your form
brand your form with the logo and color settings associated with the sheet
Save your form
On the Forms tab, click on the URL or Embed field and use Ctrl+C keys to copy the link.
Use Ctrl+V to paste the link into an email or webpage.
Entries made to the form will add new rows to the sheet.
