InfoPath Dev

i want to set a calculated value for a field based on the values of two other controls... so i need a series of if/then statements, but it appears that i can set the value of that field only based on one control... is this true? from what i see, the rule applies only if the value of the one control changes... is there a way around this w/o coding??? or my question doesn't even make sense? :-(

thanks,

shadi

Hi Shadi,

Welcome to our site. What you want to do is set a "Default" value using A formula on the target field. For example if you have:

quantity, amount, total fields

Double-click the total field, then set the "default value" using the formula dialog as the quanitity field * the amount field.

If the values you want to use are text rather than numbers, you would use a formula like: concat(field1, " ", field2, " ", field3) etc...

thank u so much for ur responses... here's an example of what i'm trying to do:

if field1 is equal to 'Y' and field2 is equal to 'cashback' then the calculated value for field3, 4, 5, 6, 7 will be (fieldx / fieldy) * 100

if field1 is not equal to 'Y' and field2 is 'whatever' then the calculated value will be something else for the rest of the fields

i'm trying to set the rule at field 1 for all this... doesn't look like it can work... i tried setting the rule at each of the fields 3, 4, 5, etc, but that did not work either...

thanx again for any responses...

Since your two trigger fields are field1 and field2, you need a duplicate set of rules on both of those fields. A better way would be to write one code function which does all this, and then use the OnAfterChange event on field1 and field2 to call that function.

But if you are determined to do this via rules, you still can. Its just more work. You will need to make a duplicate ruleset for field1 and field2. That ruleset would have two rules. Each rule would have a condition (as you described above). If the condition succeeds, then the rule actions are applied. Make sure to select the check box at the bottom of the rule actions to stop running the ruleset after the actions have been applied.