Software tips, techniques, and news.

By Hayden Hobbs  Posted on  August 10th, 2022  in  Free Downloads, Claris FileMaker

FileMaker Dashboards

When making a robust solution in FileMaker that you want to suit your needs best, it’s important to consider the app's purpose and projected user pool. As more and more users enter the file and use it for their needs, the higher the priority to filter down the system's records on a per-user basis becomes. Thankfully, with the addition of a system dashboard to your FileMaker project, you gain a fast and user-friendly way to present the data of each user without the need for slow and bulky found sets.

Why A Dashboard Matters

Consider a FileMaker solution where you are presented with a form view of Sales Invoices upon opening it. The system will likely be unsorted, and the only way to see the Sales Invoices for a particular user is to search in Find Mode for that user and then tab through each individual record. It will be a slow, arduous process to view all that data, especially as the size of your data set grows. However, with the addition of a system dashboard, you can now view all of that data from a splash screen. Before, it would have required performing a find search and clicking through each record; now, you can simply scroll through a portal with all the relevant data. A dashboard saves you and your users time, efficiency, and money.

Creating a Dashboard

To create a dashboard for your system, the initial step will be to create a new table; this new table will be used as the ‘mediator’ of sorts for each table you have in your system. This table will be called "SESSION” and will be based on the individual user session at any given time. With this, each user can see their own relevant data from the moment the file loads up for them, increasing efficiency.

filemaker session table

Create a new layout for SESSION and set up a navigation from this new layout to the pre-existing layouts and create an in-layout navigation—we’ll be using a tab control for this example. Set up the tabs to correlate to your data sets: we’ve made tabs for sales tasks, a calendar displaying these tasks, sales prospects, sales quotes and invoices, as well as shipping. For each data set, we’ll need to create a relationship between our new SESSION table and the corresponding data table.

These relationships will be based on global fields within the SESSION table—this allows the dashboard to remain the same no matter what record you’re on, allowing each user to keep their dashboard the same for their entire time in the system. Code examples of how to create a filter for the dashboard using these global fields are provided in the sample file, the FM Quickstart dashboard. FM Quickstart is DB Services' free FileMaker ERP template. The full FM Quickstart template can be downloaded for free on our official FM Quickstart website.

filemaker dashboard relationships

In this example, the dashboard has already been created. However, for the purposes of this article, you can still follow along.

Back on the dashboard, create a new portal for each tab you’ve made using these new relationships. Each of these portals forms the basis of the value of a dashboard in your system: a quick, easy way to view your data without having to go looking for it. You can even edit these relationships to add additional parameters to filter these portals. The more filters you add, the more you can fine-tune the data you view! 

Conclusion

Dashboards in FileMaker solutions are an excellent way to increase your app's value and speed up your users' workflow. They remove the need for constantly using found sets to view the data you want and allow you to view the entire system in a quick sweep—right from opening the project. The return on investment for a system dashboard is incredibly high, and we firmly believe that they are a valuable necessity in any new FileMaker project. If you'd like assistance creating a dashboard in your FileMaker solution, DB Services is ready to help. Contact us today and let's talk about what we can accomplish together!

Did you know we are an authorized reseller for Claris FileMaker Licensing?
Contact us to discuss upgrading your Claris FileMaker software.

Download
Download the FM Quickstart Dashboard File
Please complete the form below to download your FREE FileMaker file.
FileMaker Experience *
Terms of Use *
OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This file is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free file, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime.
Hayden Hobbs thumbnail
Hayden Hobbs

Hayden is a reliable, patient, and consistent application developer who takes pride in creating systems that help clients reach their goals. She will go above and beyond to help a client or coworker when they are in need and enjoys collaborating with and supporting others. 

FileMaker 18 Certified Developer
FileMaker 17 Certified Developer
FileMaker 16 Certified Developer
FileMaker 15 Certified Developer
FileMaker 14 Certified Developer
FileMaker 13 Certified Developer
FileMaker 12 Certified Developer
FileMaker 11 Certified Developer
"We were actually able to add more features than we thought would be possible within our budget. We always experienced a ‘can do’ attitude and DB Services was incredibly patient and easy to work with."
Courtney Hartman
Art Director
"The new FileMaker custom website interface is very user-friendly and easy to follow for our clients. In addition, it is much faster than the old Instant Web Publishing (IWP) interface. Thank you and all the others who have helped us out at DB Services. I am very grateful for the excellent service you provide us. Its nice to know we can call you for help if we have an issue."
Wayne Capek
President
"We needed a solution that would simplify the administration of our responsibilities under our contract with the State of Indiana. We have seen a dramatic increase across the state in the number of potential foster and adoptive parents that have begun the preparation and training process. This increase has resulted in a significant opportunity for children available for adoption. That’s a big win for everyone! And it’s all because we can refer potential parents to the proper state contacts efficiently and quickly."
Chris Morrison
Executive Director
"Thank you for all of your expertise and valuable help. I am so grateful to have found DB Services."
Linda Findlay
Owner
"Thank you for our new database system. We transitioned from a carbon copy paper based system to a digital database. The software has saved us time and money. We used to archive all our jobs in cabinets, now we can look up a job in seconds from anywhere. The software allows us to easily email estimates to our customers in pdf format. In a year there was a return on investment just from eliminating the purchasing of our carbon forms."
Todd Cartmel
Owner
"The new system allows us to create and track jobs for customers along with inventory, something we had been doing with separate word and spreadsheet files. Because it’s now so intuitive, new staff members are able to begin using the database immediately without our usual training session and ‘cheat sheets’ for getting around within the file."
Tom Andrews
President