Hi! I want to sort the table according a date field. But many rows have the same date, exactly the same date (and time).
Does anyone know which criteria or method uses Glide to sort after?
I appreciate your support!
What’s your second criteria for sorting? Do you know which column you want to use for that secondary sorting?
I would like to know which second criteria uses Glide to sort in case the first criteria is exactly the same? Second criteria could be a Company name in a text field.
By default it’s probably going to sort by table order after sorting by date. If you want to sort by Date and Company, I would create template column that contains both. But since this will convert the whole thing into text, your date will need to be in a format that can be sorted alphanumericly instead of by date.
First you’ll need a math column to convert the date into a number, like this:
Year(Date)*10^10
+ Month(Date)*10^8
+ Day(Date)*10^6
+ Hour(Date)*10^4
+ Minute(Date)*10^2
+ Second(Date)
Then create a template column that joins the math column and the company column together. Then you can sort by the template column.
2 Likes
Thank you @Jeff_Hager.
I appreciate your help. 
1 Like