How to give a value to a field based on the value of another field - InfoPath Dev
in

InfoPath Dev

How to give a value to a field based on the value of another field

Last post 03-31-2009 07:56 AM by PaulF. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 03-31-2009 06:36 AM

    • PaulF
    • Not Ranked
    • Joined on 03-30-2009
    • Posts 2

    How to give a value to a field based on the value of another field

    Reply Contact

    Hi,

    This has probably been asked before, but I could not find anything related to this question in the forums. Any assistance is greatly appreciated.

    This is my dilemma:

    If the value in field A is greater than or equal to five, field B should equal 1. If field A is not greater than or equal to 5, field B should equal 0. Field B will be read only.

    Thanks in advance for your assistance.

     Paul

     

  • 03-31-2009 07:32 AM In reply to

    Re: How to give a value to a field based on the value of another field

    Mark as Answer
    Reply Contact

    Open up fieldB's properties, click the fx icon to set its default value, and enter the following formula

    number(fieldA >= 5)

    using the Insert Field or Group... button to insert fieldA in the right spot in the formula, and you're all set.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software

  • 03-31-2009 07:56 AM In reply to

    • PaulF
    • Not Ranked
    • Joined on 03-30-2009
    • Posts 2

    Re: How to give a value to a field based on the value of another field

    Mark as Answer
    Reply Contact

    Thanks Jimmy. This worked great!

     

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