Hello, I have actions configured for copying a parent/child scenario - Job Order Header/Job Order Detail. Both the the job order header & detail have valid if expressions in place preventing the user and another field from being duplicated but since the same job order is being copied with the same job order no (not a unique id or key), its ok to make the copy When I run the copy, it fails as a result of the duplication.
Hereโs my expression for the user id thatโs failing with my attempt and stating if the user is in the lis but its the same job order its ok to include it in the listing.
SELECT(users[Email],OR([vir_user_assigned]=FALSE,[vir_job_order_no]=[_THISROW].[vir_job_order_no]))
Is there a way to indicate exceptions to the Valid ifs in an expression? I have this issue in many areas of my app so any help on thinking this one through would be outstanding.
A million thanks
LinkedIn
Twitter
