Hi,
I am trying to achieve something, lets say in IG we have a column 'EMPLOYEENAME' and a column ''EMPLOYEENUMBER". We will enter a few rows by using 'Add Row' button of IG, and when we click save, if there are same values for 'EMPLOYEENUMBER' (null values are fine just same numbers are causing problem), validation should give an error like 'Use different numbers for Employee Number column', and shouldn't save the records. The issue in here is that values don't have an ID or something because they are not saved yet so comparing the not submitted rows' column seems impossible for me (Maybe with JS we can do that). I want to do this in APEX, without adding a constraint to the table. Is there any way to do this?
Best regards