-
Most likely this is happening because one of the fields being used in the default value is being set or modified when the form is opened, and you have the "Update this value when..." option selected.
Allowing a field with a default value to be overriden is a tricky proposition. I'd suggest providing a separate field for ...
-
Hello BigToe,
An InfoPath form is a lot more than just a manifest.xsf file, and you can't duplicate one just by copying the manifest.xsf file.
100 different forms, each with its own custom code sounds like lunacy to me. Have you checked out qRules yet? qRules provides most of the functionality people generally want to ...
-
Hello Michael,
We at Qdabra do not advocate using SQL data connections from InfoPath because it creates a tight coupling between your form and your database. And modifying data connections' SQL to incorporate form values carries with it all the dangers and unlpleasantness of escaping values and protecting againt SQL injection. The ...
-
Here's a document that explains how to use qRules along with custom code:
http://www.infopathdev.com/files/folders/qrules/entry56111.aspx
Note that this will only work with InfoPath 2007 OM (C# or VB) code.
-
Are you still dividing by 12 when you use the values 2 and 4? If so, 1 is the expected result:
(2 + 4) / 12 -> 0.5 (round)-> 1
-
What if you round the average?
round(sumsection div 12)
-
How about using the round() function? :-)
-
You need to construct your SQL query in a manner that is syntactically correct. In this case, it looks like just tacking a WHERE clause on the end of the default SQL statement isn't going to work. Why don't you figure out what the entire query is supposed to be and use that instead?
-
You can export the form's source and manually edit the XSD. Should work. Here are guides on how to specify custom field formats in XSD using regular expressions:
http://www.dpawson.co.uk/relaxng/schema/string.html
http://www.15seconds.com/issue/031209.htm (see the ssnumber section)
You may want to to point out to ...
-
What is the client's requirement, specifically?