- ParkingRetkiniaAsked 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
- JotForm SupportBDAVIDAnswered 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.
- mrotjanAnswered 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.
- JotForm SupportTitusNAnswered on March 26, 2014 at 01:15 PM
This has just implemented - go ahead and give it a shot - let us know if you hit any bumps - your feedback is greatly appreciated.
- LegalJeffAnswered 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...
- JotForm SupportBDAVIDAnswered 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.
- LegalJeffAnswered on April 02, 2014 at 08:30 PM
Yes, sorry forgot to provide...
- JotForm Supportashwin_dAnswered on April 02, 2014 at 11:03 PM
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.
- LegalJeffAnswered on April 02, 2014 at 11:20 PM
That works, thank you...
- JotForm Supportashwin_dAnswered on April 02, 2014 at 11:24 PM
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!
- LegalJeffAnswered on April 02, 2014 at 11:45 PM
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...
- JotForm Supportashwin_dAnswered on April 03, 2014 at 03:43 AM
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
- LegalJeffAnswered on April 03, 2014 at 07:23 AM
You rock :-) thank you
Jotform support rocks!!!
- LegalJeffAnswered on April 05, 2014 at 06:42 PM
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....
Thanks again for your help...
- JotForm SupportEltonCrisAnswered on April 05, 2014 at 07:20 PM
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
- JotForm SupportjonathanAnswered on April 05, 2014 at 07:30 PM
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.
- LegalJeffAnswered on April 05, 2014 at 07:40 PM
Thanks for your suggestions...
- jamesforpmAnswered 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?
- JotForm SupportjonathanAnswered on September 02, 2014 at 06:41 PM
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.