Making a timeline with dates and employees in a repeating group

christian_bargmann · 2025-02-17T15:08:50.994Z

hmm…
i maked a test task to show you how it works now…

image1920×712 119 KB

here you see that task in right side

image1920×480 75.8 KB

and here i have it dragged with all the tasks information in it

image481×580 8.75 KB

and as you see it actually have changed information for that specific task now status goes from not planned to planned(ikke planlagt to planlagt)

image2804×439 11.2 KB

and it also gets assigned a date in task date… but the date is the first date in my list of dates and not the one that i drop it on… and also it doesnt assign the user to it…

dianabologabv · 2025-02-17T15:27:14.393Z

What’s the workflow action for DropArea has a group dropped on it?

christian_bargmann · 2025-02-17T15:28:37.496Z

image882×368 5.42 KB

image936×510 7.6 KB

image974×457 7.17 KB

dianabologabv · 2025-02-17T15:46:47.434Z

What’s your current workflow task? Is your drag/drop set to display one single task across all 12 columns?
And is that task “Test task for dragable groups”?

dianabologabv · 2025-02-17T15:54:39.878Z

dianabologabv:

Is your drag/drop set to display one single task across all 12 columns?

The drag /drop inside your nested repeating groups I mean. But now it can be any group really (doesn’t have to be a drag/drop) since you’re not dragging inside that Nested RG

christian_bargmann · 2025-02-17T15:57:42.612Z

current workflows task is the event there type of thing is set to task as you see in the first picture…
the drag element only contains one single task… and then there is a dragable elemet for each task as you see here:

image474×759 12.1 KB

so every unassigned task will be listed over there with each theres dragable group…

in the timeline the dragable element should be able to contain multiple task for each day… so therefor its set to display current colums task converted to list's workadress extract city: split by (,)
as you can see here:

image670×331 5.7 KB

but… the task should only be displayed if they are assigned to a user… so assigned task=table user’s current rows user…
but i cant use that expression because the task table is nested in a date table… so can only use the expression current colums date

dianabologabv · 2025-02-17T16:01:06.045Z

Is this the data source for your drag/drop in your nested repeating group?

christian_bargmann · 2025-02-17T16:04:24.978Z

it is the expression for the text element in my drag on drop… telling what data of the assigned task there should be displayed… in my case i only want the city of the task workadress to be displayed… and then i will make a workflow that when a task contains a workadress set a marker on the map… and in that way it will make a route with all task for the day per employee

dianabologabv · 2025-02-17T16:28:44.474Z

That data source expression pulls the first task in your task list - across all users and all dates. When an element is dropped on a DropArea, and it can be any element really, we could even drop an elephant (joking) - then your workflow will run for that first task, that task’s data will be changed - regardless of what task you’re actually dropping on it.
So, you can only change 1 task and the external repeating group has to include that exact same task.

But that’s not what you want, what you actually want is to modify any task that task you are dragging from your external repeating group positioned on the top right side of the page.
As said, this is not possible with this plugin.

christian_bargmann · 2025-02-17T16:28:46.013Z

oh the picture was slow to load…
thought you meant the text element…

but no… i was just trying something to see what would happen…

image630×405 4.89 KB

this is my data source

christian_bargmann · 2025-02-17T16:44:22.973Z

no i only want to modify 1 task at the time… that single one that im dragging… when that one is dragged and dropped on the dropzone… that task should me modified… that part works already now… so we dont need to think more on that… Task gets modified!..

now when i drag that one task to the dropable element i need an action where the dragged task gets added to a list of a user…
thing to modify: table users current row user

image652×252 3.83 KB

field to modify is “assigned task” add drop area task

now current rows user have a task assigned to them because that task is on the list “assigned task”

now what i want to display in that nested repeating group is current user each item assigned task… but i want them to be displayed in input date (as we maked earlier) value…

right now i have succeding get them to be displayed as you can see here:

image1920×512 88.1 KB

but they show every task there is assigned for every date field… so right now there is displayed 2 task because there is assigned 2 task to the user… but both task are duplicated in each field…

