Custom number format


#1

A useful feature for plain number entries would in my opinion be custom number formats.

For example I have entries like 0052 and the Number field type will delete the zeros.

Thanks for the consideration :slight_smile:

PS fantastic product you have going here!


#2

Thanks for the feedback! I’ll pass it onto the rest of the team. In the meantime, the single-line text field is probably your best bet to preserve your formatting.


#3

Indeed, that’s what I’ve been using, since my use case doesn’t require more at this point :slight_smile:

And thanks for the quick response.


#4

Hi just a suggestion try using this REPT(“0”, 4 - LEN("" & RecID))) & RecID where Recid is the numeric field you wish to format and the number 4 is the number of leading zeros you wish to have.


#5

Great solution! I had to adapt mine to the autonumber and use the concat function to force it a text.

REPT(“0”,4-LEN(CONCATENATE(GUID,"")))&GUID