In this lesson, I cover window resizing, buttons and navigation, as well as more on scripting.
In this video tutorial, we go over the basics of layout creation, adding fields to a layout, layout modes, layout views, and the basics of creating a script and the use of buttons. Also be sure to check out Part 1 of this series.
If you have ever wanted to search a large amount of records either by Name or Category, or other fields, there is a somewhat simple solution which uses an auto-calculated text field, which is used as a foreign key multi-value list and global fields to perform a relationship match. You only need 1 table to perform this type of operation. 1. Define the fields Let us say we have a table of companies which has the following fields: id name category…
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.