I noticed a problem where some devices doesnt display the formatted date and time. this was when i used the Experimental Date Format column and put it on a template column. however, some devices only see it as ( - ) instead of (x - z). so i decided to change the approach with Math Column,
but now a second problem occured, my table collection grouping doesnt sort from A-Z. targeting my template column to the original Date & Time column does the same. so the Group Sorting only works when I use Experimental Date Format.
any idea whats going on?
Experimental Format Date doesn’t work consistently across devices, it’s been a problem for years so I don’t really recommend using it extensively.
Seeing that you have a Start Time column as basic, I would try still grouping by that but sort by the Start Time.
I recall a bug with a certain component that doesn’t sort correctly, maybe it’s this, but would suggest giving sorting by Start Time to see if it helps.
im doing this from a relation, so sorting through the Start Time would sort the inline list and not the grouping itself. im guessing a certain fix woould be retargeting the table source?
Wouldn’t the sort have to apply to groupings as well? If it’s not, it’s a bug imo.
I tried sorting back and forth, and it seems the problem lies not on the grouping, but the display order itself. I took out the grouping and sort the data though the Display Template Column, and the table order is still mixed, this happens both when I populate the Template Column with Experimental Date Format, or native Date & Time Column.
would this give a better sense to what the problem actually is? I reckon its a bug since everything used is native.
Here’s a test where I populate with Number and it works fine.
so the second its populated with Date & Time, it scrambles (tried Respect Time Zone too)
Display is an alpha-numeric column, so it’s going to sort alphabetically instead of numerically. Alphabetically, 1 comes before 7 regardless if it’s actually 11. If you want it to sort correctly, you need to sort by a numeric column.
I see, how would you recommend fixing the group sorting? I tried to sort the data through numeric column but it sorts only the inline list
To be clear, have you tried sorting by the Start Time column? I think that’s what @ThinhDinh suggested, but I can’t see that you tried it in your screenshots.
1 Like
yes i have, tested with:
- Experimental Date Format
- Native Date & Time
- Math Column (Hour)
all the options above - sort by descending nor ascending, doesn’t seem to change anything, output is as the pic below.
I mean sorting by this column, since Glide might see that as a number on the backend.
Is that what you tried for the “Native Date & Time” scenario?
1 Like
yess indeed thats what i tried
if you click on a cell in that starttime column, do you have different dates? Just because you set the format to date only doesn’t mean the underlying date isn’t still being factored in. I’m betting you have different dates in each cell.
I’m betting you also have issue with the math column because you are attaching :00 to a number which converts it to text. Try removing units from the math column so you have a pure numeric value instead of a number with characters appended to it. Then try sorting by the math column.
i set it to Time only
here is the underlying date if i format it to date and time
the math column supposed to look like this then right? tried removing the units then sorting through this but nothing seems to change… this is getting a bit weird so thank you for hanging around
How did you originally enter data into that column? Is it through a form?
no i manually populate it in the data editor
Is it possible to send a link to join your team in private messages and tell me where to navigate to get to the relevant screen? Thank you.
@Arrafi_Wardhana @Jeff_Hager
I believe this is a known bug with the Table component’s grouping.
This is that same table, not grouped, sorted by the start time.
When you do the Grouping, it sorts the groupings and ignore everything else, hence you see the "1"s first, then 6 and then 8.
1 Like
Unfortunately I believe this bug has been around for a long time and the team has not fixed it. I would suggest using another type of collection, perhaps.
1 Like
well that’s a bummer. thank you for resolving this
1 Like
