JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Can I have multiple unit costs on one field dependent on quantity of product selcted?Asked by mjgroup on November 26, 2014 at 05:08 AM
I was wondering if the following were possible?
My user is looking to have a book made and have a choice between a paperback and hardback book. For example purposes I'll use only two options to select.
- They select hardback book The total cost of this field will be dependent on how many hardback books they choose
They select 5 books
Quantity Hardback Books (I don't want these options visible though.. this makes up the total calculation at the end)
1 - 10 (unit cost is 50 per book) They fall into this band
10 - 20 (unit cost is 40 per book)
30 - 40 (unit cost is 30 per book)
40 - 50 (unit cost is 20 per book)
So hardback field is = 50
They then select size A4 number of pages 700
1 - 500 (unit cost for page count 0.5 )
501 - 2000 (unit cost for page count 0.4 ) They fall into this band
2001 - 5000 (unit cost for page count 0.3)
5001 - 10000 (unit cost for page count 0.2)
So the calculation of this field is equal to number of pages (700) x Quantity of books (5) x unit cost (0.4) = 1400
When they press calculate at the end of the form the total would be equal to
HardbackBook Field (50) + Page Count Field (1400) = 1450
Yes you can achieve this by using the "update form field" condition and adding your calculation to be added to a hidden field that would later be added together to show the total in your calculation field.
I did the conditions for the Hardcover and A4 options and the calculation provided.
Please see a sample form here: http://www.jotformpro.com/form/43293256972968
The fields are not hidden so you can see how they would work. If this what you are looking for, you can clone the form and make your desired changes.
I hope this is what you are looking for, please inform us if you need further assistance.