InfoPath formulas

[Boolean formula]

I have a text box that includes "DAILY" rate and one that says "WEEKLY" rate
and one that says "XDAY". If the "DAILY" rate is blank, I want "WEEKLY" / 3
in the "XDAY" box to come up automatically. Not sure how to create the
formula.

 

[Greg Collins [InfoPath MVP]]

Forumlas don't have any kind of if-then-else functionality... you might have to do this via code.

 

[Greg Collins [InfoPath MVP]]

Forumlas don't have any kind of if-then-else functionality... you might have to do this via code.

 

[Boolean formula]

so using the boolean function wouldn't work, correct?

 

[Greg Collins [InfoPath MVP]]

You can use the boolean function, but you won't be able to use it like an if-statement in an expression.

 

[S.Y.M. Wong-A-Ton]

While you cannot use conditional statements within expressions of formulas,
you could use a rule to set the value of a field and then add a condition on
the rule. This way you can create your own conditional statements using
rules.

Example: You could add 2 rules to set the value of 1 field. On the first
rule you could set a condition so that the rule will only run when your
"DAILY" rate field is blank. On the second rule you could set a condition so
that the rule will only run when your "DAILY" rate field is not blank.

 

[Greg Collins [InfoPath MVP]]

Yes - this is a good alternative if your scenario allows for it.

Let us know what you were able to figure out.