Core FileMaker Blog

Keep up to date with CoreSolutions

Update: Gantt Charts In FileMaker

Nearly 3 years ago, Kevin McGee wrote a blog post entitled How to: Gantt Charts in FileMaker. Since then, we’ve had a lot of interest in native Filemaker Gantt charts. Today I would like to show you a sample file with a very simple Gantt chart, and explain some of the basic principles involved.

Download the sample file:
FP7 (Filemaker 11)
FMP12 (Filemaker 12) (Download the unlocked version of the Gantt Chart Solution at the bottom of the page)

Here is what the chart looks like in FileMaker 11:

gantt

This example uses no container fields and no external code. The entire chart is displayed using conditional formatting on top of repeating fields.

The chart’s date range is driven by a single global date field. This field (called zv__startDate__gd) seen in a merge field at the top left, determines the starting date of the chart. There is then a repeating global date field (zc__date__rgd) used to get each day in the chart based on that starting date. In this example, I have set the number of repetitions to 40, however this can be changed to any number.

Extend(zv__startDate__gd) + Get(CalculationRepetitionNumber) – 1

The dates displayed at the top of the chart are based on this field. A second repeating field in the Task table is used to determine if the current date of the chart falls within the start and end dates of the Task

Let([current_date = Extend(zv__startDate__gd) + Get ( CalculationRepetitionNumber )];If(current_date > Extend(startDate) and current_date < Extend(endDate) + 2; Extend(colour)))

This field sets the value of each repetition that falls within the date range to the value of the colour field. This simply prints the colour as text inside the repeating field, however once we apply some conditional formatting we can change that to fill the entire cell with the correct colour.

gantt conditional formatting

Lastly, to make the chart look a little cleaner we will need an empty repeating field to sit behind everything else and provide the styling for the background of the report. In this example, we have borders to display vertical lines down the layout denoting each day, we also have conditional formatting to make the weekends grey and the current day yellow.

GetRepetition (Task::zc__date__rgd ;Get ( CalculationRepetitionNumber )) = Get ( CurrentDate )
Let([day_name = DayName(GetRepetition ( Task::zc__date__rgd ;Get ( CalculationRepetitionNumber )))];day_name = “Sunday”orday_name = “Saturday”)

These are the basic principals used in this simple Gantt chart example. If you are looking to make your own Gantt chart, I hope that you will find at least some of this article helpful. If you have any questions or comments feel free to leave them in the section below.

Update: Thank you to everyone who has contacted me about this article. If you’re interested in getting more information or an unlocked copy of the sample files please contact me by email or leave a comment below.

Update 2: I've gotten so much positive feedback from this article, thank you to everyone who has contacted me or posted a comment. Please note that we try to get in touch with everyone who makes a comment on this article privately by email as soon as we can.

Update 3: Wow, over 100 Comments! Thanks to everyone who has continued to comment and share this article. We have created a new page that will make downloading the FileMaker solution easier. Please visit our new page if you would like to download an unlocked version of the Gantt Chart Solution.

Leave a comment

