How to separate the product info into different column

  • Profile Image
    rmevangelista
    Asked on November 11, 2015 at 08:47 AM
  • Profile Image
    Sammy
    Answered 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
    rmevangelista
    Answered 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
    Mike_G
    Answered 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
    rmevangelista
    Answered 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
    Charlie
    Answered 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
    rmevangelista
    Answered 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
    Welvin
    Answered 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
    rmevangelista
    Answered 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
    Mike
    Answered 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.