Reverse Column List

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! :honeybee: :slight_smile:

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

2 Likes

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