Solved: Mask for text - Page 2

SantiagoS1 · 01-13-2020 08:20 AM

Hi,
First, sorry for my english.
I can’t see in documentation the way to put a mask in valid_if text field.
I need to record licence plate of many cars. My staff make many mistakes when they record the licence plate from android.
Licence plate in my country are always in format 0000LLL (4 numbers 0-9 and three letters).
how can i validate this format rejecting any format different to this?
Thanks

Steve

Or:

AND(
  (LEN([Plate]) = 7),
  CONTAINS("0123456789", MID([Plate], 1, 1)),
  CONTAINS("0123456789", MID([Plate], 2, 1)),
  CONTAINS("0123456789", MID([Plate], 3, 1)),
  CONTAINS("0123456789", MID([Plate], 4, 1)),
  CONTAINS("ABCDEFGHIJKLMNOPQRSTUVWXYZ", MID([Plate], 5, 1)),
  CONTAINS("ABCDEFGHIJKLMNOPQRSTUVWXYZ", MID([Plate], 6, 1)),
  CONTAINS("ABCDEFGHIJKLMNOPQRSTUVWXYZ", MID([Plate], 7, 1))
)

View solution in original post