Selected product items in spreadsheet are all in one cell

  • habitatjackson
    Asked on September 19, 2014 at 5:18 PM
    the other question that I ask every year is that when the customer picks their choices of flowers the amounts are all in one cell of a spreadsheet. We would like to have that info broke out. Wondering if there is a better solution since I built this form 3 years ago.
  • KadeJM
    Replied on September 19, 2014 at 5:45 PM

    We understand you want to split up your selected product items which are currently all in one cell.

    I looked at some of your previous threads mainly the one a year ago here involving google spreadsheets where you had two issues. and found that second one was fixed and our developer mentioned he had split the "payment details" it into three columns but I believe that it is pertaining to PayPal Mostly and the payment information used instead of the product itemization. 

    However, after testing this some and to my recent knowledge it seems that this is currently not possible. 

    I've sent this over to our developers and we'll update you about this as soon as we can.

    Selected product items in spreadsheet are all in one cell Image 1 Screenshot 20

  • habitatjackson
    Replied on September 19, 2014 at 5:51 PM

    hmmm, I just found this calculations option where you can create fields and add them together

    I think this might work for us, can you look at them, and tell me if you think this solves the problem?

    http://form.jotformpro.com/form/42616780544963

     

     

  • Mike_T Jotform Support
    Replied on September 19, 2014 at 6:09 PM

    Your new form with the calculated Total looks great. I think that this approach will work well as long as you do not need the product names to be forwarded to your payment processing.

    Also, one of our developers is working on some kind of the products splitting option, so it will be implemented at some point.

    Thank you.