When spreadsheet data needs to be collected, analyzed, and submitted in a simple spreadsheet format, the Spreadsheet widget is the ideal tool you can use. Your form users can now submit structured data sets that you can use in a spreadsheet – or for any purpose where cell-value data sets are critical.
This guide will show you how to set up the Spreadsheet widget. Please watch the following video or read below for the steps:
- In the Form Builder, click the Add Form Element button.
- Go to the Widgets tab.
- Search for Spreadsheet, and click it to add.
- Set up the following options in the Widget Settings:
- Number of Rows — To display how many rows you want to add.
- Number of Columns — To display how many columns you want to add.
- Column Labels — You can use this section to show a different label instead of the letters. Adding labels is optional.
- Default Values — In this section, you can add a value for each cell in the Spreadsheet.
- Read Only — This section is where you can set cells as read-only.
- Click the Update Widget button to save your settings.
The first two options are straightforward, so let’s start with the Column Labels. As explained above, this allows you to change the letters to custom cell labels. See the below image as an example of the labels:
The widget will require you to input labels for all columns, each separated by a comma or a new line.
The first three options are straightforward, so let’s start with the Default Values box. For example, you want Column A, Row 1, with a value of 1500. You only need to enter A1 1500 at the Default Value box. See the below image:
You can also assign a calculation value for a specific cell. The calculation formula will only need to start with the Column Letter and Row Number followed by a single space, an equal sign (=), and then the equation of cells. For example, if you want the sum of Row 1, Columns A, B, and C to Row 1, Column D, enter the following formula:
D1 = A1+B1+C1
This section allows you to set cells as non-editable. Useful for cells with the calculated value. For example, if you want to make all Five (5) rows of Column D non-editable, input D1, D2, D3, D4, D5 in the Read-only box.
You can see the demo form here: https://www.jotform.com/222478575946068.