HTML Template Start Expression - Google Chart - Page 2

Grant_Stead · 08-11-2020 02:55 PM

@Phil I know this is kinda your baby…
Having issues getting a start expression to run… (Or maybe it’s something else…) I’m trying to webhook this google gantt chart html to a service that converts HTML to images… It works great with static HTML, and I was able to get it dynamic with the default date, but I can’t get the records…

<html>
<head>
  <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
  <script type="text/javascript">
    google.charts.load('current', {'packages':['gantt']});
    google.charts.setOnLoadCallback(drawChart);

    function drawChart() {

      var otherData = new google.visualization.DataTable();
      otherData.addColumn('string', 'Task ID');
      otherData.addColumn('string', 'Task Name');
      otherData.addColumn('string', 'Resource');
      otherData.addColumn('date', 'Start');
      otherData.addColumn('date', 'End');
      otherData.addColumn('number', 'Duration');
      otherData.addColumn('number', 'Percent Complete');
      otherData.addColumn('string', 'Dependencies');

      otherData.addRows([
        &lt;&lt;START: [VC_Task_Children]&gt;&gt;['&lt;&lt;[task_key]&gt;&gt;', '&lt;&lt;[task_key]&gt;&gt;', null, null, null, &lt;&lt;[VC_ms]&gt;&gt;, 50, null],&lt;&lt;End&gt;&gt;

      ]);

      var options = {
        height: 300,
        gantt: {
          defaultStartDateMillis: new Date(&lt;&lt;YEAR([task_mandatory_start])&gt;&gt;, &lt;&lt;MONTH([task_mandatory_start])&gt;&gt;, &lt;&lt;DAY([task_mandatory_start])&gt;&gt;)
        }
      };

      var chart = new google.visualization.Gantt(document.getElementById('chart_div'));

      chart.draw(otherData, options);
    }
  </script>
</head>
<body>
  <div id="chart_div"></div>
</body>
</html>