Password protection and security…
Browsing Category
Filemaker for Beginners
The FileMaker Exact Function – FileMaker Today
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…
The Set Error Capture FileMaker Script Step – FileMaker Today
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…
Validation Of FileMaker Data: Strict Data Type – FileMaker Today
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…
Pass Global Data In A FileMaker Relationship – FileMaker Today
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 FileMaker FieldRepetitions Function – FileMaker Today
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…
FileMaker Validate: Maximum Number Of Characters – FileMaker Today
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…
FileMaker Lookups Explored – FileMaker Today
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…
Validate FileMaker Data In A Range – FileMaker Today
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…
The FileMaker LayoutNames Function – FileMaker Today
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…
Quickly get a list of all fields on a FileMaker layout – FileMaker Today
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.
…