-
sisters7Asked on December 10, 2016 at 1: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.
-
Kevin Support Team LeadReplied on December 10, 2016 at 8: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.