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.
Yes it sorts it for the string but as these are numbers want to sort them according to numbers will try out the suggestion
Do let me know if it works for you.
Integer datatype in Appian isn't capable of storing a 10-digit mobile number. I would still advise going with a text type