SeedCodeCalendar12

Gantt Chart-Sorting

SeedCodeCalendar12.GanttChart-Sorting History

Hide minor edits - Show changes to output

May 20, 2012, at 03:31 AM by 50.132.84.245 -
Changed lines 3-10 from:
''The gantt chart was introduced in version 5.6 of the Pro Calendar.''

Just as there is a single script for sorting your calendar records, there is a separate script for sorting the gantt records. You'll need to edit this script as part of pasting the calendar into your file, making sure it is sorting by the fields in your tables.

The script is "Sort FileMaker Records for Gantt Chart --- Edit Sort Orders Here --- " and instructions for editing the script are found in the scripts comments.

A
few things to keep in mind...
to:
Like the calendar records, the gantt chart items are sorted towards the end of the script "Cast Events as Variables - Build Query". There you'll see three sets of script steps sorting a) the regular (non-gantt) calendar, b) the gantt chart when sorted by date, and c) the gantt chart sorted by project.

You probably won't want to change any of these three sorts as the calendar display, and the hierarchical nature of the gantt chart (showing events beneath their projects) depends on it.

But if you do want to change the last of these, the gantt-as-project sort, here are a
few things to keep in mind...
Added lines 11-12:
-> You can only sort by fields that are used in the SQL query earlier in the script. Fields are referenced by the order they appear in the query, so sorting by "6', means the sixth field returned: the Project ID.
Added lines 1-17:
!! How are records on the Gantt Chart Sorted

''The gantt chart was introduced in version 5.6 of the Pro Calendar.''

Just as there is a single script for sorting your calendar records, there is a separate script for sorting the gantt records. You'll need to edit this script as part of pasting the calendar into your file, making sure it is sorting by the fields in your tables.

The script is "Sort FileMaker Records for Gantt Chart --- Edit Sort Orders Here --- " and instructions for editing the script are found in the scripts comments.

A few things to keep in mind...

-> The gantt chart sorts each time an edit is made using drag and drop.

-> The field z_MilestoneSort in the events table can be used to specify in which order events appear in the gantt chart. When this field is blank, events are shown in chronological order from first to last.

-> When there are values in  z_MilestoneSort, events within a project or phase are shown in the order of the numbers in this field. (You'd number your events 1, 2, etc. Decimals are respected.) In this way you can have events start, lower down on the chart, before events in the upper part of the chart. This is essential for most complex projects.

-> You'll find this z_MilestoneSort field shown at the left edge of the events portal on our Sample Projects layout.
(855) SEEDCODE
[email protected]
Follow us: