asked on February 9, 2026
Hello Flexmonster Team,
I am encountering an issue where leading zeros are automatically stripped from a specific column, even though it has been explicitly defined as a String.
The Issue: In my dataset, I have an identification column (ID/Serial Number) that contains values starting with zeros (e.g., "001245"). Despite forcing the data type to String in the mapping/schema configuration, the pivot table automatically treats these values as numbers and displays them without the leading zeros (e.g., 1245).
Could you please let me know if there is a specific property or a formatting option I should use to prevent this automatic conversion?
Best regards,
⋅ February 9, 2026
Hello, Emmanuel!
Thank you for reaching out to us.
Kindly note that Flexmonster by default tries to parse the numeric values from strings where possible. The recommended approach to have the leading zeroes in the ID field is to explicitly define the string datatype via mapping in Flexmonster: https://www.flexmonster.com/doc/mapping/.
We have prepared the example showing how to set the mapping in the dataSource object: https://jsfiddle.net/flexmonster/gwhovcyz/.
Could you please double-check the mapping configuration on your side using the provided example as a reference? If the mapping is set as in the example and the field is still displayed as a number, please modify our example so the case is reproducible on our side.
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ February 19, 2026
Hello, Emmanuel!
Hope you are doing well.
Our team is wondering if you had some time to check out our previous example about setting the string type using mapping to preserve the leading zeros of an ID field. Could you please let us know if there are any further questions?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ March 5, 2026
Hello, Emmanuel!
Hope everything is well.
Just checking in to ask if the suggested approach of setting the string type to preserve the leading zeros works well for you.
Looking forward to hearing your feedback.
Kind regards,
Solomiia
