-
I'm afraid that using translate() here will not only remove the part you want, but will also remove the letters from the domain name that appear anywhere else, so if you had:
DOMAIN\Dom Delouise;DOMAIN\Ned Flanders
You would wind up with
om elouise;ed Flanders
Is that not the case?
-
You can carry out a sumproduct (or sum any other aggregate expression) using the eval and sum functions:
sum(eval(/my:myFields/my:myGroup/my:myParentField, 'my:childField1 * my:childField2'))
-
Two thinks you can do: 1. Iterate through all the items in the InputParameters collection, looking for the one you want. This will also let you do a case-insensitive match on the key. or 2. Place your lookup in a try-catch block.
Either approach should work if the key is right, though I recommend the former.
-
If you click a field in the data source taskpane, there should be an option to edit its rules. Do this for the field bound to the first dropdown, and add a rule whose action is to set the field bound to the second dropdown to blank. This rule will execute whenever the first field's value changes.
-
If you don't mind sharing the form, you could attach it to this thread and I could take a look to see if anything pops out without connecting to the library. Otherwise, I would advise taking a look at the rules defined on the fields involved here to see if anything might be going awry.
-
Hi Ben,
I'm sorry to hear that. Could you send the form to our support alias support AT qdabra DOT com?
-
Hi Ben,
This appears to be an issue with using qRules Insert with date/numeric fields, though this happens to be the first time I've heard of this problem. It sounds like the necessary xsi:nil attributes are not present and this is causing a problem.
As a workaround, please try using the following command right after your Insert ...
-
One thing you can do is set the security to Full Trust while you are working on the form, and change it back to Domain Trust right before you publish it. Would that work?
-
What version of InfoPath are you using?
-
You should put a rule on the ContainerType field to always reset Size to blank. A dropdown will show the bound field's current value in addition to the valid options if the current value is not in the available options.