There is a scenario where i need to update the status of a custom object based on 3 multi value lookup fields created under the same custom object. I have 3 multi select lookup(L1, L2, L3) and an indicator field that lists the 3 multi select lookup (values - L1, L2, L3). Not when L1 is selected in indicator field, I would have to make sure that only multi select L1 is selected and no other multi select lookup is selected. If other multi value lookup values are selected too, then I would have to change the status as cancelled. Is there a way to accomplish this in Clarity?
Please help. Thanks in advance.