Chronological hierarchy of sorting in tables

Here’s how sorting works on Numbers, Apple’s spreadsheet program:

  1. Start with a simple table, where everything is displayed in the original order:

Screen Shot 2019-12-15 at 15.52.14

  1. Sort a part of the table. In this case, I sorted the Amount in descending order:

Screen Shot 2019-12-15 at 15.52.35

  1. Sort another part of the table. In this case, I sorted the Category in ascending order:

Screen Shot 2019-12-15 at 15.53.09

Notice that, where the Category values are equal, the Amount values remain sorted in descending order.

In table view we can easily sort by tapping on the header at the top (if the headers are displayed). However, when we tap on another header, AppSheet seems to forget what it has just done and sorts the table as though a sort had not preceded it.

If it’s not too difficult (or too expensive in terms of computing power), I think it would be great if AppSheet’s table sort could remember preceding sorts in the manner I’ve described here.

If it’s not too complicated to your user, you could that with the Usersettings :grinning:

1 Like

Thanks @Aleksi! I should have mentioned that I looked at your sorting example:

www.appsheet.com/portfolio/531778

I can see how this use of the Usersettings can be helpful. However, it doesn’t seem to have the flexibility, ease of use, and intuitiveness of the kind of function I described above.

I am also aware that there are other ways to accomplish similar things. For example, here’s a great contribution by @GreenFlux:

It might be possible to add the sorting order of a column or two to this kind of interface as well.

So, I understand that there are ways to accomplish similar things as the platform is constituted right now. It just seems to me that, from both the perspective of the app developer and the user, it would be a significant step forward in table sorting could be “cumulative,” instead of starting over with each tap.

Understood :slight_smile:

1 Like