General

Re: repeating table help

qwerty — Mon, 04 Apr 2011 19:14:40 GMT

Hi there. This is possible using rules:

Add a new column to your table 'watcher', and add a rule to it:

If <checkbox> is equal to true then

Set a field's value: textbox = valuetoupdatetp

Then set this off by adding a button outside the repeating table to Set a field's value: watcher = watcher.

Hope this helps,

Qwerty

Re: repeating table help

Patrick Halstead — Thu, 31 Mar 2011 05:12:04 GMT

Sounds like what you want to do is bulk edit of the last column for one or more rows (if they're checked). Is that correct?

If so, you might be able to use a nested eval(eval(...)) and xpath to iterate through the list and set them but it's possible you can't easily do this with out-of-the-box InfoPath.

We created qRules to address common functions that people need that require code. After injecting qRules into your form, you can just use rules to do this kind of iteration. I believe Jo-Anne Alfafara has a nice blog on the Insert command and how to copy items from a SharePoint list into your form. The same technique could work for you. Get the count of the rows in your list (use xpath count() function) and set that into a field (you can add a field to your main data source *or* a secondary data source which has the added benefitted of keeping your main data source pristine). As you iterate through the rows you have a condition that sets the value if the checkbox is true. Rule based iteration is a little tricky but it can be done. The other qRules command that might be easier is "SetValue"; this was developed for exactly the purpose you intended. To set all values that match a filter. I should have recommended that first. That's a piece of cake. Install qRules free trial and look at the user guide.

Note: qRules does not work with InfoPath 2003.

repeating table help

chris317 — Wed, 30 Mar 2011 16:12:16 GMT

Good morning,

I am relatively new to Infopath and I'm having a problem with a repeating table. I'm currently using Infopath 2003.

I created a repeating table that has four columns. The data in the textbox of the last column I would like to have updated if the user chooses to update it using a single non repeating text box containing data that is manually. Ideally the user would use a check off box to select the rows they want to update then the information from the non repeating box will carry over to adjacent text box of the checked off rows.

I'm not sure how to do with programatically and I tried to use the rules but it only works for the first record.

Any suggestions would be helpful.