LinkedIn
Twitter
Hi
I'm seeing some unexpected results when a user had clicking on a column name in a Table View to sort by that Column.
The Column is a Text column but some of the rows are appearing out of the order I would expect.
I have highlighted one such row in the screenshot below.
I have checked the data in the source sheet for extra characters and spaces etc and found none.
Does anyone know why this might be happening?
Regards
Nigel King
Solved
1 ACCEPTED SOLUTION
It seems that AppSheet interprets numerical digits as numbers and sort numerically.
So it sorts as in this order for example even when they appear within alpha numeric text.
0 -> 1 -> 002 -> 9 -> 10 -> 50 -> 101 etc
| User | Count |
|---|---|
| 17 | |
| 11 | |
| 11 | |
| 8 | |
| 4 |
