Solved: Does a scanned field override the field's validati... - Page 2

Daisy_Ramirez · 05-21-2021 06:59 AM

We have the following validation in place on a scannable field. The user scanned a barcode into the field and it looks like a period was generated but the field allowed it to be saved.

Does a scan override the field’s validation or is there a validation expression problem?

Daisy_Ramirez

Just wanted to update the post with the implemented solution: I added the following to the validation expression:

NOT(CONTAINS([_THIS],".")),

AND(
LEN([_THIS])=10,
NUMBER([_THIS])>0,
NOT(CONTAINS([_THIS],".")),
NOT(IN([BIN Barcode],SELECT(Collection[BIN Barcode],
AND(NOT([collection_id]=[_THISROW].[collection_id]),
[route_id]=[_THISROW].[route_id]))))
)

View solution in original post

Does a scanned field override the field's validation?