Page 1 of 1

[Solved] Leading Zero in Base

PostPosted: Mon Apr 27, 2020 10:45 am
by Mickey12
Hi I am unable to get the leading zero to show in a form. I have tried added leading zero in format and also changed to text. Nothing doing.

Re: Leading Zero in Base

PostPosted: Mon Apr 27, 2020 1:59 pm
by Villeroy
If the table column type is numeric (integer, decimal, floating point etc), you can use either a formatted field or a numeric field and format to your liking.
If the table column type is text, you have to enter the leading zero because the text "0123" differs from the text "123". In this case you should use a pattern field.