-
SueMuldoonAsked on January 22, 2018 at 3:05 PM
When I get a report in excel with online sales, it is all gathered in one cell. Is there a way to have it broke down into individual product columns?
-
aubreybourkeReplied on January 22, 2018 at 4:15 PM
Can you tell me which form you are talking about?
-
SueMuldoonReplied on January 22, 2018 at 4:24 PM
https://form.jotform.com/41586881211153
-
SueMuldoonReplied on January 22, 2018 at 4:43 PMHere is a sample form:
https://form.jotform.com/41586881211153
When the excel sheet comes in, all the orders come in one cell.
I would rather they came in independent cells.
Is that possible?
_______________________________
Sue Muldoon
860-394-5470
www.suemuldoonimages.com
www.reduxforyou.com
www.farmersmarkettrail.com
Follow us here:
[1488378249742_Linkedin.png] LinkedIn [1488378365999_Instagram.png] Instagram [1488378477405_Twitter] Twitter [1488378521819_Facebook.png] Facebook
________________________________
... -
Kevin Support Team LeadReplied on January 22, 2018 at 6:28 PM
Thank you for the details.
Unfortunately, the payment information cannot be separated on reports, the information submitted there counts as a single field and the array of data is tied to the payment field.
If you would like to have products separated per cell, then you will need to use basic fields instead, perform the calculations and pass the total to the payment field, these guides will help you doing so:
https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget
https://www.jotform.com/help/301-How-to-Assign-Calculation-Value
https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field
I hope this helps.
-
SueMuldoonReplied on January 22, 2018 at 8:43 PMThank you
Sent from my Verizon, Samsung Galaxy smartphone
...