- boomtowndesignsAsked on March 04, 2018 at 05:18 PM
I integrated google sheets to my form and a spreadsheet was created but form submissions are not populating.
Also, how do I make a new column for each product option instead of having all my t-shirt sizes in 1 cell?
- JotForm SupportNik_CAnswered on March 05, 2018 at 02:49 AM
I cloned your form and tested the Spreadsheet integration, but I wasn't able to replicate an issue.
Regarding the product creating, please follow:
Let us know if you have any further questions.
- boomtowndesignsAnswered on March 05, 2018 at 10:32 AM
I wasnt able to get my form to populate in sheets so I cloned it and the cloned form worked! I know how to create products, my question is how to get the product quantities to show in their own columns in google sheets which is the whole reason why I want to use sheets is to count the individual size quantities of shirts! Thanks.
- JotForm Supportashwin_dAnswered on March 05, 2018 at 11:49 AM
Do you mean to say that you want to separate the data of your payment tool and display in the separate column of google spreadsheet?
Unfortunately there is no built in feature to achieve your requirement but with a little workaround, it is possible to achieve your requirement. Here are the options available:
#1. You can use regular form fields to list your product and the quantity of different sizes. You can then add "Form Calulation" widget to calculate the amount and pass the data to your payment tool. You may like to take a look at the following guide which should help you:
#2. You can yourself slit the data of payment field and display it in excel file. You may like ot take a look at the following guide which should help you:
Hope this helps.
Do get back to us if you have any questions.