Create a timeline/gantt chart

Hello Bubble team,

I’m trying to work out the best way to display a list of users with the dates on which each person is unavailable (e.g., vacation periods). What’s the most effective approach to create this kind of schedule/availability chart? Can it be built with repeating groups, and if so, how would you handle the date ranges?

Please see the example below what im trying to build:

1 Like

Use a plugin? @tulioportela makes a good one.

4 Likes

Yes, I saw that plugin, thanks to @gerbertdelangen!
That said, I was more curious from a learning perspective: is it possible to build something like this natively in Bubble? I know the classic “anything is possible with Bubble” line :grinning_face_with_smiling_eyes: but if someone’s done it before and could share some insight, I’d really appreciate it!

1 Like

Many things that some plugins offer can be natively created with Bubble and its elements.

I believe that is not the case here. You will find a lot of hard work ahead when trying to replicate some features offered by plugins, like this one.

A lot of nested Repeating Groups, dozens of states to control sub-functionalities and store variables, dozens of workflows, probably some code snippets needed for some processing and most likely also the use of at least other free plugins for data intercommunication or processing. And I would say that even using all this you will find some limitations.

So, yeah, in some cases it is possible, but with a lot of effort.

I know that the price of some plugins may seem “heavy” at first. But understand that we do not pay for the complexity of the plugin, the amount of code involved or how many hours the creator spent creating it, in the end we pay for the solution it offers us and for saving us from “reinventing the wheel” or to save those who don’t have technical knowledge from having to deal with code.

2 Likes

THank you @Newed for the informative input! Very well put! :slight_smile: Will have a look at some plugins

1 Like

Sorry, @Orbit , I missed the point of your question. Yes, this sounds like a good challenge to learn more how Bubble works.

I would start with data types of Users (left column) and UserActivities (items on the timeline). Then it’s turtles :turtle: RGs all the way down

  • One vertical RG with all the Users
  • Then each row in that RG will have an RG for the dates. I don’t have off the top of my head a way – you can probably create a list from a date interval or a grouping of.
  • Then on the RG of the dates, you have to have a search for UserActivites where the cell’s date in between the UserActivity’s start and end dates. If there’s one, make that cell green.

Wise bubblers will tell you that this will hog all the WUs you can throw at it.

I think software engineers would use all sort of joins to make a table like this. Unfortunately – even though Bubble’s db is some SQL – we don’t have access to joins.

3 Likes

no worries, thanks Rico for taking the time to explain, i will test out @tulioportela plugin which looks like it will do exactly what im trying to accomplish so fingers crossed :slight_smile:

1 Like

What an honor, prof! :saluting_face:
I’m so happy to have remembered and recommended you.
Orbit sent a message talk to me that very day.

You’re awesome, thanks for the encouragement!, master! :martial_arts_uniform:

2 Likes

Aulas, cria…
Tô anotando tudo. :nerd_face:

:brain: