How to separate the product info into different column

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.

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.   

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.

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?

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.

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.

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. 

@rmevangelista,

We will answer your question via the next thread.

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

We will get back to you quickly.