Browsed byAuthor: David Tinoco

David Tinoco is a self-taught FileMaker developer who enjoys helping others and sharing knowledge. Cooking, film, and programming are his biggest obsessions with occasional web development salted in for good measure. David believes John Lennon was right when he said "Life is what happens while you're busy making other plans."

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.

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.

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…

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…

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.

Search for:

SUBSCRIBE

Make A Donation

Your donation will help keep this website up and will allow for more quality content to be produced. It will also allow the owner a cup of soup per day :)