Add a "no greater than" in my conditional logic

  • Profile Image
    sisters7
    Asked on December 10, 2016 at 01:36 PM

    How do I set up a "no greater than $159.00" in my logic.

    I have already done: If Entitled III is filled, insert Thurs.+...+.. into Amount Paid by MSC$. However I want to put $159.00 as the maximum amount. How do I set up this limit?

    Thanks.

  • Profile Image
    Kevin_G
    Answered on December 10, 2016 at 08:42 PM

    With conditions you could set the condition that the field should not be greater than 150 so if the amount is 160 you could display a message on your form so the user knows that something needs to be changed, but this will not prevent the form to be submitted. 

    What I will suggest you is to use another field, I can see you're using a text box field in "Amount paid by MSC $" you could use a number field for example, which will allow you to set the limit you're looking for: 

    Then you will only update the conditions and insert the calculated amount into the number field so if the 159 value is passed a message will be displayed and will also prevent the form to be submitted: 

    But this cannot be conditionally triggered, it will be applied to each value entered in the field. 

    If this needs to be conditionally, only when "Entitled III" is filled then a text field will need to be added to the field where you will display that the number cannot be greater than 159: 

    And the condition that will make this work should look like this: 

    So only when the amount is greater than 159 the message will be shown indicating that the number should be less or equal than 159. 

    Please give it a try and let us know if you have any question, we will be glad to help.