Specific value lock likes this CAPL263*****

[Sayad]

I have to lock the specific value, can it be done by entering. 

[Joseph_Seddik · Accepted solution]

I understand that you want to restrict user input to a string of 12 characters and that the first 7 characters should be: "CAPL263"

In that case you can use the following expression in the 'Valid if" field of your column:

AND(
  "CAPL263" = LEFT([_THIS], 7), 
  12 = LEN([_THIS])
)

______

Text Expressions | AppSheet Help Center 

[SkrOYC]

You should add "read others minds" to the list of your aptitudes 😂

I didn't understand a thing of the OP

[Joseph_Seddik]

😄😄 Let's see if I got it right  🤣 🤣 🤣