hi guys…
im trying to make my own timeline there fits the needs i have. but i got a bit stuck now in how to get this to work. i understand the basic in how to make it… but there is just some details im stuck in now…
as you can see on this picture i want to make a timline with a data range there by default should be current date + 7 days and then change them with states afterwards… but im try to make the data type to “date” or “data range” and make a data source saying current date <--range--> current date days+7
but it wouldnt allow me to use that expression…
then next question… since my repeating group is for dates but i also want in front of it as showed in the picture above have a list of employee from my database… but since this repeating group is set to show horizontal it cant show the list of employees vertically also… so how do i make that to work… and how to i make it all work togehter so that when i drag a dragable element containing a task to a dropable element in the data repeating group it would assign to this employee listed…
hope that maked sense 
and hope someone out there can help me out
2 Likes
Data source cannot be date range, it can only be a list of dates. You could generate this list with the plugin List of Dates - it’s a very useful plugin.
In regards to your second query, you can achieve that with nested repeating groups.
What I would do is set up a main repeating group of data type Employee as rows. The second repeating group of data type Date would be nested withing the first repeating group as columns. And then I would have the third repeating group of data type Tasks nested within the second repeating group - where you could drag your tasks and assign employees to these tasks.
hi @dianabologabv
thank you for you answer that was helpfull with the nested group and i think i got that settled up.
i installed the List of Dates plugin now. but im unsure how i use it and get that to work… can you maybe help out with that also?
@dianabologabv
im getting somewhere now…
but i cant as mentioned above figure how to use the list of dates plugin so it will show a date line…
and also as you can see it shows the same tasks multiple times… can you maybe help me guding me in how, what and where i should put the expressions and witch expression to use?
This is an example of a list of 7 consecutive days. You can set up your interval and interval type as per your use case. For any other day of the week, the interval would be 2 and so on. If you need a list of weeks, interval type would be “week”.
Once you set this up, just filter the tasks on that specific day you need that task to be displayed.
@dianabologabv
Thank you for these screenshots… they helped alot
and im sorry im still fairly new in bubble…
i find the filter option… but cant figure what expression to use to filter them date wise… and also as you can see here… it doesnt make a dropable zone for each colum
That’s because you have 14 columns for dates and only 4 for tasks. Those tasks should be contained by the repeating group of data type date. Would you be able to share your editor so I can have a look at how you’ve set up the nested repeating groups?
its not set to a fixed amount of colums… that one is unticked
but yeah sure…
this is the repeating group for employess
and inside the employee repeating group headline in colum b i have a nested repeating group with dates
and then inside the employees repeating group row i have the task repeating group with dropable elements in
and as you also can see in the task repeating group there arent set a fixed number of colums in there
its like it only make a colum for the tasks if there is one assigned to the user… elsewise it doesnt display the colum
You’re almost there!
The reason why the tasks are not linked to the dates is that you have not nested the repeating group of data type Date within the User’s repeating group. Tasks will be then nested within the dates, so basically you’ll have 3 layers.
Leave the Dates header as is. In your User’s repeating group, create a hidden input with the content Current cell’s User’s unique id - you will be using this value later on.
Create a Repeating group of data type Date nested within the User’s repeating group. Set this group to 1 raw and dynamic columns. You’d need a hidden input here as well with initial content “current cell’s date”.
And finally nest your Tasks Repeating within The Dates Repeating group, set it up with 1 column and … 1 row (if you have only one task per user on one specific date) or dynamic rows (if you have more than 1 task per user in one specific day).
The constraint:
And finally, the advanced filter:
@dianabologabv
i have now followed all your steps and it still doesnt show the dropable elements there is in the task repeating group
i see you not mention anything about the data source for the date repeating gropu there is nested inside the users repeating group… shouldnt that reference to the list of dates or something? or what should i do with that one?
i have 2 repeating groups with dates now… just to clarify… one in the header there is the navigator for dates… and then one in the repeating row for the user repeating group
Input date should be part of Table Date and not table Tasks
yeaah… noticed that mistake right before you answer… but still do the same
like this right?
Yes, that’s fine. The header is for design purposes, to see the dates as header, we cannot use those dates in our repeating groups.
alright…
but how do i then get the task repeating group to show empty dropable elements for each date… and only display the text data in them if the current cells user have assigned a task to them for that specific date?
Like so:
The DropArea is part of the Date repeating group (with data source
current cell’s date). The Drag&Drop group is part of the Task repeating group.
