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 to separate the product info into different column

    Asked by rmevangelista on November 11, 2015 at 08:47 AM
    purchase order tool excel report separate fields separate columns
  • Profile Image

    Answered by Sammy on November 11, 2015 at 10:42 AM

    Could you kindly provide more information regarding separating the products into different columns.

    If you are referring about the separation under the submissions I'm afraid we currently do not have this provision available ate the moment.

    Kindly confirm if this is what you were referring to, I could then forward a feature request to our development team so that they may consider it for inclusion in the future.

  • Profile Image

    Answered by rmevangelista on November 29, 2015 at 07:02 AM

    I want to separate the data in my excel report like column #1 for the product  X, column #2 for the size selected, another column #3 for product Y selected,  column #4 product size selected and so on. The last column will be the total price.   

  • Profile Image
    JotForm Support

    Answered by Mike_G on November 29, 2015 at 12:14 PM

    Thank you for the additional information. I have checked one of the forms in your account that you might be referring to. http://www.jotform.me/form/53123380272447

    I can see that you've used the Purchase Order tool from the Payment Tools. I understand that it is the best way to create your order form since it has the subtotal for each item, quantity are automatically computed as well as the total amount and images, size, quantity checkboxes are properly placed to look good on the form. However, if you want to separate the fields for each product selected, its quantity, and its size on your excel report, I would like to suggest you try to recreate the whole order field into separate fields using the regular form tools(drop-down fields, checkboxes and textboxes). Computations can be done through conditions and style of the form can be done with the help of injected custom CSS codes to your form. You might also want to consider doing this manually instead with the help fo these guides I found over the internet: 

    https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    http://datapigtechnologies.com/blog/index.php/split-data-into-several-columns-based-on-carriage-returns/

    Let us know if you need any further assistance. Thank you.

  • Profile Image

    Answered by rmevangelista on November 29, 2015 at 11:49 PM

    Thanks Mike_G for answering. 

    I'm trying to recreate my form using a regular form tools but I'm stuck with the formatting of styles and the conditional formatting to create a sub total output. Will you help me injected the CSS codes and conditional formatting so its looks like the Purchase Order form.

     

    And I also want to limit to one order per employee number, is that possible?

  • Profile Image
    JotForm Support

    Answered by Charlie on November 30, 2015 at 08:36 AM

    It's possible by following the guides below.

    1. First, you will need to recreate the products using the plain form fields.

    2. You can then position those fields, let's say you want to put the quantity dropdown and the sizes dropdown on the same line, you can do that by following this guide: http://www.jotform.com/help/328-How-to-Position-Fields-in-JotForm.

    3. After that, you can assign calculation values on your drop down fields (quantity and sizes) that will be used in calculating your total. Here's a guide to follow: http://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

    4. The next step would be to used the Form Calculation widget to get the total of the orders. To learn more o how to use the form calculation widget, here's a link that you can visit: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form 

    5. Now the question is, how to pass the calculated total to your payment integration? That's possible by using the custom donation/total option in your payment wizard. Here's a guide on how to do that: http://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field.

     

    I hope that gives you an idea on how to proceed. If you need more help on this, please do let us know.

  • Profile Image

    Answered by rmevangelista on December 13, 2015 at 07:34 AM

    Thanks Charlie.

    How can I make the "item subtotal" set to zero when I unchecked the selected product same also to size and quantity make it deselect automatically.

     

    I want to limit to one id number to one order only, is that possible?

     

  • Profile Image
    JotForm Support

    Answered by Welvin on December 13, 2015 at 10:50 AM

    That is the behavior of the subtotal when the item is unchecked, it should set to zero. However, the other options won't restore to its default but that is not a problem since the product is unchecked and therefore, no data will be submitted.

    As for the ID number limit, I will answer it through this new thread: http://www.jotform.com/answers/724198

     

  • Profile Image

    Answered by rmevangelista on December 14, 2015 at 03:52 AM

    Thank you Welvin.

    Is this possible, when I select a size on a drop down option it will automatically checked the item (radio button) without selecting it?

       
  • Profile Image
    JotForm Support

    Answered by Mike on December 14, 2015 at 09:52 AM

    @rmevangelista,

    We will answer your question via the next thread.

    http://www.jotform.com/answers/724643

    We will get back to you quickly.