filemaker pro script examples to clear field in all records

But you should only need to enter the email message once. Each record is a user's name and email address. Consider the following example: You create a database specifically for sending an email to multiple recipients. However, there is also a need to manage additional data, identical information for each record, that may need to be revised on demand. Imagine you're desiging a file that will need to store multiple records. Let's explore how global fields can open up a whole new dimension to even the most basic development effort.ĭo this: Open the REMAIL.FP3 file to follow along This might initially seem pointless when you view a database as a collection of unique values associated with each record.

Simply stated, a global field is one field, containing a value (be it a number, date, or text string) that is shared throughout every database record.

I have used them in every database I've designed since I first discovered how much flexibility and power doing so can provide. They're the greatest thing since, well, FileMaker Pro. Although they're not unique to any single database application, I consider one of the most versatile and functional features of a well designed database to be the use of Global Fields.

Filemaker pro script examples to clear field in all records