- drverdeAsked on May 22, 2011 at 03:30 PM
I am trying to create a simple order form, but we have more than 100 products. I need the user to be able to select what item(s) he wants to order, and the quantity for each one. I see that this is almost done with the default Purchase Order tool, but the quantity is a dropdown list. And this is a problem for me, because someone could order up to 1000 products, and you can see that a dropdown list with 1000 elements is not usable. I was thinking of creating a check list and it would have been cool if the quantity would apear as a text box next to it if a product is checked. I dont know, is this possible?
The easyest way I suppose is to create a text box for every product and the quantity to pe the input field. But then, when I recieve the email, I would have to look through 100 items and see which of them were selected and in what quantity. If I use the check list, maybe only the checked items will appear. But I could be very well mistaken.
Anyway, your service is the greatest and that is why I think that using a JotForm for this job would be great. We will most likely purchase the 1000/month option, but I need to know if there is a way to get around my "little" problem.
I hope I was clear enough about what I require, but will gladly add more specifications if needed. Please help!
Thank you very much!
- JotForm SupportabajanAnswered on May 22, 2011 at 05:31 PM
When you stated that a dropdown list with 1000 elements is "not usable", were you referring to the impracticality of typing the numbers 1 to 1000 and hitting the return (Enter) key after each entry? If so, the tool at http://textmechanic.com/Generate-List-of-Numbers.html can do that job for for you. As a matter of fact, you could easily generate a sequential list of 100,000 numbers with that tool. However, your idea of each product having a check box that would reveal a text box if checked, where a user can then enter an amount, is a good one but to my knowledge, not presently possible. A variation of that might be to have the dropdowns only appear when items are selected but here again, I don't believe that's currently possible.
Regarding your other concern, only items selected by the user (and the total, if the option to display that on the form was chosen when configuring the purchase order field) would be displayed in the email (and on the submissions page of the form). I have created a form containing just a few products that you can clone (see http://yang.interlogy.com:82/help/28-How-to-Clone-a-Form-from-a-Web-Page ) and test for yourself to see how submissions are displayed. The form's URL is http://yang.interlogy.com:82/form/11411240826
Hopefully this helps clarify things but if it doesn't please feel free to ask for more information. As always, our team would be glad to assist you.
- drverdeAnswered on May 24, 2011 at 02:37 PM
Thank you very much Wayne!
Sorry for the delay but I've been away.
I think your advice is just what I need. I was thinking that a dropdown with 1000 elements will popup with most of the elements out of screen. But thats not the case, as you well know, and I didnt.
I think that I'll be able to have a form meeting in full my requierments. I will try to make the complete form and then Ill make it live. Im sure that pretty soon Ill have to get a subscrition for 1000 forms a month.
Thanks again! As usual, great service, and quick too
- drverdeAnswered on May 24, 2011 at 02:40 PM
Oh, one more thing.
Isnt there a way to have a custom currency? I mean I just want the word "lei" to appear after the price. Eventually the form for the plural to be able to be different from the one in singular. Is there any way to do this?
Ive seen that there are a few to choose from, but the one I need isnt in the list. I was thinking of just typing in the currency I need could be a good solution for me, and Im sure for others as well.
- JotForm SupportabajanAnswered on May 24, 2011 at 02:41 PM
You're quite welcome, drverde. We're always happy to help our users and to know that the advice given proved worthwhile.
P.S. Sorry, I didn't see your second query until I had posted my acknowledgement of your gratitude. I'll have to check and see if such customization is possible. In the meantime, perhaps one of my colleagues knows about this and may well provide an answer before I get back to you.
- drverdeAnswered on May 25, 2011 at 08:26 AM
I was going to try the "Purchase Order" tool, but that has some inconveniences that makes it unusable for me. Perhaps I should firstly try to explain what Im trying to accomplish with this form, and maybe after that you can tell me if JotForm is the right solution for this, or perhaps I need a more complicated tool.
So, we have about 10 companies and from each one we have 30-50 products. Being that there are many many products, I wanted to use a Form Collapse for every company. So, the user knows he wants a product form company A and 2 products from company D, he doesn't have to scroll through all the products. He un-collapses company A, chooses the product, then goes straight to company D, and marks the products he wants over there.
Here is where I found the first problem with the Purchase Order tool. I can only have one in a form, but I need about 10, for each company I have, because the Form Collapse tool cant separate products in one Purchase Order tool.
For my products I dont want to display the price, we just need the name of the product, the check box if one desires to select that product, and the quantity dropdown or text box (preferably a text box). Our clients will have different prices, depending on what we negociated with each one. The Purchase Order tool requires a price though.
In a nutshell that is what I am trying to create. Do you think that JotForm has a solution for this?
Thank you very much! I really appreciate all the help!
- JotForm SupportNeilVicenteAnswered on May 26, 2011 at 04:12 PM
I believe that this cannot be made possible under Jotform. The Form Builder does not allow more than one payment field in forms. A workaround I suggest is to consolidate all the products in one payment field, although form collapses or any other field types cannot be inserted inside a payment field. Also, a single payment field can only accept one payee. I figured that might be a problem if you want to have the total payment divided across the corresponding sellers.
Another workaround I could see fit is to create a separate form for each merchant. You can then have those forms linked in a single page or form.
Unfortunately, that is all I can think of that might work for you, given Jotform's limitations. Let me know if you require further assistance. Thank you.
- drverdeAnswered on May 31, 2011 at 01:18 PM
Thank you Neil!
I understand. But I think I have found a good solution with the Matrix Tool. I use it to list all the products, and use the text box option for the quantity. I use one Matrix Tool for every product category. This solution is almost perfect for what I need. I wish there was the posibility to add more predefined columns (to add the a little description in a new column to the left of each product). Could that option be possible in future updates of this great service? That would really be a huge door opener for new posibilities, in my opinion.
I am so happy that I can use JotForm for this project of mine. Thanks again and keep up the good work!
- JotForm SupportNeilVicenteAnswered on June 01, 2011 at 02:14 PM
It's good to hear that you have found an alternate solution using the Matrix tool. However, what you're asking for, adding an extra column to the left of the rows label, is not possible. I have forwarded your request though to our user requests list.
We will have you updated on the status of this request once our developers have been notified. Please note that we cannot guarantee a lead time for completion or if the request will be approved or not. Thank you for supporting Jotform.