Mask for field

[doubts]

Hello, how do I determine that a field can only have 8 numeric digits and make this mandatory? I know this can be done through mask, but I do not know how to use it

[1minManager]

help.appsheet.com

LEN()

Number of characters in textual value

[doubts]

When usage says the function was used incorrectly.

LEN([numeric]) = 8.

[MultiTech]

If you put your formula

doubts:

LEN([numeric]) = 8.

inside the valid if space, that will ensure that the length must be 8 characters long.

@doubts are you getting an error with that formula like that?

[Steve · Accepted solution]

It may need to be:

LEN([numeric] & "") = 8

[MultiTech]

Hmm… you might be onto something - len is expecting a text:

LEN(TEXT([numeric])) = 8

[Steve]

Note that use of TEXT() will apply display formatting to the result, which may change the length. CONCATENATE() or & will retain the stored format.

[MultiTech]

I didn’t know that about text(). Every day is a learning day.

[MultiTech]

There is also a setting for the number of digits for the Number type details:

[doubts]

It didn’t work for me.