No show of leading zero's on scan but need to enforce numeric value

[Daisy_Ramirez]

I understand AppSheet does not recognize leading zeros in a numerical value but client requires only numeric values in the field and needs to see the leading number during entry for confirmation

If I revert to data type of Text on the field - how do enforce only numeric values in the field?

[LeventK]

@Daisy_Ramirez
Can you exemplify?

[Daisy_Ramirez]

Client requires a 10-digit number of the bar code field.

Client inputs 0345645678 but will see the validation check error since AppSheet doesn’t recognize the leading zero.

[LeventK]

@Daisy_Ramirez
That’s so normal because no any integer can start with zero, therefore a 10 digit number can only begin with 1

[TyAlevizos]

Hi. A “Valid If” statement could help here. Here’s a simple example (image pasted below). I tried this out, if I scan a number and then afterwards attempt to change it to text, it won’t let me. I didn’t have anything nearby to scan that included text… perhaps you can test on your end?

[LeventK]

if 10 digit is a must then it shall be:

AND(
    LEN([_THIS])=10,
    NUMBER([_THIS])>0
)

[Bahbus]

In the details for a number column, you can tell it to always display 10 digits, which will have leading zeros. I don’t know if it helps you on entering the numbers and validating them.

[LeventK]

@Bahbus
Have you tested your proposition?

[Bahbus]

Only so far as displaying them. Not on the entering of them. But it should at least help simplify things for @Daisy_Ramirez. Even if AppSheet isn’t saving the leading zeroes into the underlying spreadsheet/database.

[Daisy_Ramirez]

Alrighty…this worked like a charm!

AND(
LEN([_THIS])=10,
NUMBER([_THIS])>0
)

Thanks everyone for the different ideas. I’ll keep this as reference for future use as well.

[Vital_Quality]

I have the same problem when i extract the minutes from Time Now.
Is there any way that i can extract with the 0 as currently it attracts 10:7 instead of 10:07.
Anybody could help?

[LeventK]

@Vital_Quality

RIGHT("0"&MINUTES(TIMENOW()),2)

[Mônica]

I'm going through a similar problem, I have a database with CNPJ (what is similar to EIN ) of clients, it always have 14 numeric digits, some of them starts with 0.

I have a enum to choose one of them, but it always ignore 0's.
Is there some formula that I can use to solve it?

[Steve]

Please start a new topic for help with this.

[Mônica]

Thank's @Steve! I already did it and solve my problem.

[SKrummrich]

so is there a link so i can read it to perhaps solve my problem?