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 :)

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings