How to add Greater than and Less than condition for Form Calculation widget?

  • Profile Image
    Asked 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


    Can you please advise me how I can acheive the outputs for B based on numeric values in A??


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

  • Profile Image
    Answered 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:

    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.


  • Profile Image
    Answered on March 10, 2014 at 01:56 AM

    Hello jpmirza,

    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.

    Thank you!

  • Profile Image
    Answered 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.  

  • Profile Image
    Answered on July 02, 2015 at 01:01 AM

    Our apologies @depotlawncare. For everyone on this thread, here's a working demo and a screenshot.



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

  • Profile Image
    Answered 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.

    Thank you.