104 comments

  • Michael Schmidt
    Michael Schmidt 02 December 2015 Report

    Very nice. I would be interested in an unlock copy if this is still something you provide. Great job and thanks in advance!

    Comment Link

  • Ryan T.
    Ryan T. 24 November 2015 Report

    I too would appreciate an unlocked version. I intend to integrate within my FM app for development!

    Comment Link

  • Felix
    Felix 28 September 2015 Report

    Thank you for the great sample. Would also love to get my hands on an unlocked sample of the fmp12 file. Thank you

    Comment Link

  • Chris Andersson
    Chris Andersson 27 September 2015 Report

    That is very cool! Would also love to get my hands on an unlocked sample of the fmp12 file.
    Thank you,

    Comment Link

  • Caleb
    Caleb 22 September 2015 Report

    If you're still sharing, can I get an unlocked version of FM12? Thanks for the sample!

    Comment Link

  • dylz
    dylz 10 September 2015 Report

    looks great!! would i be able to grab an unlocked version (12) ? thanks!!

    Comment Link

  • jp
    jp 09 September 2015 Report

    Your work is great ! Is possible to get an unlocked copy of your file ? thanks, JP

    Comment Link

  • glenn
    glenn 04 September 2015 Report

    i've been making Gantt Charts in excel but would like to do the same in FileMaker. please share an unlocked copy so i can see the particulars. thanks.

    Comment Link

  • Alan D
    Alan D 10 August 2015 Report

    This is a powerful technique to have in your toolbelt. I would like to get an unlocked copy so I can see it for myself. Thanks, Alan

    Comment Link

  • Michael Schwarz
    Michael Schwarz 23 July 2015 Report

    I am working on an internal system and would love to be able to decipher how this Gantt chart was constructed.

    Would be wonderful to get an unlocked copy of the FM12 version.

    Thanks!

    Comment Link

  • Melanie
    Melanie 21 July 2015 Report

    Can I please get an unlocked copy of the FM12 version? Thanks!

    Comment Link

  • Bertil Larsson
    Bertil Larsson 13 July 2015 Report

    Hi! I think this gantt chart look nice, and i would like to have an unlocked copy of it to work with.

    Comment Link

  • peter newland
    peter newland 04 July 2015 Report

    I would greatly appreciate an unlocked copy, if you would be so kind.

    Comment Link

  • Chris Van Buren
    Chris Van Buren 22 June 2015 Report

    Can I get an unlocked version? Thanks.

    Comment Link

  • judy
    judy 15 June 2015 Report

    Can I please get an unlocked copy of the FM12 solution?
    Thanks!

    Comment Link

  • Layne
    Layne 12 June 2015 Report

    Is it possible to get a unlocked copy?

    Comment Link

  • Gord
    Gord 04 June 2015 Report

    Hey! Great Article!
    I would love an unlocked solution if possible.
    Thanks a lot!

    Comment Link

  • Victor MOREIRA
    Victor MOREIRA 23 May 2015 Report

    Hello, very clever solution. I'm interested in the unlocked version. Thanks in advance.

    Comment Link

  • Giorgio
    Giorgio 22 May 2015 Report

    Can you please share the unlocked copy for fmp12. Thank you so much.

    Comment Link

  • thong
    thong 21 May 2015 Report

    Nicely done! Can you please share the unlocked copy for fp7.

    Thank you so much.

    Comment Link

  • David
    David 16 May 2015 Report

    Looks like what I've been searching for. I would be very interested in an unlocked copy. Thank you in advance, -d

    Comment Link

  • Steve Rosendahl
    Steve Rosendahl 04 May 2015 Report

    This is great been trying for years to figure this out.
    Have been trying with stacked bar charts.
    requesting an unlocked copy
    Thanks
    Steve

    Comment Link

  • peter
    peter 23 April 2015 Report

    Very interesting solution. Can you please provide me with the username and password or an unlocked copy. I like to see how its build. Thank you.

    Comment Link

  • Mike S
    Mike S 22 April 2015 Report

    This is just what I need. I want to deconstruct this and learn how to do it myself. Can I get an unlocked copy for FM12? Thanks!

    Comment Link

  • FABIAN ALVARADO
    FABIAN ALVARADO 20 April 2015 Report

    very good greetings from chile.
    please have an unlocked copy for FM11
    regards
    fabian.

    Comment Link

  • Richard
    Richard 15 April 2015 Report

    This is just what I need. I want to deconstruct this and learn how to do it myself. Can I get an unlocked copy for FM12? Thanks!

    Comment Link

  • Michael Mesches
    Michael Mesches 03 April 2015 Report

    This is just what I was looking for. Can I get an unlocked copy for both FM11 and FM12? Thanks.

    Comment Link

  • Tommy Andersen
    Tommy Andersen 27 March 2015 Report

    Great work! Very interesting! Please, send me an unlocked version for FM12/13.

    Comment Link

  • Tom Lewis
    Tom Lewis 16 March 2015 Report

    This is exactly what I have been looking for. Can I please have an unlocked copy for FM12?

    Comment Link

  • roberto
    roberto 14 March 2015 Report

    Hello,
    the tool looks great! I thought a lot about creating my won native Filemaker Gantt chart but could never end up with something usable. Is it possible to have an unlocked solution?
    Thank you very much.

    Comment Link

  • Per
    Per 26 December 2013 Report

    I would really appreciate an unlocked version if possible. Thanks.

    Comment Link

  • brad
    brad 19 December 2013 Report

    I'd love to get an unlocked copy - are you still sharing it?

    Comment Link

  • Ben
    Ben 19 December 2013 Report

    I would appreciate an unlocked version.

    Comment Link

  • Rob
    Rob 05 December 2013 Report

    Hi Evan.

    Would it be possible to get a FM11 unlocked copy of this. This is exactly what I have been looking for to implement in our project management DB.

    Regards,

    Rob

    Comment Link

  • Guido
    Guido 05 December 2013 Report

    Hi Evan,

    ...... I need it!

    Would it be possible to have an unlocked copy?

    Best Regards,

    Guido

    Comment Link

  • Max
    Max 19 November 2013 Report

    Hi Evan,

    This is exactly what I've been looking for to implement in my rental management DB!

    Would it be possible to have an unlocked copy?

    Regards,
    Max

    Comment Link

  • John Farrell
    John Farrell 16 November 2013 Report

    Hi Evan
    Would welcome an unlocked copy fmp12 version thank you. Will be useful for a hire item project.
    Cheers
    John

    Comment Link

  • Glenn P
    Glenn P 14 November 2013 Report

    Look very nice, is it possible to receive a unlock version?

    Thanks in advance.

    Greetings from Denmark.

    /Glenn P.

    Comment Link

  • Roberto
    Roberto 10 November 2013 Report

    A Gantt Chart will be of great help in business time management .

    Comment Link

  • Mark Anthony Siason
    Mark Anthony Siason 02 November 2013 Report

    Hi, would you be able to share an unlocked copy? I am working on a task management project and this would be very helpful.

    Comment Link

  • Nancy
    Nancy 30 October 2013 Report

    Could you share an unlocked copy with me?

    Comment Link

  • Yusuf
    Yusuf 18 October 2013 Report

    I really like your solution. Simple looking and seem flexible enough to be adapted and customised to one's need. This is exactly what I am looking for to visualize our internal Product Roadmap development tool I am working on. Would it be possible to get an unlock version of it and source code.

    Comment Link

  • Basil Pio
    Basil Pio 28 September 2013 Report

    Nice! Would like to see it in more detail. Is it possible to take a look under the hood? Thanks

    Comment Link

  • David
    David 27 September 2013 Report

    This looks just like the sort of thing I've been searching for. Any chance of an unlocked copy (FP7)?
    Cheers.

    Comment Link

  • Brian
    Brian 27 September 2013 Report

    I would also be interested in an unlocked copy. Many thanks in advance.

    Comment Link

  • Gunasekaran
    Gunasekaran 22 September 2013 Report

    This is a great move. A Gantt Chart becomes a relaly useful project management tool if it can track resourcing (otherwise it is simply a chronological chart which has to be used with other tools and that becomes cumbersome).However, what I would relaly like to see is the ability to assign a percentage of a resource to a task. What will follow is plot of resource against time from which can be seen relaly useful things such as; John is relaly overloaded here that's never going to work ; Engineering effort starts winding down to one person in Q2 next year ; We will obviously need another programmer starting in January etc. etc.

    Comment Link

  • Maureen
    Maureen 19 September 2013 Report

    Hello, I am interested in an unlocked copy. Thank you. :)

    Comment Link

  • Update: Gantt Charts In Filemaker | Filemaker |...
    Update: Gantt Charts In Filemaker | Filemaker |... 13 September 2013 Report

    Nearly 3 years ago, Kevin McGee wrote a blog post entitled How to: Gantt Charts in FileMaker. Since then, we’ve had a lot of interest in native Filemaker gantt charts. Today I would like to show you a sample file with a very simple gantt chart, and explain some of the basic principles involved.Download the sample file: FP7 (Filemaker 11) FMP12 (Filemaker 12) 

    Comment Link

  • Domingo Ugarte
    Domingo Ugarte 12 September 2013 Report

    Was wondering if I could use your FMP12 Gantt file to get ideas to implement a Gantt chart for my time clock system. Very similar but in hours not days (12am - 12pm)

    Thank you in advance

    Comment Link

  • Update: Gantt Charts In Filemaker | Filemaker Info
CoreSolutions Logo

London Office:
1-1615 N Routledge Park
London, ON N6H 5L6

Toronto Office:
2425 Matheson Blvd East
7th Floor
Mississauga, ON L4W 5K4

Toll Free: (800) 650-8882
London: (519) 641-7727
Toronto: (416) 410-8649
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

SUBSCRIBE

Click the 'Subscribe' button to sign up for news & software tips.

Beyond Software

Copyright © 2018 CoreSolutions Software, Inc. All Rights Reserved