Filemaker for Beginners

Primarily, this function compares two text strings to see if they are an exact match. Text strings even have to match in the case formatting (lower or upper) for each character. Wild as it may sound, you can also compare container…

We all have had the experience of encountering a FileMaker error message. The most common occurrence is when FileMaker tells you that it didn't find any records that match your settings in a find command. Which isn't so much an…

The strict data type validation option is the first possible selection in the “Require” area of the validation dialog box. Strict Data Type validation allows you to make sure the data is a type of number, date or time. You can…

Data in global fields can be passed from one table to another and not have a relationship. So what does that mean, exactly? As you get deeper and deeper into your FileMaker solutions, you may begin to get a little overwhelmed.…

The FieldRepetitions function gives you the number of repetitions and the orientation of a given repeating field on a layout. So if we had a repeating field using this function, we would see something like ( 4 horizontal ) or ( 4…

This feature appeared for the first time with FileMaker 7 and it allows you to limit the number of characters that can be typed into a field. In a way, you had this option before with previous versions of FileMaker because you…

A lookup is a FileMaker relationship related term and will copy the information from a child table occurrence into a field in the parent table occurrence. The copying of information is triggered when the parent match field in a…

The in range validation is used to make sure the data entered falls in between a starting value and an ending value. When setting up this validation, the lowest acceptable value would go in the box on the left and the highest…

LayoutNames LayoutNames(fileName) All Current Versions Of FileMaker Returns A Text Result The LayoutNames function gives you the name of each layout in a particular file. Each layout name is listed and…

A client requested a list of all user editable fields, specifically those on three screens in a FileMaker 11 based system. One possibility is to create a DDR (Database Design Report) using FileMaker Pro Advanced. …