How to stop Zero '0' showing up on number columns by default

[Thilina_Wick]

Hi all,

So I created an app to track stock (inventory stock) numbers at dealer points the only issue is appsheet shows a zero '0' by default on all number fields. This has led to end user confusion if the stock is zero they try to proceed without an input into that field as zero is shown to them.

How do I prevent this? The people inputting data isn't the most tech savvy so explaining it to them won't be as effective an option as showing the blank field so they know to input a zero there. (We can't have blanks in the submitted forms and due to some calculations down the line we need them to be number columns as well otherwise I'd have used a text column)

This is what I mean ⬇️

Thanks in advance ❤️

[TeeSee1]

You cannot stop displaying it. What you can do it put 0 in the columns' initial value. This way, 0 is already entered when a row is created and the user does not have to put 0 explicitly.

[Thilina_Wick]

Aw dang, I tried putting initial value 0 for a set of columns and then when a driver goes to enter data they send over data like 012, 0230, etc.

does appsheet mess up any sort of calculations if there is a zero infront, my initial thoughts think not but better to be safe because this is a fairly large scale app running in different parts of the country daily. Any thing to make the driver's data input life easier.

Any ideas on if the driver leaves it blank (Like they have been doing) to automatically add a zero for all blank fields when the data is submitted? (I know I know initial value is the best but 0123 values are the result sometimes)

[TeeSee1 · Accepted solution]

If the column is a number type, all leading zeros are correctly 'removed'.

Try it and see for your self.