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.
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.