Any tips on how to construct a URL for a Gantt chart shown on this web page?
I expect I need to create a JSON Object with all the values. That’s OK, but how do I go from the JSON object to the short URL that points to an image I can display in Glide?
Thanks for any tips,
Simon.
The url is not going to be short. With quickchart your formulate the entire url, including the JSON structure, and that url is the image. Your link above is a shortcut to the sandbox, but when you build the url, it would be something like this.
https://quickchart.io/chart?c={
type: 'horizontalBar',
data: {
labels: ['Part 1', 'Part 2', 'Part 3', 'Part 4', 'Part 5', 'Part 6'],
datasets: [{
data: [
[new Date('2021-02-01'), new Date('2021-05-01')],
[new Date('2021-05-10'), new Date('2021-07-01')],
[new Date('2021-04-20'), new Date('2021-11-31')],
[new Date('2021-08-01'), new Date('2021-09-01')],
[new Date('2021-02-10'), new Date('2021-07-01')],
[new Date('2021-07-20'), new Date('2021-11-31')],
],
backgroundColor: ['rgb(255, 99, 132, 1.0)', 'rgba(255, 99, 132, 1.0)', 'rgba(255, 206, 86, 1.0)', 'rgba(255, 206, 86, 1.0)', 'rgba(255, 206, 86, 0.2)', undefined],
}, ],
},
options: {
legend: {
display: false
},
annotation: {
annotations: [{
type: 'line',
mode: 'vertical',
scaleID: 'x-axis-0',
value: new Date('2021-10-30'),
borderColor: 'red',
borderWidth: 1,
label: {
enabled: true,
content: 'Deadline',
position: 'top'
}
}]
},
scales: {
xAxes: [{
position: 'top',
type: 'time',
time: {
unit: 'month'
},
ticks: {
min: new Date('2021-01-01'),
max: new Date('2022-01-01'),
}
}],
},
},
}
Thanks Jeff…
Is there any chance you can screen record the columns needed to:
I’m not sure how to go from the JSON object to being able to stitch it together. Do I need to use a JSON Template to convert it into a text like column first?
Personally I’ve just used template columns, which would be easier in this case. Take the url above, replace any dynamic data with template replacement values, such a {{labels}}, {{dates}}, {{colors}}, etc. Then you can usually feed other templates, joined lists, etc into that template column.
I’m sure you could probably do the same with the JSON columns, but I feel there are too many intricacies in the JSON data structure, meaning it’s probably just as easy to use a template column. I haven’t done anything real extravagant, but this is a simple chart that I have in one of my apps. In my case I feed the template with a few joined list columns. Mine is simple, but your joined lists might require joining values from another template column to get the formatting right, especially for the gantt dates.
Thanks that helps. I was tripping over the need to work with a JSON Object. I will take your advice and workaround…
Thanks so much!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
