-
To the best of my knowledge, you cannot paste from Excel into IPFS the way you can into filler - I'm sorry I don't have better news for you. I just recently tried this myself in a ShP 2010 enviro.
-
What about adding one more field to the data source - called Subtotal (or something that makes sense to you). It doesn't have to show on the form - just add it to the data source. It's default value could be the formula you have above - "Total Expenses" - "Less Company Paid" - "Less Travel Advance" ...
-
You bet - we've all had those "Why didn't I think of that!" moments (I have lots, myself.... )
-
So, you need the traveller to be equal to the value of the occupant field?
concat("SetValue /xpath=/my:myFields/my:Travel/my:TravelGroup/my:Travellers/my:TravelToDate[../my:Traveller='", Occupant1, "'] /value=", .)
-
If your table is bound to a secondary data connection (which it sounds like it is - you added it to the form from that data source) the number of rows is going to be determined by how many rows are returned by that query. Thus, if the data source has 5 rows, when InfoPath queries the data source, your repeating table will have 5 rows.
I do not ...
-
What is the XPath to the TotalNotices? You can right click it in the data source task pane and use Copy XPath to get the full XPath.
-
Where is the expression box located? Will it be inside a table bound to the Project Status data source?
-
More helpful would be a screenshot of your data source, since creating the calculated value is going to have to do with getting the XPath right. What's the formula you used that didn't work? Check the Edit XPath box before pasting it in so we can see the full XPath....
-
My guess would be that the null reference exception is occurring when you set the value of "value" and "display", because SelectSingleNode is failing to select a node. I see that SingleMember is using the "my" namespace - are "value" and "display" children of SingleMember? If they are ...
-
Well - you can certainly hire us to help with that - we do offer paid InfoPath support, and you can learn more about our services here.
However, the work is more complex than something I'd be able to help with ad hoc via the forum. I did get a reply to my email suggesting that it may be possible to remove the database dependency with manual ...