Sort by Time column not working in List Collection

Report a Bug
1

Team ID:

  • ywgnmSFtyK3tbjrJCAiZ

App ID:
A2pUXoVH7aYCjReZo15W

Description
I have an app with List component. I’m trying to sort the data based on the Time column: Hora, that comes from a Glide table. This sorting is not working:

image
image1135×812 111 KB

image
image1151×796 109 KB

Neither on asc or desc.
image
image1153×748 99.9 KB

This sorting was working before in this component, but when I migrated the app data from Google Sheets to Glide Tables (and therefore rebuilt it) this stopped working.

image

How to replicate

  1. Create a list component from a Glide Table
  2. Have a Time Only without seconds column in the Glide table
  3. Try to sort the column by this field

Thanks for your help!

2

Can you go to the data view, click on some of the cells in the Hora column, and screenshot them for us?

My thinking is whilst you’re using “Time Only”, the underlying value still has a date, so that’s what it’s sorting.

1 Like
3

Sure @ThinhDinh , here are some screenshots:

image
image1587×82 13.4 KB

image

4

So you have the date in a column, and the hour in another? Is there a reason you don’t have the date/time combined in one? Not that it is the reason for the bug here, thought I may ask.

I would try to use a math column with the formula HOUR(T) with T being the “Hora” column, and sort by that column to see if it helps.

5

I have them separated because the form that I use for getting this info gets this values independently in 2 different moments.

I found the solution by sorting the values not in the list component, but in the page.

6

That sounds weird, can you elaborate more? Sorting on the page/tab level means you’re changing the row tied to the tab.

7

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