-
Have the table node path go all the way to my:Engagements_in_Group instead of stopping at my:Group_Engagements_in_Group, and use just a dot as the node path for the EngagementCode column. If DAT won't let you select these from the taskpane, you can enter them manually.
You should probably also append [. != ''] at the end of the ...
-
Yes this should definitely work. Have you tried it yet?
-
You can use a formula like (ThisYearSalary - LastYearSalary) div LastYearSalary as the default value formula for the Percentage field. You can use the Insert Field... button to help you with selecting the right fields.
-
You need to use a relative XPath in your SelectSingleNode() statement: "@DVRType"
-
The "infinite loop" restriction only applies when a rule directly or indirectly causes itself to be reinvoked 16 times. Since each my:copy node rule executes only once in its own chain of events, this approach is not vulnerable to that limitation.
And thank you for always providing such positive comments! :-)
-
Neither the CopyTable command nor the Replace command is designed to work with multiple targets. There is a way around that which I will get to in a second.
I am puzzled that you are getting that error. The behavior I would think you'd find is that the data would get copied to the first my:person with index > 1 ...
-
The problem with your first approach is that the current() function is only available within InfoPath designer features (rules, condt'l formatting, etc.) and not in code-based features.
To get around this, you can use a concat() statement to fold the value you want into the command:
concat('Insert ...
-
The problem is that you have two different modhours fields in your data source (modhours and ModHours), and your sum() function is referring to the one that's not actually being used in the form.
-
Might you be willing to attach your form to this forum thread? This should work pretty easily, so it's hard to guess what's wrong without a very detailed description of your form's setup.
-
Do you have the "Recalculate this formula when the value changes" box unchecked in tothours' properties?