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.


  • Profile Image

    Implement conditional calculations

    Asked by ParkingRetkinia on February 09, 2014 at 02:49 PM

    Is it posible to use logical content of calculation like:

    IF DATA1=X THEN DATA2=Y OR IF DATA1=XX THEN DATA2=YY OR...etc

    If the answer is YES how to write it ?



    This is a re-post of a comment on How to Perform Calculation in the Form?

    content logical conditional statemen insert value
  • Profile Image
    JotForm Support

    Answered by BDAVID on February 09, 2014 at 04:14 PM

    Hi, as far as I know that is not possible yet, just basic mathematical operations. I will add this to our feature request, so I hope this is implemeted in the future. 

  • Profile Image

    Answered by mrotjan on March 26, 2014 at 10:46 AM

    This would be a great feature!  I too would love to be able to do this.  Thank you for adding it as a feature request.

  • Profile Image
    JotForm Support

    Answered by TitusN on March 26, 2014 at 01:15 PM

    Hello,

    This has just implemented - go ahead and give it a shot - let us know if you hit any bumps - your feedback is greatly appreciated. 

  • Profile Image

    Answered by LegalJeff on April 02, 2014 at 06:18 PM

    Doesn't work :-(

    Our Community Day event is having a golf ball drop, we wanted all purchases online to have a unique ID, as in if a purchaser bought 5 balls each ball would have a unique number that would go onto each ball. Having resolved to not go down that path I do have it setup for each submission having a unique number.

    The problem related to this post has to do with the ball purchase - each ball is $5 up to 5 balls where 5 = $20 & 10 balls would be $40 - I have tried everything and it just does not work. First entry works fine everything after that is blank...

  • Profile Image
    JotForm Support

    Answered by BDAVID on April 02, 2014 at 07:31 PM

    Could you please share with us the URL of the form you are working on? So we can check furthe, we will be glad to assist you.

  • Profile Image

    Answered by LegalJeff on April 02, 2014 at 08:30 PM

    Yes, sorry forgot to provide...

    http://www.jotformpro.com/LegalJeff/GBDrop

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 02, 2014 at 11:03 PM

    Hello LegalJeff,

    Upon checking your form, I did not find that you have added any calculation feature in your form. Have you removed it already?

    Please take a look at the following form and see if this is what you want to achieve:  http://www.jotformpro.com/form/40919098953973?

    Here are the steps I followed to achieve your requirement:

    1. Replaced the "# of Tickets Purchased:" with a number field.

    2. Added two conditions to perform calculation i.e. if it is less than 4 per item price is $5 and if it more than 4 then the price is $4. Please check the screenshot of the conditions:

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image

    Answered by LegalJeff on April 02, 2014 at 11:20 PM

    Ashwin_d,

    That works, thank you...

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 02, 2014 at 11:24 PM

    Hello LegalJeff,

    You are welcome.

    I'm very pleased that I was able to help you.

    Do get back to us if you have any questions.

    Thank you!
  • Profile Image

    Answered by LegalJeff on April 02, 2014 at 11:45 PM

    Ashwin_d,

    Is it asking to much if it were possible to formulate so that only multiples of 5 would be at the lower price, for example:

    6 balls would be for $25 or 7 for $30 but 10 would be $40, 15 for $60 etc...

    Thanks for any assistance...

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 03, 2014 at 03:43 AM

    Hello LegalJeff,

    To achieve your requirement, we need to have access to the modulus function in the form builder which unfortunately is not available currently.

    We can send a feature addition request to our back end team but you need to create a new thread. We cannot create multiple ticket on one thread.

    I have tried to implement a workaround by adding some conditions to achieve your requirement. Please take a look at the following form and see if this works as expected:  http://www.jotformpro.com/form/40919098953973

    Right now I have added the condition only for up to 50 "# of Tickets Purchased:". We can add some more conditions if required. Feel free to clone this form for a closer look. The following guide should help you in form cloning:  http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Thank you!

  • Profile Image

    Answered by LegalJeff on April 03, 2014 at 07:23 AM

    Aswin_d,

    You rock :-) thank you

    Jotform support rocks!!!

  • Profile Image

    Answered by LegalJeff on April 05, 2014 at 06:42 PM

    Aswin_d

    Came up with a simpler solution for the single ticket purchases but now I need to limit entries of numbers from 1 to 4 is there a way to do that? I already use the entry limit but it only gives a warning, I would rather it just not allow the numbers greater then 4 to not enter....

    http://www.jotform.us/LegalJeff/CDGBD

     

    Thanks again for your help...

     

    Jeff

  • Profile Image
    JotForm Support

    Answered by EltonCris on April 05, 2014 at 07:20 PM

    Hi Jeff,

    Number field has maximum limit option which I think you've just setup on the ball purchase number field on your form. Tested it here and it's limiting to 4.

    Thanks
  • Profile Image
    JotForm Support

    Answered by jonathan on April 05, 2014 at 07:30 PM

    @Jeff

    In addition to my colleague, perhaps you can just use also a condition like this

     

    I testd using Ashwin_d's cloned form http://form.jotform.me/form/40947340024448? (you can check also)

    Hope this help also. 

    Thanks.

     

  • Profile Image

    Answered by LegalJeff on April 05, 2014 at 07:40 PM

    Thanks for your suggestions...

  • Profile Image

    Answered by jamesforpm on September 02, 2014 at 03:53 PM

    I can't see the 'Insert Text or Mathematical calculation' option in Conditions. Is it still an option?

     

  • Profile Image

    Answered by jamesforpm on September 02, 2014 at 04:54 PM

    It seems that you now have to use the Update a form field value to create conditional calculations. But how do you perform the Insert function now?

  • Profile Image
    JotForm Support

    Answered by jonathan on September 02, 2014 at 06:41 PM

    @ jamesforpm

    Hi,

    That is correct, you use instead the "Update a form field value" to insert/update value of a field using conditional statement.

     

    the Insert function is still there -- you have to setup the option Output to Field to insert value from a field to another field.

    Check this user guide also https://www.jotform.com/help/286-How-to-Populate-Field-with-a-Value-from-another-Field

     

    Hopet this help. Inform us if you need further assistance.

    Thanks!