We added a number field to our ticket fields for inventory. Our inventory uses four-digit barcodes, such as "1111". Unfortunately, any barcodes with leading zeros ("0027", "0143") lose their zeros when the form is saved ("0027" becomes "27"). Please consider maintaining the length of the numbers entered, otherwise it's no different than a regular text field. Thank you.
Closed for Voting
Leading zeros in number fields.
I know that this topic is old but we are having the same issue. One of our fields is for a serial number and the leading zeroes are removed. I understand that this is normal behavior for an integer storage type so how can I fix this without losing all of the existing serial numbers that have already been stored? I have considered just converting the field to a text type field but then I will lose everything that has already been stored in that field... Ideas?
Join the Community
Already have an account? Login
Welcome back to Freshworks Community
No account yet? Create an account
Social Login
Login for Freshworks Employees Login with LinkedInor sign up below
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.