For more information, please refer to this announcement explaining best practices for getting answers to questions.
Verification of data consistency in 2 different fields:
Summary:
Content (required):
Our customer wants to do a verification of data consistency in 2 different fields: "Grade step name" and "Employee Category". For example, if in the field Grade step, there is a value "Step 1 - Cadre", so in the Employee Category the type "Cadre" should be used. So, for example, if the Grade step is "Step 1 - Cadre" and Employee Category is "Worker" this is not correct.
Our Customer has already a special report to determine the existing discrepancies but this is not enough. They need to do a data validation while entering the data in the system. So, that an error message was appearing if the data is not consistent.