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

    How can I customize the Speadsheet results of the Order Payment Form

    Asked by paulpacey27 on March 22, 2015 at 11:24 AM

    Hi Jotform Support,

    Love the product, love the support so thanks on both counts.

    My problem is in regards to the automatically generated spreadsheet.

    Specifically, I currently have to work around the fact that, when the spreadsheet is generated, all the info that relates to the "shopping cart" is condensed into one cell that does not allow me to use any Excel "sum" functions. ie, total sales, total products ordered, etc.

    Since I must manually redistribute all this info, it not only takes a lot of time, but leaves plenty of room for human error. 

    The question becomes, how can I solve this?

    Thank you for any advice or insight.

     

    Screenshot
    JotForm problem excel JotForm Support
  • Profile Image
    JotForm Support

    Answered by jonathan on March 22, 2015 at 06:40 PM

    If my understanding of your requirement is correct, what you wanted to achieve is to be able to breakdown into separate details the Products data in the Order Form http://www.jotformpro.com/form/50801961635960 when in the Spreadsheet output/result.

    Unfortunately you cannot do this when using the Purchase Order integration because you cannot customize the Purchase Order tool itself.

     

     

     

    BUT what you can instead try to be able have detailed breakdown of items/products in the Spreadsheet result is to create a Custom Order/Payment Form using regular fields like the Checkboxes or Radio button option as the Products/Items in the form.

    Check this user guide: -How-to-pass-a-calculation-to-a-payment-field

    You can also test the demo form http://www.jotformpro.com/form/41413741780956

     

    As you can see on the demo form, the Products/Items (Select Services) were using Radio option fields. And the calculated amount were pass on to the Payment Tool.

    So similar to your form, you  can just breakdown the Photo Packages into multiple Checkbox option and submit them as Order Form. 

    Since each Product/Item will be using separate checkboxes, the output result in the Spreadsheet will be separate column also.

    Hope this help. Let us know if you need further assistance.

    Thanks.

     

     

     

     

     

     

  • Profile Image

    Answered by paulpacey27 on March 22, 2015 at 08:56 PM

    Thank you for your detailed reply. Unfortunately, this solution is unfavorable to me mainly because it excludes the payment options I currently offer, and that the families I serve have come to expect.

    Understanding that I can not customize the Purchase Order tool, are you aware of any wizardry that could be used in Excel, after the spreadsheet has been created, that would achieve the result I am looking for?