Home > Forum > Forms > Gantt chart in a process

Gantt chart in a process
0

Hello,
Do you know the possibility how to place a gantt chart in a process that was not created as a "Vacation" by template?
I have columns: "person", "date from" and "date to"

MVP

Hi Damian,

the last time I asked, I think it was in 2019, there was no intention for providing such an option out of the box.

One option would be to use a free JS gantt library like:

https://github.com/frappe/gantt

Here you would need to provide the gantt data as a JSON.
You would need to prepare the data. I not sure if it's stored in a item list, or other workflows. If it's stored in other worklfows you could probably prepare it using a business rule.


I'm not sure whether you could use an html field or would need to create a form field JS extension.

Best regards,
Daniel

MVP

Hello,

I used Google Charts to achieve this - https://developers.google.com/chart/interactive/docs/gallery/ganttchart

As Daniel said, you need to provide data as JSON, and to do that i created simple Web app that returns data based on SQL view.
Note that there might be some security issues with this approach - in my case, BPS is avaliable from internal network only, and served data are not sensitive - also my response is based on requested element GUID. Final step was to embed it in form - iframe in HTML field works like a charm :)