Hello,
I have a field for mobile numbers in my Appian application, but it is in text format instead of integer. Appian does not support 10 digits as an integer, so I cannot change it. I need to sort this mobile number field on a read-only grid, but it is sorting as a string due to the text format. I need it to be sorted as an integer field.
Discussion posts and replies are publicly visible
Like other have already mentioned, I would recommend storing phone numbers as text.
It's quite easy to validate a phone number and formatting it as a string on save. You could even create a Custom Record field that strips all the formatting characters to help with the sorting.
Appian even has an example on how to create such a field: docs.appian.com/.../fnc_text_isphonenumber.html
tejas_n ,
I think you can make on custom record field with type decimal and cast this text field to decimal then use this custom field for the sorting, if you are using record as data source