InfoPath 2010

Re: Set Target field of repeating table dynamically (Codeless)

Patrick Halstead — Tue, 30 Jul 2013 07:19:38 GMT

Jimmy's got a technique that doesn't use qRules but it's quite complex. He should have time in a day or so to respond with the added detail.

Re: Set Target field of repeating table dynamically (Codeless)

lockettc — Mon, 29 Jul 2013 14:11:14 GMT

Our environment is very secured. We are unable to install anything on our machines, and have no access to Central Administration. Even if we add a new solution to the solution gallery, it may not be able to be activated. Additionally, if we put code in the forms, they will require Farm Admin approval, which won't happen. So, I am basically an end user with only SCA rights in the site. This is indeed a browser form, so my options are limited there too. About the most I can do is edit the manifest in forms, or use jquery on sites. IT frowns on jquery as they won't support it.

Re: Set Target field of repeating table dynamically (Codeless)

Jimmy — Mon, 29 Jul 2013 03:10:22 GMT

It would seem that you can't use xdXDocument:get-DOM() in the targetField portion of rule definitions. What you are trying to do can be accomplished very easily with a qRules command. Something like this:

concat("SetValue /dsname=SecDataSrc XML file1 /xpath=/Batch/Method[@ID = '", SB4, "']/Field[@Name = 'myfield'] /value=", Method[@ID = SB4]/Field[@Name = 'myField'], ' hi', SB4)

You mentioned that you can't use code. Is that because of a security limitation, or a maintainability limitation?

Re: Set Target field of repeating table dynamically (Codeless)

Patrick Halstead — Sun, 28 Jul 2013 06:03:20 GMT

Hi Lockettc and welcome!

You could do this quite easily with qRules SetValue command and that does work in the browser, but it requires the sandbox.

I've sent your query to one of our MVPs (Jimmy) to see if he can give you the right incantation.

It should be doable via the manifest.xsf, but that probably won't work for browser forms. qRules SetValue will. Might be worth a look.

More soon,

Set Target field of repeating table dynamically (Codeless)

lockettc — Wed, 24 Jul 2013 16:52:29 GMT

Hey everyone.. Many of these posts have been very helpful to me, but now I am faced with a new issue that I can't figure out. I have a nested repeating table representing a secondary data source that looks like this:

"SecDataSrc XML file1"

Batch

Method (Repeating)

@ID
Field (Repeating)

@Name

In my main data source, I have a couple of fields to store data for calculations.

TaskFields

text1
SB4

What I want to do is set the Field with @Name= "myfield" and @ID = sb4 to some text string value. seems simple right? When modifying the manifest.xsf to place a filter on the targetField, this is what I get:

Putting a constant in for the @ID value (say '26') works:

<xsf:assignmentAction targetField="xdXDocument:GetDOM("SecDataSrc XML file1")/Batch/Method/Field[../@ID = '26' and @Name = "myfield"]" expression="concat(xdXDocument:GetDOM("SecDataSrc XML file1")/Batch/Method/Field[../@ID = '26' and @Name = "myfield"],' hi',xdXDocument:get-DOM()/my:myFields/my:TaskFields/my:SB4)"></xsf:assignmentAction>

What I need is for '26' to be a variable referencing SB4: So I copy the reference in the expression and paste it over the '26'. This does not work:

<xsf:assignmentAction targetField="xdXDocument:GetDOM("SecDataSrc XML file1")/Batch/Method/Field[../@ID = xdXDocument:get-DOM()/my:myFields/my:TaskFields/my:SB4 and @Name = "myfield"]" expression="concat(xdXDocument:GetDOM("SecDataSrc XML file1")/Batch/Method/Field[../@ID = '26' and @Name = "myfield"],' hi',xdXDocument:get-DOM()/my:myFields/my:TaskFields/my:SB4)"></xsf:assignmentAction>

The error I get is is Unknown Method: "/Batch/Method/Field[../@ID = ---> xdXDocument:get-DOM <--- ()/my:myFields/my:TaskFields/my:SB4"

Any ideas? I have tried //my:SB4, ../my:SB4 but none of them work. My rule that calls the action above is on the text1 field in the main data source. (It is used to calculate SB4).

My other option is to use rules to set the fields. (No code). For each method in the data source, I want to set Field with @Name = "StartDate" to the value of that same Method's Field with @Name = "SOffset". Both are strings. Any Ideas on how to do this? Either will work for me.