Validation on currency fields - InfoPath Dev
in

InfoPath Dev

Validation on currency fields

Last post 07-23-2019 08:45 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-22-2019 02:57 PM

    Validation on currency fields

    Hi I have a 2013 InfoPath form. I am trying to add a validation rule on one of the currency field but it is not triggering nor throwing an error. Here is my full scenario , I have four fields (Admrequest, invoiceamount, lastamount) all the three fields are text fields with datatype currency and selected Currency symbol and selected the check box use a digit grouping symbol. The other field is the sum of these three values which is "TotalRequest". Here on this field am trying to set the validation rule, As of now I tried "if TotalRequest is greater than or equal to 100000" throw error message in the snippet. but some how it is not working that way. The TotalRequest field is also set to similar to other three fields. Can someone please help me out in fixing this.Thank you in adavance
  • 07-23-2019 08:45 AM In reply to

    Re: Validation on currency fields

    Put the TotalRequest field on the form, but don't format it, so you can see the actual value. Is it greater than or equal to 100000? Usually, I find that I have issues like this when the value of something isn't what I think it is....
    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.