InfoPath Dev

Morning all,

Queenie:

People have to fill in this form every week and can add as many tasks as they need to along with how many days they plan on spending on those tasks in the next four weeks. In order to make filling in the form easier from week to week I have also included two control buttons [<] and [>] with the idea that if they were to click [<] next week the data would shift across a week leaving the fourth week blank. I have a standard table elsewhere in the form where this works fine, just using rules ("Set a Field's Value").

Hi Queenie,

If I understand the requirement correctly, you essentially want to have the ability to horizontally roll data over a 4 week period? Personally (and being a developer) - I would turn straight to defining this logic in the button click event handlers for [<] amd [>]. In a few of the forms that I have done in the past that have a repeating table (especially those that required the row values to be processed in some way), I have resorted to VSTA and XPath. If you can clarify the requirement and possibly a screenshot of the repeating table and buttons, I might be able to post some code up to assist you.

As far as I can tell (and I could be mistaken on this), Rules only get access to the first row in a Repeating Table. Using code you will be able to iterate through each of them.

 Thanks for the reponse!

 You are correct in your understanding. I need to horizontally roll data, but actually over an 8 week period without the second/third/etc., task data reverting to that of the first task (I simplified a little for the explanation's purposes). I had a nasty feeling I might have to play with VSTA a little. Unfortunately I am working from home at the moment and the company's servers seem to be down so I can't post a screenshot of the exact table at present. I have only just started learning to use VB6 but I might be able to have a go at sorting the button click event handlers.

Can you use XPath within VSTA to define fields?

public void CTRL7_5_Clicked(object sender, ClickedEventArgs e)

    XPathNavigator nav = MainDataSource.CreateNavigator();

    XPathNodeIterator NodeIterator = nav.Select("/my:myFields/my:group1/my:group2", NamespaceManager);

    XPathNavigator node;

    while (NodeIterator.MoveNext())

         node.SelectSingleNode("my:txtWeek2", NamespaceManager).SetValue(node.SelectSingleNode("my:txtWeek3", NamespaceManager).Value);

         node.SelectSingleNode("my:txtWeek4", NamespaceManager).SetValue("0");

public void CTRL8_5_Clicked(object sender, ClickedEventArgs e)

    XPathNavigator nav = MainDataSource.CreateNavigator();

    XPathNodeIterator NodeIterator = nav.Select("/my:myFields/my:group1/my:group2", NamespaceManager);

    XPathNavigator node;

    while (NodeIterator.MoveNext())

         node.SelectSingleNode("my:txtWeek3", NamespaceManager).SetValue(node.SelectSingleNode("my:txtWeek2", NamespaceManager).Value);

         node.SelectSingleNode("my:txtWeek1", NamespaceManager).SetValue("0");

    }

Queenie:

as all the rows' data defaults to that of Row 1 upon the click of the button

Is it the same problem as in yesterday's post  ?

 butsa80 - thanks for the code - I shall try it when the servers are back up and running. It looks fairly straight forward to follow but, like most languages, easier to read than create from scratch. Will let you know how it goes.

Gennady - Having had a look at the other post I don't think it's the same issue, unless I am understanding the other file completely wrong.

 Gennady - I also have Infopath 2007 which doesn't seem to let me drag and drop anything anyway. Trying to follow your answer logically in a separate sheet with the same table still gives the same result - each row reverts to that of row 1.

Drat - I just remembered Infopath won't be able to mix languages - can you do something similar in VB?

Queenie:

2007 which doesn't seem to let me drag and drop anything anyway

It was unrelated to drag'n'dropping (or right-clicking > choosing contextual options) ...
it was about difference (amd probable mismatch in understanding the diff) between data fields and controls...

Anyway, could you just edit multi-item  repeating defaults? In Infopath Designer 2010,  in File > Info > Form Optons > Advanced > Edit Default Values.... ) or, what is the same, on Ribbon Data tav > Default Values (under Form Data)

 I checked that it works in compatibility "Web Browser Form (2007)"

 Fig.1. Editing Repeating Default Values. 

 Fig. 2. Previewing default values

Gennady - as far as I can make out, you are suggesting I change my form so that multiple rows are automatically shown when the form is opened, and that the numbers in the boxes are defaulted?

 I feel I'm being particularly obtuse here :(

Yes.

I was not clear what was your problem and still am not

You probably should have attached your template with the post from the very beginning

 There we go - I fixed up a sample which shows my issue. Hopefully playing with that will show what my problem is.

 Thanks for your patience.

 Ooops, I see

I believe the solution requires using of current() in Rules XPath expressions and it would probably require editing source files, since it is related to bug (impossibility to OOTB edit XPath expression of the target of Rule) and workaround described in:

•  Hilary Stoupa. Manually modify manifest.xsf to Filter the Target of a Rule 
  
  

Not sure yet and, unfortunately, I do not have time now to look into and reply you with concrete (codeless, IMO you should avoid code) solution but I have asked Hilary to look into your question

 Thanks for checking back :)

Oh. This was fun!

Attaching your sample with some edits - I added a "helper" field in the repeating group to leverage for the rule actions.