Blog

How To Use FileMaker Pro 16 – Part 1

How To Use FileMaker Pro 16 – Part 1

In this videotutorial, we will cover how to set up a new database in FileMaker Pro 16, as well as the process of creating tables and fields. I also cover how FileMaker can be related to Microsoft Excel for understanding purposes, in order to help give a better understanding of how databases work. I also recommend reading an earlier blog post called “What is a database?” which gives more information about relational databases and database structure.

What Is A Database?

What Is A Database?

In this article, I will attempt to shed some light on the question “what is a database?” and how a database can be useful in organizing large amounts of data. I will also cover exactly how FileMaker Pro helps you to create databases quickly and what advantages you will gain in using this product. I would like to start off by stating that it is highly important to look up words you don’t know when studying a new subject. The reason for this…

Read More Read More

How To Generate Barcodes With FileMaker Pro

How To Generate Barcodes With FileMaker Pro

Want a free and simple solution for creating barcodes right inside of FileMaker? No plugins, no paid extra stuff–totally free. Well, that’s what this tutorial teaches you to make. This comes in handy when you start developing applications for FileMaker Go as it enables you to use barcodes in your app without the need for barcode fonts or plugins (save money, develop more). You can create many types of barcodes from Code128 to Code39, etc., and even QR Codes. All you…

Read More Read More

Searching Large Amounts of Records with Dynamic Portals By Name or Category

Searching Large Amounts of Records with Dynamic Portals By Name or Category

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…

Read More Read More

Conditional Formatting for Highlighting Required Fields

Conditional Formatting for Highlighting Required Fields

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

How to Make Progress Bars in FileMaker Pro

How to Make Progress Bars in FileMaker Pro

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.

Creating Modal Dialogs

Creating Modal Dialogs

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…

Read More Read More

Autosizing in FileMaker

Autosizing in FileMaker

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.