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

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.