generate an error if a field value is not identical to another - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

generate an error if a field value is not identical to another

Last post 11-04-2020 10:40 AM by lionheart2308. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 11-03-2020 06:07 AM

    generate an error if a field value is not identical to another

    So basically i have a form in Infopth 2013 where the user input details as follow:

    Bank name 1  = A

    Commission 1 = 300

    Bank Name 2 = B

    Commission 2 = 200

    Bank Name 3 - C

    Commission500 3 = 150

    Total Value = 650 (the user must type this value )

    Total Amount =  (auto populated based on a formula)

     

    requirement : if the user type for example the amount of 500 in the field (Total value), the field Total Value & Total Amount are not identical, so the form should display error (Value not identical) .

    in other words, the two fields value must be the same (Total Value and Total Amount).

     attach screen shot

     

     


  • 11-03-2020 04:21 PM In reply to

    Re: generate an error if a field value is not identical to another

    I'd put a validation rule on Total Value. If Total Value is not blank and Total Value is not = to Total Amount, show a validation error. If you need help, feel free to attach a copy of your form to the options tab in a reply.
    Hilary Stoupa

  • 11-03-2020 10:58 PM In reply to

    Re: generate an error if a field value is not identical to another

     Hi Hilary,

    Thank you for your response.

    Yes please i have attached the form. Appreciate your kind help.

     

    regards

     

  • 11-04-2020 09:08 AM In reply to

    Re: generate an error if a field value is not identical to another

    Right click the linked file and select the option to save the file locally. Right click the locally saved file, and select design to open in InfoPath Designer. The rule is on the field next to the Total Value: label.
    Hilary Stoupa

  • 11-04-2020 10:40 AM In reply to

    Re: generate an error if a field value is not identical to another

     Hilary,

     you are amazing. it works like a jewel. 

    Thank you so much.

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