What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Selected product items in spreadsheet are all in one cell

    Asked by habitatjackson on September 19, 2014 at 05: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.
  • Profile Image
    JotForm Support

    Answered by KadeJM on September 19, 2014 at 05: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.

  • Profile Image

    Answered by habitatjackson on September 19, 2014 at 05: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

     

     

  • Profile Image
    JotForm Support

    Answered by Mike_T on September 19, 2014 at 06: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.