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,
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.
May go that route. Thanks!
try this:
RIGHT(CONCATENATE("000000",[FIELD]),6)
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |