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
Do you want to leverage Appian grid sorting on a column? I mean when you click on the column header, it sorts.
To sort mobile numbers as integers in an Appian readonly grid:
Create a hidden integer field in your data source.Convert text mobile numbers to integers and populate the hidden field.Include both text and hidden integer fields in the grid.Configure the grid to sort based on the hidden integer field.