-
How's this:
substring(eval(eval((field1 | field2 | field3 | field4 | field6[field5 != ""])[. !=""], 'concat(", ",.)'), ".."), 3, 1000)
The other option is to put a rule on field5 to reset field6's value when field5 is unchecked, but depending on your design, you may or may not want to ...
-
concat(addDays(today(), -7), 'T09:30:00')
should do the trick.
-
You can use the EditDocument2 method on the SharePoint.OpenXMLDocuments.1 object described in Shraz's post to open XML files.
http://msdn.microsoft.com/en-us/library/cc264018.aspx
-
Glad to help, and I hope you figure out this last problem. If you still can't get it after a while of troubleshooting, you can e-mail the form to me at james dot rishe at qdabra dot com, and I can have a look.
-
No problem that I know of, but I've never tried the formula with more than a few fields.
-
Is there any chance the checkboxes in that section have blank spaces in the unchecked value? Could you post your formula?
-
The form opened fine in design mode, but refused to open in preview mode.
It looks like InfoPath has a problem with using the [. = ''] filtering in an eval() expression for a default value with the Automatically Recalculate option selected.
I've worked around this by having each of fields 1-5 set field6 to the value ...
-
Well, you can attach it to the thread without re-opening it in InfoPath, right?
-
I don't see that formula in the form you attached. Did you attach the version of the form that doesn't have that formula in it? And is InfoPath providing a Show Details button where you can see a more specific error message?
-
Sorry. Use &lt; instead of <.