utilização de zero à esquerda

AppSheet AppSheet Q&A
, ,
1

Hello!!

have a little big problem.
I created a data validation for a column that will have CPF values. Values ​​must have 11 digits (without dots and dashes), but Appsheet simply ignores leading zeros, even if the column has been formatted as text, making it impossible to fill in the form and add new rows to the table where validation is performed. Could anyone help resolve this issue?

2

Google Sheets will drop leading zeros if the column (in Sheets) is not formatted as text.

AppSheets should not drop leading zeros if the column is set to text, and the Sheets file also has the column formatted as text.