Hi,
I believe sorting, on text fields, is done alphabetically having the whole field as a string.
Being it that way I do not understand why, on the attached file, records from 18 to 23 are not following record 9.
am I missing something?
Attachments:
You must be
logged in to view attached files.
Yeah, many of us have gotten used to inserting leading zeroes for the 1-digit numbers to ensure the desired alphabetical sorting. And if you insert a leading zero in Tap Forms, it doesn’t matter: Layout 1 will still precede Layout 02. If you were to sort the same list in Excel, it would be strictly string-alphabetical.
So sorting in Tap Forms is a little smarter than simple string sorting, and understands that 1 is followed by 2, rather than followed by 10,11,12. On the one hand it seems convenient, but it’s not a good thing if sorting leads to unexpected results. But then again, what would the “average user” expect?
Yeah, I’m a bit wishy-washy on this: no strong rationale for arguing one way or the other.
— Mike
.
