-
My sample has both tables bound to the main data source simply to make it easy for someone to preview, etc. The same techniques work regardless of the data source. I'm attaching another sample that uses a secondary (XML) data source - it originally was to demonstrate a different technique, but I made a minor modification to hopefully ...
-
Oh, I see - so you do need to do something like what is in the sample I attached. You have a data connection to the Projects list? Drag the data fields onto the form, so you have a repeating table, then add a formatting rule to hide any rows if the preceding sibling has a matching name. Then you can use calculated values with formulas similar to ...
-
Yes, I meant the calculation would be in InfoPath - just use a calculated value? So - you put the table from the secondary data source on the form, and in one column use a calculated value to show the result?
-
Not to be slow - but the Planned Total Number is from the list, and is per project? So is the number of completed? Wouldn't you just put a calculated value in the column for Number Of Uncompleted that is the Total Number minus the Number Completed?
-
Just emailed you via the forum - you can reply to my email w/ the form attached & I'll take a quick look later today. :)
-
I'm not sure I understand, but I'm attaching a sample that I think may relate to what you are trying to do? Save the attached file locally, right click, select design & preview to try it out. If I'm not understanding correctly, maybe you can attach your form in a reply under the options tab and I can take a look at it?
-
Ah - so is the issue with a text box not showing all the data? Browser form? InfoPath doesn't support what you are asking - but try changing some of the control properties on the field - set it to multiline. I just tried that in a browser form and the text wrapped (with the box expanding to show all text).
-
Oh - is the sample name in its own repeating section that is bound to a different data source? If so, that may explain the issue. Do you mind attaching a copy of your form under the "Options" tab & I can take a quick look at it?
-
This is on the changing event - I'd use the changed event, unless you want to instead throw a validation error (in which case you'd use the validating event...)? I guess I should clarify - what exactly do you want to have happen if the user selects someone who has already been selected? Set the people picker back to blank? Have a ...
-
Hiya - happy New Year! You can ensure your code only runs on insert by checking the Operation:if (e.Operation == XmlOperation.Insert) then proceed from there. You want the NewValue of the node, not the old value - but you may just want to run the code on the change of the AccountId, not the Person group (since when the fields change inside ...