Home > Forum > General > Leding zero in numeric field

Leding zero in numeric field
0

Hi,

is it possible, to show a leading zero in a numeric formular field?
Example: 09678 instead 9678
If i change the field type to text, all existing values dissappear due the change of field type.

MVP

Hi,

if you have your field is of type floating-point number instead of integer, you can use the advanced configuration to display a leading zero in the UI using the prefix.

It's important to note, that the suffix will only be displayed in the UI. If you would copy the value to another field, the prefix won't be part of it.

If you are using an integer value currently, you would need to change the type anyway.
You could achieve this by:
- creating a workflow which copies the field value from the old to the new field.
- writing to the database which is not supported
You could read through this and decide, whether you want to use this.
https://daniels-notes.de/posts/2023/migrating-field-values#copy-values-to-a-global-field

Best regards,
Daniel

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings