Browsed by
Category: Databases

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

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

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.