Sorting multiple Databases chronologically in one view

This is similar to Dates End for sorting (multiple databases)
I have one Agenda list view and I want to see entities sorted in chronological order. Two of these databases have a Date range called Dates that is an integration field. The other two have a date range called dates that is a formula field.


Unfortunately the Dates Start and Dates End values don’t show up as an allowed global sorting field.

Is there some other way to work this out?

Curious. What happens if you add the sort to each db individually?

They sort in order within each database and stack on top of each other in the order of the databases in the screenshot :frowning:

Did some troubleshooting on why this wasn’t working.
3 of the databases have a date range without times in the “Dates” field
But the Google Calendar integration uses Datetimes for the “Dates” field in one of the databases (the one for not-all-day events).

I’ve added a feature request that can fix this Expose Default Time Values in Date Ranges for Sorting

You can create a formula field that converts the date time to just a date in order for this to work.

Might not be ideal if @helloitse wants to retain the time info to affect the sort order.

Yeah that’s the workaround here. But I’ve too many databases and interconnected views now for this to be simple. There’s technical debt in how I built out Fibery because this was unclear a year ago.

At some point I invested in creating Dates fields for all databases I want in this shared view but I also have Start Date fields and Start Time fields that overlap with other databases for different views than this one.

:face_with_head_bandage: Maybe Fibery AI can help. But I see this taking at least 2 hours.

1 Like