Implement conditional calculations

  • Profile Image
    ParkingRetkinia
    Asked 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 Form Calculation Using a Widget

  • Profile Image
    BDAVID
    Answered 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
    mrotjan
    Answered 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
    TitusN
    Answered 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
    LegalJeff
    Answered 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
    BDAVID
    Answered 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
    LegalJeff
    Answered on April 02, 2014 at 08:30 PM

    Yes, sorry forgot to provide...

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

  • Profile Image
    ashwin_d
    Answered 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
    LegalJeff
    Answered on April 02, 2014 at 11:20 PM

    Ashwin_d,

    That works, thank you...

  • Profile Image
    ashwin_d
    Answered 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
    LegalJeff
    Answered 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
    ashwin_d
    Answered 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
    LegalJeff
    Answered on April 03, 2014 at 07:23 AM

    Aswin_d,

    You rock :-) thank you

    Jotform support rocks!!!

  • Profile Image
    LegalJeff
    Answered 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
    EltonCris
    Answered 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
    jonathan
    Answered 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
    LegalJeff
    Answered on April 05, 2014 at 07:40 PM

    Thanks for your suggestions...

  • Profile Image
    jamesforpm
    Answered 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
    jamesforpm
    Answered 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
    jonathan
    Answered 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!