Is there a way to automatically (on start) reverse the order of the rows that are being returned in the Column List block? So the new entries (rows) are on top.
Hi @Vikt-a19d,
Welcome to the community!
With the ORDER BY operator, you can set up a list to display data in an ascending or descending order by a particular column.
For your use case, you can add a column that stores a time stamp of each entry and then order a list by that column. Here's how you would set it up:
In your table, add a column to store when an entry was submitted:
Then on the form submit button in the "add a row" action of the automation, write the value of NOW() to the column of the newly added row:
Now create a list, and in the properties of the list on the screen under the data tab, write a Filter formula that uses ORDER BY to sort by the time the entries were submitted.
It would look something like this:
=FILTER(Entries, "ORDER BY Entries[Time Submitted] DESC")
Now you have a list that displays the most recent entries first:
Hope this helps! Let us know if you have any other questions.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.