Making a timeline with dates and employees in a repeating group

christian_bargmann · 2025-02-17T04:45:47.079Z

image1920×413 74.5 KB

im getting closer now… it shows the task now when i drag a task to the timeline…
but there still is a few small things i cant figure out…

when i drag them they shows… but as soon as i update the page they dissapear again… but when i go into my database and see they are assigned and data for the task have changed
no matter what date i drag them to they show on every date cell as you can see on picture above… how do i make then only show for that specific date i drag them to… and also if there is multiple task for same day how do i show each of them on same date cell
my teks in the drag group is current cells task's coverted to list's workadress each item extract city split by (,)
so in my logic that should show multiple entries extracted city
when a assigned task is displayed is it then possible to hide the dropable group so that they shows in a straight line

dianabologabv · 2025-02-17T11:03:30.007Z

Before I advice further I would like to double check your drag&drop functionality.
When dragging a task over a new date cell, you want this change to be applied only to that specific user you’re dragging that task from … or you want this to be applied to all users?

christian_bargmann · 2025-02-17T11:16:00.771Z

image1920×413 74.5 KB

As you see on this picture, i have a list of all available task there isnt applied to a employee yet… they are all in a dragable group so i can drop them in the repeating groups dropable groups… my idea is that i should be able to assign a task to one employee at the time… on each employees timeline… but if its a task where 2 employees are needed i also should he able to drag it to 2 different employees timeline so the task will be displayed 2 Times but in each employees timeline row

dianabologabv · 2025-02-17T12:11:26.636Z

Ok, my understanding was that you’re building a drag/drop functionality within the same repeating group, or within nested repeating groups with data linking (where cells can be linked to each other.

But you have an external repeating group with a list of tasks, which you want to drag over to a different repeating group. This is not possible, not with the Draggable elements plugin.
There might be other plugins that help with that, for example Drag it - RG->RG paid plugin, but I have not used that one.

christian_bargmann · 2025-02-17T13:12:16.776Z

I dont want to drag it over… its set to bounce back again… but i want a workflow that when task dragable element is dropped on the dropable element it will assign the task in the dragable element to the user… and it seems i kinda got that you work yesterday…

Only issue now is that its not applied to a date and doesnt shows in the correct date cell that i dropped it to

dianabologabv · 2025-02-17T14:51:54.392Z

christian_bargmann:

when task dragable element is dropped on the dropable element it will assign the task in the dragable element to the user

That’s not how the Draggable elements plugin works. The plugin offers 1 functionality only, when a DropArea has a group dropped on it and a workflow is associated with this drop area, then the workflow will run.
The tasks you want to drag reside within an external repeating group. A repeating group draggable cell’s value cannot be accessed outside of the Repeating group it resides in (not by dragging it). We won’t know which task we’re dragging so we cannot assign that task.

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)