Sheets

Sheets

Sheets allows you to storage information to link to your forms.

Sheets allows you to upload and storage information on a spreadsheet to link to your forms.

In this article we will be showing you

- Where to find sheets

- How to set up a sheet

- Editing sheets

Where to find sheets

To find sheets, you need to navigate to the 'Tools' dropdown menu in the top right hand corner, next to your account name, and click on 'Sheets'

tools_menu-1

This will get you to the sheet page.

Setting up a sheet

Once you have got on the sheet page, click on the plus button in the top right hand corner.

plus

A popup window will appear for the sheet name, what folder you would like the place the sheet and the upload button. You will need to upload an existing sheet to start with so we can add the columns and have a starting point.

sheets3

Once you have filled in the popup window, click on ‘Add’. You will be taken to your sheet information page.

sheets4

You will also see the sheet on the sheet page. Your sheets status will be live if it has been linked to a form and not live if not linked to a form. 

sheets5

Editing a sheet

To edit a sheet, find your sheet you wish to edit then click on the pencil icon

sheets6

A pop window will appear of the information on the sheet.

sheets4

If you wish to add information to the sheet, click on ‘Add submission’ and this will allow you to add information.

sheets7

If you need to delete information, find the information you wish to delete, click on the check box next to it and then ‘Delete’ will appear at the top of the page.

sheets8

Once you click ‘Delete’ the information will disappear.

Once you have edited all your information, click on the back arrow at the top left of the page.

sheets9

If you need to delete the whole sheet, find the sheet and click on the check box. ‘Move to Trash’ will appear at the bottom of the page. Click on that will delete your sheet.

sheets10

At the bottom of the sheet information is what form the sheet is linked to. Take a look at Data Search to see how to link the sheet to a form.