-
jgeastmbAsked on May 23, 2024 at 7:44 AM
Please see the video link. I can not figure out why only one of my products is showing up on the spread sheet.
-
Mahmoud JotForm SupportReplied on May 23, 2024 at 8:08 AM
Hi Jodi,
Thanks for reaching out to Jotform Support. I checked your screencast but it is frozen on the My Forms page when you try to show us the form submission. I believe that you're referring to the selected products shown in the product column. This is the behavior of the Submissions table. You need to click on it to show the remaining list of the selected product by the users. See the screencast below for more details:
Give it a try and let us know if you are looking for something else.
-
jgeastmbReplied on May 23, 2024 at 8:25 AM
Thank you, I do see that now. But how do I get it to give me a spreadsheet with the individual products and totals of how many of each in each size it need. The excel spread sheet puts all the items in one field. What I need is a spread sheet with the persons name, then each product individually in a column with the sizes.
Thank you Mahmoud
-
Eliza JotForm SupportReplied on May 23, 2024 at 8:40 AM
Hi Jodi,
Thanks for getting back to us. Currently, we have no control over how the data is exported to spreadsheets. If you are using a payment field in the form, it is treated as a single field. The items will be under the same Product List column for now. You can try splitting the text into different columns in Excel.
Let us know if you have any other questions.
-
jgeastmbReplied on May 23, 2024 at 8:52 AM
is there another way to get totals for each item
-
Jason JotForm SupportReplied on May 23, 2024 at 9:26 AM
Hello Jodi,
Thanks for getting back to us. If you'd like the details of each chosen item and the name of the form responders to be displayed on a Spreadsheet, I suggest integrating your form into Google Sheets. It's really easy. Let me show you how:
- In the Form Builder, in the orange navigation bar at the top of the page, click on Settings.
- Select Integrations in the left corner.
- Search Google Sheet and click on it.
- Select your account to Authenticate.
- Next, I suggest choosing Create a New Spreadsheet and click on Save once done.
- Click Finish to complete the integration.
- Here's the result of the integrated Google Sheets in the form.
You can choose whatever form fields you wish to be displayed on your integrated Google Sheets. We also have an additional guide here explaining how to integrate your form with Google Sheets.
Let us know if you need any more help.