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.
Auto Generate SUM Base on User Inputs in an Order FormAsked by paulpacey27 on May 26, 2013 at 04:32 AM
Attached is an order form I have created with the skills and tools available to me.
The problem is that it currently requires users to do their own multiplication and addition to complete the form after selecting their desired products ... clearly pretty amaturish these days!
(There are other tweaks I would like to make, but for now, this is the big one.)
If there are any programmers out there who may specialize is customising JotForms, I am happy to pay for your time and services.
Looking forward to your replies, and THANK YOU!
Your form consists of multiple fields for your product items, they can select or add few more orders. We provide workarounds, but I guess I can't help you with this form.
What will be the overall function? Is that "Photo Numbers" x "Products" x "Quantity" equals the "Sub-Total" ? If they had few more orders, output the Grand Total?
Maybe, my colleague will do. Just please let us know the calculation for the product items.
You may also consider using our Purchase Order Fields, it will calculate entries, you can add special pricing options. setup multiple product items without having to Pay after clicking submit button.
Here are some guides that will help you accomplish such:
Many thanks for the feedback Welvin.
I've checked out both guides you have suggested. The one in regards to Adding Options in the Payment Form was super helpful with the last form I created (seen here.)
The main problem is that this Form reaches its limitation as soon as I offer more than one photo in combination with the several products available (as with the new form I've trying to make work.)
To answer your question, yes, "Photo Numbers" x "Products" x "Quantity" equals the "Sub-Total". And yes, the functionality should include a Grand Total.
Also, the calucultions for the product items are listed directly on the form.
Of course, and insight in the right directions is always appreciated.
I've had a look at your form but I know how the entries in the Photos(s) fields are to be factored into the calculations. What exactly does the user enter in those boxes? A number? I understand the other two fields (Product x Quantity = Subtotal). For example, if a user were to select "Mug" and a quantity of "10" the subtotal would be 4000 CZK (10 mugs @ 400 CZK) but how does what the user enter in the Photo(s) field affect the calculation? Is that supposed to be a field where users can upload a photo (or photos) which are be printed on the products?
Perhaps I would understand the calculation if you were to provide an example of the first row.
Thanks for the time Abajan, much appreciated.
To answer your questions:
The users would enter the number of a photo that appears in a gallery they would be sent. (You can see the "front end" here.)
(The JotForm order form appears in a new window when users click "Place order here...)
I understand your confusion regarding how this field effects the calculation. If it confuses you, then I'm sure other might end up in the same boat.
(To explain, however, the thinking was that, say a client wanted all Small Prints. Instead of having to make a new entry for EACH photo, they could indicate several photos at once that would be ordered as a Small Print. In this case, how many photos they might indicate would effect the final calculation.)
If I need to simplify things so that each entry relates only to ONE specific photo at a time, this would be a compromise worth making for me, especially if it eliminates any potential confusion. The main thing is stiill to have a form in which people don't have to do their own math.
I hope I've answered your question properly.
Question: I'm just trying to think of other ways around my current approach.
Is it perhaps possible to negate JotForm's Payment Wizard limitation that there can be only one per form??
The functionality of it, when I offer only one photo, is beautiful, but the trouble in paradise begins when I need to make it work for more than one photo.
If it were possible to duplicate this functionality (based on potentially several photos), it would in fact be better than the form I am trying to piece together as indicated above.
What does anyone think? Is attempting to incorporate multiple Payment Wizards in one JotForm more, or less, doable?
Would be amazing if this were possible.
I think what you need is achievable using the combination of the ff:
1. Add Purchase Order field or the payment field(for options and sum computations)
2. Add collapse field. To provide new sets of product when "Add new photo or product" is Yes.
3. Form's source code. Because you will have to manipulate the html code of the form to re-position the product items.
I am thinking of something similar done to this post (the part where the form's source code is manipulated to move the products within the collapse field)
There should be no additional computation code involved.. you only need to reposition the html codes of items/products within the collapse field so that on initial load, only 1 set of of product should be ssen.
Then using this guide How-to-Hide-or-Show-Multiple-Fields-at-Once-Based-On-a-Single-Conditional-Entry every time the "Add New Photo or product " is selected, the collapse field will open and reveal a new set for items/products.
Our colleague Abajan will also provide you updated response once he's back online. His ideas are always masterful and should be consider always =)
I will also try to create a demo form base on what I described. I'll provide the form when I did it.
I also found this template in the JotForm Gallery.
Maybe this is similar to what can be done to your requirement, with a bit of modification.
Thank you Jonathon! The time difference here in Prague may delay my replies, but I shall certainly take a proper look at all your suggestions when I get home from work later today. Much appreciated.