General

Re: problem using multiple rules to set a fields value.

seanbjack — Thu, 23 May 2013 13:38:05 GMT

Many thanks - that works!

I had initially set them up that way however i didn't appreciate that the conditions needed to be repeated under each control and my logic was a bit out. I've got it working now

Thanks again for your help

Re: problem using multiple rules to set a fields value.

ErnestoM — Thu, 23 May 2013 13:05:36 GMT

Since you want to set the value of field1, you cannot have the rules on this same field. The rules will never fire.

When the values of /dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:_x0079_r1 /dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:_x0079_r2 and /dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:_x0079_r3 change, then you can have rules fire, and based on the various conditions, you can have an action that set's the value of field.

So, in summary, your rules need to be on the BenefitsRealized1, 2 and 3 fields instead.

Hope this helps!

Re: problem using multiple rules to set a fields value.

seanbjack — Thu, 23 May 2013 07:55:23 GMT

Hi-

I have attached the form. The rules are attached to "field1"

Thanks for your help

Re: problem using multiple rules to set a fields value.

ErnestoM — Wed, 22 May 2013 18:56:28 GMT

Hi-

Would you be able to attach your form (via the Options tab when responding)?

This sounds pretty straightforward, so there may be an error in your form logic. Taking a look at the form in design mode is the easiest way to figure that out.

Thanks!

problem using multiple rules to set a fields value.

seanbjack — Wed, 22 May 2013 16:08:28 GMT

I'm having trouble with a set of rules I have setup in infopath 2010 form for a sharepoint list (list is in sharepoint 2010)

I have a field (targetfield) that I want to set the value to either 1, 2 or 3 based on a number of combinations of values in other fields

I have 3 boolean fields (year1, year2 and year3) that check when a running total becomes greater than zero over time. These fields are defaulted to false initially using a form load rule if no data has been entered in the form. If the running total becomes great than zero in the second year then "year2" and "year3" fields return a value of true and "year1" remains false etc. I now want to run a calculation that populates "targetfield" based on the year that total becomes true (calculation will differ depending on which year it first becomes true).

I have setup 3 rules on "targetfield"

rule1: if yr1 = true then set value of targetfield to 1, rule2: if yr2=true AND yr1=false then set value of targetfield to 2, rule3: if yr3=true AND yr2=false then set value of targetfield to 3

for some reason this will not set the value based on these conditions. I have replicated these exact same rule conditions to change the formatting of the field and these work as expected and without issue.

Any ideas on what I may be missing?

Thanks, Sean