InfoPath Dev

Hi,

 I know this is a very common question. But I couldn't find answers in this forum. I need to change a particular field(say 2nd row, 3 rd column) of a repeating table based on the value selected in dropdowns (which is outside the table). Right now when I insert a new row, the previous row's values are copied. Somebody please help me out with it.

Thanks,

Shyam

Unfortuately, this isn't available with InfoPath's built-in functionality, and we added the SetValue command to qRules to address this very problem.  Please give it a try.

 Thanks Jimmy. Will give it a try.

I just downloaded the Q rules and I injected it to the form. I am not sure now how to use qrules to set the value of a field in repeating table.

The quick start guide should give you a good rundown, but basically, you use a rule to set a command to the Command field in the QdabraRules data source, and it runs that command.  For SetValue, the command format would be:

SetValue /xpath=xpath of the field to modify /value=value to set to the field

You can use a concat formula to dynamically insert values into the command, so to set a field on the third row of a repeating group to the value of a field called address, you could use a formula like this:

concat('SetValue /xpath=/my:myFields/my:group1/my:group2[3]/my:addressField /value=', address)

Likewise, you could concat in another field value to dynamically change which row is modified:

concat('SetValue /xpath=/my:myFields/my:group1/my:group2[', rowToModify, ']/my:addressField /value=' address)