How to add additional fields to excel report?

Hi how do I add fields/columns to the excel report for example we asked a question and the user selected a check box, that info was captured but the quantity and total was not captured how do we capture that info

Hi trbcmediateam,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

To add additional fields or columns to your Excel report, such as capturing quantity and total along with checkbox selections, you can use the Spreadsheet to Form Widget. Let me show you how:

1. Create a spreadsheet with your data structured properly. Make sure the column names in the spreadsheet match the field names on your form, and include a unique column like an ID to distinguish the data.

2. In Form Builder, click on the Add Element menu on the left side.

3. Go to the Widgets tab, search for the Spreadsheet to Form widget, and add it to your form.

4. Upload your Excel data file by dragging and dropping it into the Upload File area on the right menu.

5. Select the unique column in the Access Code Column option by clicking the downward arrow icon.

6. Customize the widget texts if needed, then click Update Widget to save changes.

Now, when users fill out your form and enter the unique code from the spreadsheet, the corresponding fields like quantity and total will auto-populate when they click Auto Complete Fields.

Give it a try and let us know how it goes.

I have users completing a form, and they are making a selection between Package A or B and also selecting how many of A or B they want and then the price is totaled. Is there a way to capture the total price and the quantity they selected in the Submission table?

Hi trbcmediateam,

Thanks for reaching out to Jotform Support. You can show the total pricing on the form in just a few easy steps. Let me show you how:

1. Open your form in Form Builder and select the Product List field.
2. Click on the List icon to open Product List Properties.
3. Now, click on Settings and then scroll down a little and enable Show Total Price On The Form. That’s it.

Viewing the total price of your items in Jotform Tables easily. You can do that using a Total Cost column. Let me show you how:

1. In Form Builder, click on the Add Form Element menu on the left side of the page.
2. Under the Widgets tab, drag and drop a Form Calculation widget under your Product List field.
3. Now, in the menu on the right side of the screen, click on Add Field and select the Product List field.
4. Click on Save and that’s it. You’re done.

Also, to prevent changes in the Form Calculation widget, you can hide it. Let me show you how:

1. In Form Builder, select the Form Calculation widget.
2. Then, right click on the Six Dots icon and select Hide.

Now, you can see the total cost column in your Table:

When users submit the form, the quantity they selected and the total price for each product will be captured and visible in your submission table automatically.

If you want to generate an Excel report including these fields, you can create an Excel Report from your form submissions and select the relevant fields (quantity and total price) to include in the report.

Give it a try and let us know if you need any other help.