Sorting tables in android mobile app

What I’m trying to do

I really like the feature on the PC app that allows me to put the cursor in a column of a table and then sort the table by the contents of that column. I would also like to do the same thing in the phone app (android) but can see no way to do this. I would like to do this without add-ins since I can do it on the PC app without add-ins.

Things I have tried

I was unable to find any solutions to this in the help docs or forum. I tried adding options to the toolbar and can see plenty of options relating to tables but nothing for sorting.

What am I missing?

Are you talking about static or dynamic tables? That is a pure markdown table, or a table from dataview, or sqlseal or database folders?

Let’s deal with all these candidates:

  • For a pure markdown table, you can use the context menu for a column to sort that column from a-z, or reversed when in live preview
  • By default dataview only sorts as defined in query
  • SQL seal allows sorting and filtering through its use of the AG grid (whatever that is)
  • Database folders and meta data I do believe also adds some sorting and filtering in their table views

So it all kind of come down to which tables are you talking about. And sadly dataview in its default form is the worst of the bunch, en though you could sort in the query. I’ve seen some add ons which do try to correct this somewhat.

Sorry, I should have been more specific. This is a pure markdown table.
How do I access the context menu in the android mobile/phone app? If I click in a column I get the on-screen keyboard and toolbar but I don’t see anything in the toolbar (or that can added to the toolbar) to sort tables.

It’s a little fiddly, but if you click in a column, you’ll get the “menu” icon on top of it, and if you press and hold on that icon, you’ll get the menu. It’s the menu for live preview editing of tables.

Not sure, if there’s a better way to get this menu.

That worked! Brilliant! Thank you!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.