Pad Zero's

[sloganuga]

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?

[Steve]

[sloganuga]

Steve,

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…).

[Steve]

sloganuga:

is there a way to convert when the user leaves the field?

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

[sloganuga]

May go that route. Thanks!

[JeofryDC]

try this:

RIGHT(CONCATENATE("000000",[FIELD]),6)