[ANNC] FileMaker Pro 13 Tip-n-Trick – V2 FileMaker Pro Progress Bar, The Next Generation Using base64

Discussion created by eX-Christo on Aug 14, 2014
Latest reply on Aug 14, 2014 by eX-Christo

By Andy Persons


The Next Generation of the FileMaker Pro Progress Bar Using base64


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.).



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 (www.excelisys.com) 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.

* FileMaker and FileMaker Pro are registered trademarks and owned by FileMaker, Inc. in the US and other countries.