-
It's not very pretty, but you can perform a non-case sensitive comparison by converting both sides of the comparison (or one side if the other is a constant) to lower case.
So if I wanted the filter to include rows where field1 = field2 (ignore case), I could use the formula
translate(my:field1, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", ...
-
Actually, checking for blank/not blank should do the trick (I just tried it). The rule should be specified on the file attachment's field, not on the field you're trying to set. Could that possibly be where you're going wrong?
Also, please make sure that a formula for the default value of your yes/no field isn't ...
-
By any chance are those fields in a repeating field of some sort, or are they all separate fields throughout the data source. Could you post your formula in its current form?
When you added the XML file, did you leave the option "Embed this as a resource file" or something like that checked, or did you uncheck it? ...
-
Did you make sure to set the text box as a multi-line text box (in its properties)?
-
I think the main trouble here is that Expression Boxes do not support line breaks, so you'll probably need to use a textbox. There are a few ways to go about this. You could create a textbox that's bound to a field in your main data source, and set its default value to be the expression you're using above. If you ...
-
There is no way to set row colors using just code and anything you could do to color alternating rows with code would be more complicated than not using code.
I would recommend using conditional formatting with two conditions:
position() mod 2 = 1 - color for odd rows
position() mod 2 = 0 - color for even ...
-
You can do this by placing a rule on the field:
Set a field's value (select the field itself)
Formula: translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ")
-
I believe it would actually be
Email.Subject = XDocument.DOM.selectSingleNode("/my:myFields/my:field6").text;
without the "this," but otherwise that should work if the XPath is correct.
-
Hello Mr. Palmer,
Adding line breaks to an InfoPath field is a bit tricky indeed. Greenant's solution works if you are using code and a rich text field, but if you are not using a rich text field (and just using a regular string field), then there is a relatively simple trick to get those newlines. I can't find the post on ...
-
If you don't need the "Agent" and "Guest" labels actually stored in the XML (i.e. their meaning is assumed based on their order in the list), you could try something like in the attached template. I've simply used conditional formatting (right click the "Agent" and "Guest" expression boxes and ...