-
You actually don't need to loop, you just need to set the default value for the Balance field to be equal to the previous row's Balance field minus the Amount field. Start with the following formula:Balance - Amount Then select the Edit xPath (advanced) checkbox, which will change what you see to something like this:. ...
-
It's actually much easier: just add a formatting rule to your repeating section. Set the rule condition to be "Column1 = No AND Column2 = No AND Column 3 = No" and then check the "Hide this control" checkbox. This will hide all rows that have No for all three columns.
-
How about creating a form field called FormName and then in your submit data connection make sure the form name is set to this field (no concat formula, just the plain old field). Then add a new rule on your submit button (make sure this new rule executes BEFORE the rule that actually does the submitting) that sets the FormName field ...
-
I would suggest using a REST data connection to query your list. With REST you can specify sort order on multiple columns. Here's a quick video that will help you get started with REST queries: http://channel9.msdn.com/Blogs/donovanf/InfoPath-2010-and-Creating-a-Form-that-Consumes-a-REST-enabled-WCF-Service
-
This can be done only with extremely complicated logic. My suggestion is to download a trial of Qdabra Rules and use the DateDiff command, which can be configured to ignore weekends. You can get a free trial here: http://www.qdabra.com/en/products/download/qRulesTrial.aspx
-
Does your form template have any promoted properties? Generally, any fields you want to appear in library columns need to be designated as promoted properties.
-
What browser are you using to open this InfoPath list form? Sometimes controls will malfunction in browsers other than IE. If you're using IE, what version?
-
Hello there,
No such thing as a too easy question, and newbies are welcome here!
However, I'm a bit confused: you mentioned a Key Facts list and a Product list, but I don't see any reference to those lists in the screenshot you posted. Can you connect these together for me?
-
Can you post the details of the SOAP error you're receiving?
-
It sounds like you have a set of rules that are executing indefinitely, over and over, when you open the form. Do you have any Form Load rules or default value formulas? If so, check these very carefully and make sure you don't have a situation where Rule 1 on Field 1 updates Field 2, which then causes Rule 2 to run and update ...