AnsweredAssumed Answered

Dashboard Layout that displays linked counts

Question asked by jmc01 on May 13, 2012
Latest reply on May 14, 2012 by Stephen Huston

I'm new to Filemaker - about to create my first application using Filemaker Pro Advanced 11. However, I've been using MSAccess since the first version came out (and other programs/languages as well).


I'm designing a workflow database application that will track customers, quotes, job requests, jobs, and stock. I will want to create a "Dashboard" layout that will be the opening screen and will display key actionable information on the screen. Some examples of the counts that will be on the screen:


- # of Quotes waiting for customer approval (count of records in Quotes table where date customer approved is blank)

- # of Job Requests waiting for management approval (count of records in Job Requests table where date approved is blank)

- # of Jobs in planning phase (count of records in Jobs table where phase = 1)


When the user selects one of the counts above, they will be taken to the appropriate layout filtered to the appropriate set of records. (This part I know how to do)


Where I am stuck is trying to figure out how to display the counts on a dashboard layout. (been playing with global variables, etc.) What is the best way to go about this?