New to Infopath formulae - InfoPath Dev
in

InfoPath Dev

New to Infopath formulae

Last post 01-10-2012 02:31 AM by Jimmy. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 01-10-2012 12:07 AM

    New to Infopath formulae

    Hi,

     Appreciate that this MAY be answered elsewhere in the forum, but I've spent a good while searching with no joy.

    I have a form where I need to make a calculation based on the content entered into 2 fields, and compare the result to a given constant, ie:

    If Field1 + (12*Field2) < 100, then assign the Value '5' to field3.

    I'm not sure how I can combine a calculation ( If Field1 + (12*field2) ) with the comparison (< 100) and then apply a constant to the 3rd field.

    Hope this makes sense, and that someone can help!

    Thanks in advance

  • 01-10-2012 02:31 AM In reply to

    Re: New to Infopath formulae

    Simply create a rule on field1 with the condition:

       The expression -    /my:myFields/my:parentGroup/my:Field1 + (12 * /my:myFields/my:otherParentGroup/my:Field2) < 100

    (naturally, the bold parts would need to be modified to match the actual path of those fields in your form)

       Action:  Set  [select field3 using the dialog]  to the value: 5

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.