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?