Invalid formatting of uitype 1 in vt7.0.1
I've just done a test migration of a customer's vtiger 5.4.0 system to vt7.0.1.
One field in the original system represents the serial number of an Electricity meter. In vtiger_field this is defined as uitype = 1 and typeofdata = 'N~O'.
It is set to typeofdata "N" because this is only a numeric value but we used uitype 1 so we didn't get numerical formatting of the data when it is displayed to the user.
See these two screenshots below.
and then from the migrated system:
So how do have a field which only accepts numeric input but does not apply any formatting to it? Also bear in mind that this type of field may well also start with leading zeros... I bet in this scenario those would be removed from the display.