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

    Purchase orders integration: Will drop all fields into a single cell when connected to google spreadsheet

    Asked by habitatjackson on September 27, 2012 at 02:00 PM

    I want to make an order form

    Items are

    Red

    White

    there is a quantity and price per each (poinsettia) $15

    and a Total

    Can someone tell me how to do this.?
    I know how to do it with Paypal, but not just an 'order' form'

    thanks

    quantity purchase order check order form
  • Profile Image
    JotForm Support

    Answered by Rodjit on September 27, 2012 at 03:04 PM

    Hi,

    Please check this form http://form.jotform.me/form/22706132078449, is this something you would like to achieve? If yes, you can clone this and modify them once done.

    Hope this helps you. Please let us know for any concerns you may have.

    Thanks

  • Profile Image

    Answered by habitatjackson on September 27, 2012 at 03:37 PM

    That is a start... but I have to have a quantity for each color

    any idea on that?

  • Profile Image
    JotForm Support

    Answered by Rodjit on September 27, 2012 at 03:49 PM

    Hi,

    Yes, that's possible. Please check this link on how you can customize Paypal forms.

    Thanks

  • Profile Image

    Answered by habitatjackson on September 27, 2012 at 04:15 PM

    hmm. Can I use a paypal form and NOT use paypal.

    I mean I don't want to use paypal. It is just an order form, the people will send a check

  • Profile Image
    JotForm Support

    Answered by Mike_T on September 27, 2012 at 04:49 PM

    Yes, this is possible with us.

    Just drag and drop a Purchase Order tool to your form.

    Then, you will be asked to configure that tool. From there you will be able to add the products and specify the quantity options.

    How to add quantity in items available for purchase

    If something is not clear, please let us know. We would be happy to help you.

  • Profile Image

    Answered by habitatjackson on September 27, 2012 at 08:03 PM
    Ok that worked pretty good now the only problem I see is the order is dropped into one cell on my google spreadsheet...it seems Paypal does that too (I made something similar with PayPal ) Red Poinsettia (Quantity: 2) White Poinsettia (Quantity: 1) Total: $45.00I need this info in separate cells is this possible?
  • Profile Image
    JotForm Support

    Answered by jonathan on September 27, 2012 at 08:42 PM

    @habitatjackson

    You are correct on your observation of the purchase order field being all dropped into a single cell only when viewed on google spreadsheet. There was actually a ticket already submitted to our dev team regarding this and currently being look upon.

     

    As a suggestion and temporary workaround-- since you do not really need a 'payment' info/data, can you instead just use individual regular fields?

    A checkbox, a dropdown box fields can also be used display your product. The part that will be missing though will be the computed 'Total'. But you can see/calculate your total via google doc formula.

    I will include your post on the submitted ticket post so that you will be inform of its progress too.

    Thank you for using our services. Please inform us should you require further assistance.

    Thanks.

  • Profile Image

    Answered by guest_30152366988058 on January 23, 2013 at 08:04 PM

    i see this issue with one cell still exists - is this soon to be handled in the near future?

    i wonder how would it be possible to map these fields in the form to salesforce as they are all named "my products" and "quantity", ie they dont have unique names.

  • Profile Image

    Answered by jeanettebmz on January 23, 2013 at 09:12 PM

    I am opening a new ticket in order to set a higher priority to this request.

    On regards to Salesforce, please open a new thread for it as this is only related to google spreadsheet integration and payment forms

  • Profile Image

    Answered by jeanettebmz on May 24, 2013 at 11:29 AM

    UPDATE:

    This problem (payment field separation on Excel) has already been resolved a month or two ago.

    Cheers!

  • Profile Image

    Answered by TututheMoon on August 17, 2014 at 02:39 AM

    well, um, no it hasn't been resolved as

    I'm using purchase order tool and its still doing one cell for all the item :(
  • Profile Image

    Answered by jotitz on August 13, 2015 at 10:13 PM

    any further solutions?  I can't even get a pivot table, or text to columns to sort the data
    :(