What is the best/easiest way to format certain fields in Kinetic? Ex. Everywhere there is a phone number field, we would like them auto formatted to this general format: xxx-xxx-xxxx. Is this really only accomplishable with a customization in app studio?
2 Likes
To the best of my knowledge there is no “telephone number” data type. Even the SQL literature recommends using a text type.
So yes, a customization has always been required… but if anyone knows any different please shout!
EDIT: if you create a format for NADP (US and Canada) numbers, you’ll have an issue if you ever get any international customers or suppliers… so be vewwy careul here.
4 Likes
If you are trying to force users to enter the correct data, you could try adding a directive to make sure users put in the required formatting elements. That doesn’t help with formatting of numbers already stored without the formatting. Like Ernie said, be careful if you edit the default display format of phone number fields. If the number and placement of the digits is not 100% perfect, then your visible data might not be correct.