-
So - this is still not correct. I must not be explaining well. I'm attaching a form that might help. Feel free to attach your template to a reply. You need to change the first dropdown in the condition builder to "the expression" and then enter the XPath expression. It needs to be correct, including the correct relative path to the ...
-
I was just taking a screenshot for you - I'll post it anyway for anyone looking for this in the future. :)
-
Try this one - I added the same tables from the other form on the Calculations view - let me know if you need help with other formulas / data you want.
The company I work for, Qdabra Software (which runs this forum) does offer consulting & support - you can order pay-as-you-go support here or use the Contact Us form to request info on ...
-
You'll need an "and" between those, and manager_acct will need to include the XPath to the field, but if you change the dropdown to the "the expression" you'll get the full XPath. Let's pretend it is something like "my:group/my:manager_acct" the expression would be: my:group/my:manager_acct != ...
-
In the last condition in your picture, can you change the first dropdown to "the expression"? A text box will display to the right. Can you copy all the text out and paste that in a reply? Thanks!
-
Glad that did the trick for you and thanks for updating the thread!
-
Right. See attached sample.
-
What is the expression you have in your final condition? In a condition you create using the normal dropdowns, if you change it to "the expression", what is the expression? Paste those in and I should be able to help you.
-
So - the thing with and / or in the validation rule is that you are often checking if something "is not" something else. Which means you end up using "and" more often. Like - "this fruit is not an orange AND it is not a pear" when you are holding an apple. For the more than 5 conditions, I use an expression for the ...
-
It looks like you are currently using default values to set these, is that correct? There is a checkbox for updating the result when the data changes in the field's properties, have you tried checking that? I would probably use submit rules to set these instead of default values, but that is just me - if default values are working as you'd ...