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

  • Profile Image
    Asked on September 27, 2012 at 02:00 PM

    I want to make an order form

    Items are



    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'


  • Profile Image
    Answered on September 27, 2012 at 03:04 PM


    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.


  • Profile Image
    Answered 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
    Answered on September 27, 2012 at 03:49 PM


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


  • Profile Image
    Answered 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
    Answered 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 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
    Answered on September 27, 2012 at 08:42 PM


    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.


  • Profile Image
    Answered 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 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 on May 24, 2013 at 11:29 AM


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


  • Profile Image
    Answered 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 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