Page 1 of 1

Automatically sort list view form by date (descending)

Posted: Mon Apr 05, 2021 10:16 am
by Olikun
Hello,

a new question.

How can I set it up so that the list view of the form is automatically sorted.

I only have 1 line (date) in the list

I want the current date to be at the top.

I know I can sort the list manually with one click, but I want it to happen automatically.

Is that possible?


Image

Re: Automatically sort list view form by date (descending)

Posted: Mon Apr 05, 2021 10:23 am
by kev1n
Add an ORDER BY your_date_column DESC in the Browse SQL

Code: Select all

SELECT * FROM your_table ORDER BY your_date_column DESC

Re: Automatically sort list view form by date (descending)

Posted: Mon Apr 05, 2021 10:40 am
by Olikun
works perfect

thanks :D