Very cool stuff. I hope to review it more after the holidays.
I'd love to see:
A zoom out button (shrink/increase timeline)
"You are here" or todays date vertical line slicing though tasks.
Thanks for the feedback!
Zooming can be done by adding repetitions to the repeating fields. Different views with different sets of repetitions could be added to other panels. It should be fairly trivial.
I'm not sure how to get a single line drawn for today's date that will also scale when a user expands their window. A graphic within that repetition might work.
Please note that the header is already formatted to display today's date in yellow and bold. The full height of the repeating field in the portal also has the formatting calculation, but it is not turned on. The width of the vertical line is probably larger than what some would want, however.
My biggest concern at this point is that each parent should summarize the percentages of children and grandchildren but not sub-summaries of grandchildren.
4 of 4 people found this helpful
This version is now multi-user friendly as it uses a global variable to drive the query for the chart and is populated upon OnRecordLoad.
Calculations in scripts and field definitions have been tweeked, the interface is a bit more informative and there is a 3 and 6 week view.
I'd love to see this visually work with a wider range of dates/longer duration projects. Reference: http://i.imgur.com/pDK85jX.png
Sadly I have not used repetitions in the past, so this has been challenging to essentially zoom out to 6 months, 1,2,3 years. I will keep experimenting, but maybe someone will master it in the future. Great work!!
2 of 2 people found this helpful
This gantt chart is very simple and has many limitations. The goal is to provide an easy alternative to more comprehensive and expensive solutions by more advanced developers.
This version has a slightly more simplified approach to data entry. Due date has been removed and any of the beginDate, endDate and Duration fields can be calculated from the other two.
A list view has been added.
Navigating the chart has more options and should be easier to use.
I have been asked to add views in excess of 365 days. The technique and calculations driving this chart will not scale well to larger date ranges.
For that, a completely different method will likely need to be employed.
If anyone has suggestions on other methods, now is the time to make them.
1 of 1 people found this helpful
Editing is easier in chart and list view.
Chart can now scroll to the beginning or end of a line item when selected.
Better error detection and parent-child synchronization.
Better error prevention with rollback when re-ordering portal.
Only summarizes progress and status to parent record when necessary.
Progress and status in portals and parent cannot be edited when parent is locked.
List portal summarizes line items with OnObjectExit trigger.
Puzzling this one since the arrival of FileMaker 16
works in in FileMaker 15
but does not work in FileMaker 16 you 'Jan0001
I do not have Filemaker 16 Advanced. I did use a trial of v.16 and confirmed the bug.
Without Advanced feature set I am having a problem debugging. Perhaps someone else may be able to help until I upgrade.
Sorry I cannot be of much help at this time.
I know the problem reason for that:
Evaluate ( "$$projectQueryDate[" & T06_A_Harmonogram::__HarmonogramIDPK & "]" )
Instead of putting full UUID code it cuts only last 18 numbers and that is why next script step is not able to set up $$projectQueryDate and without it whole gant is empty.
Same story with moving week forward and backward and also with sorting (The trigger is no longer triggered by dragging the record in portal).
I can let you in on my PC with full Filemaker 16 pro adv. and we can figure out how to solve it.
Just let me know on my E-mail email@example.com about comfortable date and time.
PS: I will post the result here if "kigmaker" allow me to.
Thanks for the help. I just got access to FMPA 16 on a pc.
There may be a bug in the evaluate function. It does indeed only read the last 18 digits.
I have replaced the following:
Evaluate ( "$$projectQueryDate[" & PROJECTS::id & "]" )
Evaluate ( "$$projectQueryDate[" & Right ( PROJECTS::id ; 18 ) & "]" )
Set Variable script step
"$$projectQueryDate" with Right ( PROJECTS::id ; 18 )
This does solve the problem, but also increases the chance of overwriting or referencing the wrong variable.
I can only suggest you contact the author of the Drag-Sort script.
Another user has contacted the author about the bug. More interest may help.
I will post elsewhere to see if there is a solution to the Evaluate issue.
Hello there Greg,
I have contected the author - and we sit togehter on the problem. It
appears only on windows with FM16 - on apple it works perfectly.
We need to wait for FM16 update
2017-07-09 7:45 GMT+02:00 kigmaker <firstname.lastname@example.org>:
Simple Hierarchical Gantt Chart for FMP v.13
reply from kigmaker
in Discussions - View the full discussion