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…

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…

The strict data type validation option is the first possible selection in the “Require” area of the validation dialog box. Strict Data Type validation…

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…

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…

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…

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…

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,…

LayoutNames LayoutNames(fileName) All Current Versions Of FileMaker Returns A Text Result The LayoutNames function gives…

A client requested a list of all user editable fields, specifically those on three screens in a FileMaker 11 based system. One possibility…