Pad Zero's

I would like to pad zeros onto user input, so an entry of “425” would convert to “000425”. Something similar to what right(“000000”,[field],6) would do in other code.

I know I can do this with a workflow when saving, but is there a way to convert when the user leaves the field?


1 Like


This is a text field so I don’t think that will work. I need to actually pad text 0’s onto the front of the entered value. (No comment on this being a text field, just working with what I was given on this one…).

Nope. You can add another column with an App formula expression that could generate and store the formatted value, though.

1 Like

May go that route. Thanks!

1 Like