Hi Can you guys help me with the code I am trying to give validation for the condition so for Add client Dropdown there should be only one active status if same occurs it should throw an validation error.
The issue is I tried using whercontains but add client and is active ....data type are different so it is not working
Discussion posts and replies are publicly visible
Why not you give the validation on the Active columns?
I want to compare both Active and Add client coulmn we can have many add client but for that is active column should be one
HI balajib2642,
you can try "AND" condition, in which in one contains func you can check for client and in other you can check for Active one. If both are true, then you can provide validation message.