-
Are you using a concat() formula? concat(Fieldname1, " - ", FieldDate)
-
Assuming you're using the 2007 OM, you can use this code to get an XmlDocument containing the form's schema:
XmlDocument doc = new XmlDocument();
doc.Load(Template.OpenFileFromPackage("myschema.xsd"));
once you've got that, you can search it using the XPath //xsd:element[@name = 'fieldName'] to find the ...
-
Yeah, just try wrapping that whole formula in number(translate(formula, 'aN', '0')). That should work.
-
Qazi's approach is clever, but I think you can accomplish this with a single formula:
(field1 + field2 + ... + field10) div (10 * count((field1 | field2 | ... | field10)[. > 0]))
-
No pienso que necesite plena confianza para usar este código. Pienso que instalar todos los Office service packs nuevos puede ameliorar la problema.
-
Unfortunately, I don't think there's an easy way to do this. current() refers to the current row of the inner repeating structure and I don't think there's a way to refer to the outer repeating row from your formula.
This came up recently in another thread, and here are the possible solutions that I was able to come up ...
-
Could you attach your XSN to this thread? Or if you don't want to publically share your form, try this in a brand new XSN and attach that?
-
InfoPath's formulas are essentially XPath 1.0 with a few extra functions added, so aside from Ernesto's link, the spec should tell you most of what you need to know:
http://www.w3.org/TR/xpath/
-
Are you saying it doesn't open in Design mode when you right click it and select Design?
-
Yes, it seems that's very likely the issue. If you go into the form options, there should be an Remove Code button somewhere that will allow you to remove the code entirely. Could you give that a try?