Validation for the Tuple field

[former_member480924]

Hi Experts,

The Validation to be written for the Tuple field. The EAN Code is a part of the tuple.

The EAN Code starts with the Series 11, 12, 13 & 14 are Valid EAN Codes. If the users maintain the other EAN Code series it should throw an error.

Please advice.

Thanks & Regards,

U G

[Former Member · Accepted solution]

Hi UG,

One other way can be -

IF(LEFT(EAN,2) = "11",TRUE,

    (IF(LEFT(EAN,2) ="12",TRUE,

       IF(IF(LEFT(EAN,2)= "13",TRUE,

          IF(IF(LEFT(EAN,2) = "14",TRUE,

FALSE))))

Thanks,

Ravi

[former_member480924 · Accepted solution]

Hi Ravi,

Thanks for the reply & it was helpful:)

We can get the Validation error by the above expression. The AUOM contains multiple line items which is the part of tuple. The EAN Code only for the edited w.r.t to the AUOM it will throw an error.

It is not validating for the EAN Codes for the existing which is assigned to the other AUOM i.e. not modified particularly.

Thanks & Regards,

U G

[Former Member · Accepted solution]

Hi UG,

It is not validating for the EAN Codes for the existing which is assigned to the other AUOM i.e. not modified particularly.

For that some change has to happen to the current records as they were present before the creation of this rule (validation).You can select all pre-existing records and run them against the validation to get the set of failed records.

Thanks,
Ravi