-
HewteeAsked on October 29, 2020 at 2:29 PM
I've just seen my submissions table now in GSheets https://www.jotform.com/tables/202191619019553
If I could just separate the items in Column F I would be very very happy. There has got to be a way?
-
John Support Team LeadReplied on October 29, 2020 at 2:43 PM
Unfortunately, we do not currently have a setting to separate the products into different cells on Excel but there's a workaround for that. You can check it on this thread https://www.jotform.com/answers/409905.
-
HewteeReplied on November 2, 2020 at 1:28 AM
Thanks for this but that means I have to do this each time I download the excel. Did I use the wrong element in the first place and if so which element would allow for an export that would show each item ordered in a seperate cell?
-
Amin_NReplied on November 2, 2020 at 3:43 AM
That requires ditching the payment/order field entirely, then adding normal form fields and widgets such as drop-down, Inventory Widget, text input, etc.
Then use the Calculation widget to calculate total price of all products selected within fields. Total Price can then be passed to Payment Integration.
Related guide: How-to-Pass-a-Calculation-to-a-Payment-Field
I hope I have been of any help.