-
I usually use a count of preceding sibling + 1 for this - it really depends on things like where your rule is, what your desired outcome is, etc, but my general approach is like this:
concat("Insert /parent=/my:myFields/my:CCProjectFields/my:CCHeaders[", count(preceding-sibling::my:CCHeaders) + 1, "]/my:CCDetails ...
-
Hi - I usually use a field in the form with a default value - you can use the formula you are using now in the default value, then set the data connection to use that field for the form name. Currently, now() is being evaluated on each submit. If it is used in a default value, it won't be evaluated repeatedly and the file can overwrite.
-
The only decimal related calc'd value issue I've had was because IPFS and Filler use a different scale (one uses 15, the other 16) and it was causing me issues in a signed section - that said, I don't usually work with data bound forms. I've not run into formulas behaving inconsistently, which is what is sounds like you are ...
-
You can email Support AT Qdabra DOT com to schedule time with a Qdabra resource to take a look at the problem (it may not be directly with me, but we have a lot of other knowledgeable InfoPath resources who can help you out).
-
Do you have access to the SharePoint server? You will need to look at the logs and look up the GUID that you see as the Correlation ID in your error. This StackOverflow thread has info on default locations. If you don't have access to the server, you'll need to give your SharePoint Admin the correlation id so they can look it up.
-
So, what I'm wondering is - why not change that 9 to a 15? And adjust the 28 accordingly, if your numbers are that big. And walk through the data connection again so the form has the updated schema. It just seems simplest?
-
But if the data type is an int in SQL, you'd need to make sure the value you are submitting has no decimals, right? It looks like everything you've tried thus far has 2 digits after the decimal? Sorry, I have a feeling I'm confused. Feel free to attach screenshots under the Options tab.
-
Euw - got it - what's the data type in SQL? Can it be changed to allow more decimals?
-
I'd leave the value alone and just change the format on the control that displays the data to only show two decimal points. Does that work for you?
-
With SharePoint 2010 and InfoPath 2010, you have query fields in the List data connection. You can just set the query field as equal to whatever form field your drop down is connected to and execute the query to get back associated items. No code needed.