so how i understand you what you say is not possible i already have maked possible… now its just a matter of how current rows user’ assigned task is displayed

dianabologabv · 2025-02-17T19:05:15.469Z

Ok, got it, sorry I’m just tired today, was thinking about completely something else.
There are 2 steps remaining. Saving the date and the users in your tasks data type, right?
Checking your previous screenshots I see that the start date in your List of dates plugin is set as Current date/time. This date will update every time you load the page with the Current date/time in real time at the time. When you save the date into your database it gets saved as a static date. So the date in your repeating group won’t match the date in your database. Just set the start date in your List of Dates to Current date/time:rounded down to day.

dianabologabv · 2025-02-17T19:10:09.396Z

To be able to assign the user to your Task, use a dropdown instead of an input and reference your Parent repeating group Users as choices source, to avoid performing a search again.

image413×540 23.2 KB

christian_bargmann · 2025-02-18T03:40:29.447Z

we are getting very close now

image567×165 3.06 KB

so now the user gets assigned when drag and drop… but it still doesnt assign the task to only be displayed at task date’s date… but in every list of dates…

and i see that the list of assigned task for the user is showed individual in each group… is it maybe possible to get the showed in one group but split by a comma for instance…

the end result i want to look kinda like this:

(this is not my platform… just inspiration from somewhere else)

dianabologabv · 2025-02-18T06:45:48.565Z

christian_bargmann:

so now the user gets assigned when drag and drop… but it still doesnt assign the task to only be displayed at task date’s date… but in every list of dates…

Did you filter your nested Tasks repeating group on Input date? Also, since you’re using a dropdown for the users, you won’t need client side filtering.
Use these constraints plus any other filters you might need, eg status.

image858×306 22.5 KB

dianabologabv · 2025-02-18T06:59:52.534Z

christian_bargmann:

and i see that the list of assigned task for the user is showed individual in each group… is it maybe possible to get the showed in one group but split by a comma for instance…

Not really since you are not displaying a list value from a data field. There might be a workaround, if you’re planning to assign a fixed number of tasks per user. Eg, 3 tasks maximum, etc.
However from a UI/UX point of view I would leave the tasks stacked on top of each other with that repeating group’s cell/group set to dynamic height. This way the user can easily see all tasks at a glance without having to scroll.

christian_bargmann · 2025-02-18T07:44:44.467Z

Nope i didnt… so that part works now

christian_bargmann · 2025-02-18T07:52:35.761Z

Hmm… but “assigned task” data field is a list of task… thats why i dont understand it doesnt work…
I tried to make some setup change this morning… and now i actually get a almost perfect result…

I removed the task repeating group because it actually not needed and instead moved my drag and drop group inside the dropable element (i can send a screenshot later when im back hole from work)

And my datasource in drag and drop group is search for user each items assigned task first item
And in search of user i search for unique id =input users value

That seems to work out really good…
Now only issue is that it only display “first item” how do we get it to show each item

dianabologabv · 2025-02-18T09:11:31.341Z

That’s because you are displaying the first task in your user’s task list, as per your drag/drop group data source.
You do need a repeating group to display a list of items and not just the first item. Searching for a list of tasks or a list of users:each item tasks will result in the same layout, tasks/user’s list of tasks will be displayed on separate rows/columns.

So, use either of the 2 RG searches and if you really want to display the tasks as list, apply the below condition to you Text Current column’s Task.

image796×539 48.8 KB

image418×319 14.1 KB

christian_bargmann · 2025-02-18T18:23:40.406Z

dianabologabv:

Searching for a list of tasks or a list of users:each item tasks will result in the same layout, tasks/user’s list of tasks will be displayed on separate rows/columns.

Hmm… when i have used list of task i experienced that it couldnt figure out what task it should search for… thats why i used search for users task and a constraint to users unique id=indput user

If i only chose list of task it finds every employees task and not only the specific employees task…

But ill try that setup in a bit and tell if that works