Hi Forum Experts,
(Not Isempty(self) and field2 = "No" ) or Field2 ≠ "No"
For some reason, I cannot make an adaptation of that work as a validation calculation. So as a work around, I've used Phil's guidance successfully in a script that triggers on Record Commit for three different layouts, so the calculation is not the problem. Thank you Phil.
I'd really like to figure out why it would not work in my validation set up. My thinking is that it'd be better to have this validation working at the field level, rather than having to trigger a script every time this field appears on a layout. Or is that reasoning fallacious?
Here's the validation set up… showing the calculation window alongside:
I have also tried this with:
- Validate… set at Always, and
- Without the Member of value list ticked.