Automatically sort table connected to database

[dilum-coppens]

I created a database and succesfully linked it to a table on one of my pages, showing the data that I want (a list of artworks).

However, I want to table to automatically sort on the column “no”, but I can’t find how to do it.
Apprently, setting sorting functions in your live and sandbox database doesn’t transfer over to tables. I read up on coding, but it sounds all rather complicated and I’m getting confused.

To clarify: I want the column ‘No.’ to sort from The highest number to the lowest number.

Could someone help me? The name of the database is “Works” and the table is “table1”.

[elizabethjhay]

Try going to manage dataset. Scroll all the way to the bottom. Find sort. Sort the No field by A-Z

[dilum-coppens]

Ow, I found it. Thanks. The icon I didn’t know the use for “Works database” had the option. Thanks ^^