Gantt Chart

The Gantt Chart function allows you to manipulate Gantt Charts interactively, by dragging bars along the chart to move them to new positions, and resizing the bars by dragging either end, to change duration.


GanttChart( "startFieldName" ; "durationFieldName" ; "barColorFieldName" )


Parameters:

1 startFieldName Task Start Date field (must be Date type), enclosed in quotes.
2 durationFieldName Task Duration field, giving the number of days (must be Number type), enclosed in quotes. The field referred to should not be a calculation field.
3 barColorFieldName Task color field (Text type), enclosed in quotes. Use a blank parameter for colors to be chosen for you. See “Background Color” in the “Basics” section. The field referred to should not be a calculation field.


Example:


GanttChart(

“GanttChart Bars::Start” ; // task start date

“GanttChart Bars::Duration” ; // task duration

“GanttChart Bars::Color” // task color

)


The following shows the use of GetFieldName, and what is produced in Browse mode:

Layout Mode:

Browse Mode:


Field Definitions:



Important Notes

  • If field names are used, they must be enclosed in quotes and be the full Table Occurrence::FieldName form.
  • The start date and duration for the chart are not written into the function. In most cases the “home” table will be related to the Chart table by project, i.e. showing tasks for a specific project. If you want to filter tasks by period, you could perhaps create a “MonthYear” key and link it to the Chart with a multi-key approach.
  • The Gantt Chart requires the use of the zMODid field, and uses the relationship between the 'home' table and the 'appointment' table. You should read the Complex Controls page to understand the requirements for this feature.





Table of Contents