Title
Milestones on Gantt Chart
Post
I have a Gantt chart to show project timelines. It uses the method shown here:
http://coresolutions.ca/update-gantt-charts-in-filemaker#codesyntax_4
Each line is a repeating field with conditional formatting (see the screen shots), based off of one global field (STARTDATE), and is based on a table called "Projects". This is all working well. However, each project can have one or more milestones (from a child table called "Milestones"). Each Milestone has a date, a type (i.e. "call", "demo due", "final due", and "other"), and a field for more details. What I'm trying to do is overlay another repeating field to show milestones so that for each related milestone, if the date in the particular gantt square matches the milestone date, show a letter or icon depending on what the type is (e.g. "C" for "call", "D" for "demo due", etc.). The formula below works for just the first child, but I'm not sure if this can be modified to include all the children, or I need something different. And, it does not look at the milestone type:
Let ( [
currentDate = Extend ( STARTDATE ) + Get (CalculationRepetitionNumber ) - 1;
];
Case ( currentDate = Extend ( Milestones » Projects::milestoneDate );
"•"
)
)
Basically, I want to see (where "-" are blank squares):
- - - - - C - - - - - D - - F - - - - - - - - - -
Is this possible?
Thanks,
Michael
I think you'll need to not use a repeating field for the milestones. Instead, try overlaying the repeating field with one row portals to the related data.