Can I have multiple unit costs on one field dependent on quantity of product selcted?

  • Profile Image
    mjgroup
    Asked on November 26, 2014 at 05:08 AM

    Hi,

     

    I was wondering if the following were possible?

    The Scenario:

    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

    Page Count

     

     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

     

     

     

     

     

     

  • Profile Image
    Shadae
    Answered on November 26, 2014 at 09:57 AM

    Hi mjgroup,

    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.