Every now and then, you will need to highlight fields required on a layout/database. You may have observed that validation turned on in a table field can be cumbersome especially if that field won’t be on certain layouts. Here is a lesson to show a workaround for this, which also highlights mandatory fields which have been left blank by the user. Here is a link to the file referenced in the above video: Conditional-Formatting.fmp12.zip
Have you ever wanted to created a live-updating progress bar? Piecharts and graphs are a cinch, but the ability to make a good-looking progress bar seems almost impossible–unless you know how to use the Web Viewer Tool! Using HTML/CSS and a few calculations, you can simulate a progress bar that will update in real time using Script triggers and the ExecuteSQL function. Watch the video at FMTutorials on Youtube.
This tutorial is a remake of an earlier one, with up-to-date information on how to create a modal dialog using FileMaker Pro version 14. This technique is more simple, with FileMaker’s update to the New Window script step, which now allows for 3 different types of windows. You now have the ability to turn off resizing, close button and other features to make a truly modal window which cannot be exited or canceled by the user without following through with…
Learn how to use the autosizing feature in FileMaker Pro 14 to create fields and objects that resize themselves to fit the window width, height, or even to right align objects on the layout. A very useful feature if you want to maximize screen usage and provide layouts that dynamically “adjust” themselves. Leave comments and questions below.