Removing thousands separator on integer field

Not applicable

I want to use an integer field to store and display a 5-digit number which is a telephone extension.
It gets displayed on forms with a thousands separator - extension 55123 becomes "55,123".
How/where can I set the diplay of this field to not use a thousands separator ?

2 REPLIES 2

Mark Stanger
Giga Sage

Even though what you're storing is a number, it should really be treated as a string. If you're not going to do any computations on the value in the field, use a string for the field data type instead. I always ask myself "Am I going to be doing any math on the values in this field?". If not, then I probably need to use a 'String' data type instead of an integer or numeric.


reedowens
Tera Contributor

On the dictionary record for the field add an attribute named format and the value of none.



This is from the wiki on attribute values for the dictionary



formatformat nameany numeric field such as integer or glide-dateSpecifies the type of number format to use instead of the standard numeric formatting. Options are:
  • glide_duration: formats a time specified in milliseconds as ddd hh:mm:ss.
  • none: disables automatic number formatting where a comma character is inserted after every three digits (for example, changes 2,500 to 2500).