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
balajib2642 said:....data type are different so it is not working
When you say something like this, you really also need to include details as to what you mean by "not working" (including the code you're currently trying, not just a screenshot of the grid, as well as the error message you get).
Because in cases like this, the answer we give could be anything ranging from a slight tweak to help correct a data type casting issue required by a finnicky comparison rule (common in Appian), or a total rewrite of your logic to produce something that works better over-all.