- jpmirzaAsked on March 08, 2014 at 09:16 PM
I want to know how to incorporate simple logic in a field. For example, the variable A can have numeric values ranging from $ 0 - $ 70,000. Variable B can only have 3 output: PASS, FAIL and POSSIBLE
If A < $34,000, then B = FAIL
If A > $50,000, then B = PASS
ELSE B = POSSIBLE
Can you please advise me how I can acheive the outputs for B based on numeric values in A??
- JotForm SupportEltonCrisAnswered on March 09, 2014 at 01:46 AM
That's possible. First, you have to use Number Tool instead of standard Textboxes and create all 3 text results e.g. Pass, Fail and Possible. Check this visual guide:
Create the conditions afterwards. Number Tool has less than & greater than options when you create condition on the Conditions Wizard. See this image:
Hope this helps!
- jpmirzaAnswered on March 09, 2014 at 07:23 PM
Thanks of the ideas. They were very helpful. Now, I am 1 step away from completing the form.
Form Link: http://form.jotform.us/form/40665732866161
I am using a "Form calculation" widget to calculate the output for field "Projected NP". The problem is that "Form Calculation" is NOT providing Greater than OR Less than option.
The number option you mentioed above does NOT allow me to put a forumula.
I am basing the output in Projected NP for conditions such as "PASS", "FAIL" or "POSSIBLE"
Please advise how to handle this problem.
- JotForm Supportashwin_dAnswered on March 10, 2014 at 01:56 AM
I'm sorry for the trouble caused to you.
Unfortunately, our "Form Calculation" widget is does not have the "Greater than or Less than" options. They are currently available in only number fields.
"Form Calculation" widget is a fairly new widget and a lot of feature is yet to be released. This widget is also a numeric field and should have the "Greater than or Less than" options in conditions. I am sending a feature request to our back end team. We will get back to us if we have any update form them.
- depotlawncareAnswered on July 01, 2015 at 11:29 PM
Man, it is really frustrating how many times I have searched and found the exact answer to a question I have to then click on the see example "here" link to just be redirected to a blank page where the users has deleted the form. Why publish support articles if the actual support is not left intact? Why not create a back up of the from for all to use in the future? Drives me freakin crazy. This is maybe the 5th time that happens tonight.
- JotForm SupportEltonCrisAnswered on July 02, 2015 at 01:01 AM
Our apologies @depotlawncare. For everyone on this thread, here's a working demo and a screenshot.
- CommunicaidAnswered on March 14, 2016 at 06:43 AM
Thank you for your solutions above. I use it in my form but not everythink works:
The objectif of my form is evaluate the language level and select those who has a too low level, good level and too high level.
and there are few conditions :
1. Choose 1 of the 4 texts
2. Ticks your competences (Number of the ticks counts already of the result)
3. Matrix questions ( the number of "oui" anwsers counts for the final result)
Firstly I have puted form calculation linked to each question (done and working)
Than, in GOOD LEVEL I want to put the result for the people who has a good level (I have used greater than / less than) and it worked.
and I have tried to do the same for NOT GOOD LEVEL and it doesnt work! do you have any ideas why?
Thank you in advance foryour help
- JotForm SupportNik_CAnswered on March 14, 2016 at 08:33 AM
Since this is an old thread I moved your question to new one, here is the link.
Please open new threads for your questions so we are able to handle all problems accordingly.