The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

FileMaker Pro Progress Bar Using base64 – FileMaker Today

Get real time updates directly on you device, subscribe now.

This tip comes to you from our friends at Excelisys where you will find the latest tips, tricks and news relating to their company and our world of custom database software development.

After we posted the FileMaker Pro 13 Progress Bar demo file using a base64 image last December, one frequent request we received was for a way to have the bar change color based on its percentage. For example, changing from green to yellow to red as the percentage increased.

This FileMaker Pro 13 Progress Bar demo file adds that feature. It replaces the foreground_color parameter with a steps parameter that takes a return-delimited list of values. Each line should have a number between 0 and 100 indicating the percentage threshold, followed by a space and then the corresponding color in base64. The values should be sorted by threshold, ascending. The FileMaker Pro Progress Bar demo file includes an interface to help you build the steps parameter.

The ProgressBar() custom function loops through the lines in steps, comparing the progress value with the threshold value and stopping at the first one that is equal to or higher than progress. It then parses out the corresponding color value and finishes calculating the graphic using the same technique as the original FileMaker Pro Progress Bar file.

This can be used for a variety of purposes in addition to progress bars, such as status indicators, bar graphs and even as simple background colors that can be set programmatically (just set progress to zero and the background color to your choice. The final parameter would be left blank.).


Progress Bar Advanced Download

About Andy Persons: Andy is a Senior Lead FileMaker Pro Developer with Excelisys:  Andy has been an industry leading FileMaker Pro developer creating FileMaker Pro solutions for over 17 years. In addition to being one of the lead developers of three top-rated and most-downloaded FileMaker Pro solutions of all-time; the FileMaker Business Tracker and the Excelisys eX-BizTracker & eX-BizTracker Pro jump-start solutions, he has shared his incredible and advanced talents by authoring numerous Tips-n-Tricks files and white papers, including Hierarchical Portals, Recursive Calcs, Audit Logs and Drag-and-Drop using FileMaker Pro. *This article is provided for free and as-is, use and play at your own risk – but have fun! Excelisys does not not provide free support or assistance with any of the above. If you would like help or assistance, please consider retaining Excelisys’ FileMaker Pro consulting & development services.  

About Excelisys, Inc.: Founded in 2001, Excelisys ( is a dedicated organization specializing in the designing, developing, customizing, supporting, consulting, migrating, upgrading, tweaking, fixing, and integrating of FileMaker Pro solutions, FileMaker Go solutions, MySQL, PostgreSQL, QuickBooks-FileMaker Pro Integration, Excel and MS Access FileMaker Pro conversions/migrations, iPhone and iPad business solutions, and other various database technologies and frameworks that automate your organization’s data solution needs for use on the web, mobile, and desktop platforms. Contact Excelisys today for a free estimate and consultation about your business software automation needs @ 866-592-9235.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More