LinkedIn
Twitter
I have a validation on a field called "Confirm Next Day" that was working just fine but when I left for a few hours and returned it doesn't function anymore. Here is the Valid If - two scenarios where the info is valid.
OR(
AND(
[vir_visited_sites_var]<=0,
[Type Select]="ROUTE_COMPLETE",
[_THIS]="N"
),
AND(
[vir_visited_sites_var]>0,
[Type Select]="ROUTE_COMPLETE",
[_THIS]="Y"
)
)
With this scenario, the following should not be allowed but the Error is not triggering. I've confirmed:
- I'm on the correct record
- The field vir_visited_sites_var is greater than 1 (placed on screen for reference)
- For the field with the validation, used the name of the field (Confirm Next Day) as well as [_THIS]
- Confirmed the id for "Complete Route" is "ROUTE_COMPLETE"
- I've regenerated the table
- Refreshed several times
Is there another way to configure that may be more effective? There must be something I'm missing
