Sorting Split Date Range in a Repeating Group

I would like to sort a list of booked date ranges in a repeating group sorted as follows:

  • Split Start Date and End Date as separate dates
  • Sort by Date

Any help would be appreciated. thx.

I’m assuming that you have a calendar view where someone clicks on their start date and end date and then you are storing those as a date range (or maybe they are two drop downs)?

If true, why don’t you just create two more fields in your data type that are start date and end date and then when someone makes a booking, you populate those fields appropriately?

Thx for your reply paul29. I’m not really having a problem with splitting out a date range to display them separately in my repeating group. The issue is sorting them by booking start and end dates. Here is an example of what I am trying to accomplish:

The Green Flag represents the Start of a Booking and the Blue Flag represents the End of a Booking. They are sorted by Date in Descending order.

I am able to display the Start of a Booking and the End of a Booking, but I cannot Sort them to display by Date in Descending Order.

Sorry but I"m confused. At first you say they’re sorted by date in descending order but then you’re saying you cannot sort them by date in descending order.

Sorry. The first image and comment is what I’m trying to accomplish and is sorted by date in ascending order. The second image shows where I’m at in Bubble where I am unable to do so.

Yeah, it’s true that vanilla Bubble provides no facility for sorting date ranges, but you can do it with List Shifter. @gf_wolfer has a recent post where he describes in detail how to do this (and I couldn’t have written it better myself, so go have a look): New Plugin: TopCal - Dates, Ranges and Time Slots - #198 by gf_wolfer

(Also see my following note on how it’s not really perfect, but close enough for most applications.)

1 Like

Thx for your input. Yes, I’m aware of list shifter, but I don’t think it does what I need. I’m basically sorting 2 fields (Start Date, End Date), but trying to keep them sorted by Date in Descending Order.

Yes it does. If I appear in your thread, BTW, tremble in fear. I have such sights to show you.

1 Like

Good job you scared him off just from the thought of seeing your Floppy

1 Like

It’s like folks don’t realize that my open source plugins are powered by Satan. :man_shrugging:

This topic was automatically closed after 70 days. New replies are no longer allowed.