FileMaker Pro 11 Essential Training
Illustration by Richard Downs

Building with container fields


FileMaker Pro 11 Essential Training

with Cris Ippolite

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Video: Building with container fields

There is a special type of field that we haven't reviewed yet, that's called the Container field, and Container fields comprise an important building block for any FileMaker Pro solution, in which you want to store and/or display more than just text, numbers, dates, and times, like we've been working with so far. With the Container field, your database solutions can store and display digital images, videos, play music or sounds, and even store electronic documents, such as PDF or Word documents. The Container field is a versatile data repository that can store any sort of binary data, and binary just is a generic term for data that cannot meaningfully be represented as text.
Expand all | Collapse all
  1. 7m 22s
    1. Welcome
      1m 8s
    2. Understanding the FileMaker family
      2m 15s
    3. Using the FileMaker Quick Start screen
      2m 52s
    4. Using the exercise files
      1m 7s
  2. 21m 9s
    1. What is a database?
      2m 26s
    2. Flat vs. relational databases
      2m 29s
    3. How FileMaker works
      4m 48s
    4. Understanding the essential preferences
      3m 13s
    5. Touring the interface
      8m 13s
  3. 11m 44s
    1. Creating databases from templates
      2m 29s
    2. Creating new databases in the spreadsheet-like format
      5m 35s
    3. Importing tables
      3m 40s
  4. 9m 9s
    1. Determining which tables you will need
      5m 10s
    2. Creating tables in the Managing Tables window
      3m 59s
  5. 34m 47s
    1. Understanding relationship types
      6m 58s
    2. Diagramming relationships (with ER diagrams)
      8m 50s
    3. Determining which key fields you need
      5m 18s
    4. Defining primary and foreign keys
      7m 56s
    5. Creating relationships using the relationships graph and table occurrences
      5m 45s
  6. 50m 34s
    1. Deciding what fields you will need
      5m 34s
    2. Understanding field types
      7m 54s
    3. Defining fields
      9m 56s
    4. Using Auto Enter options in fields
      9m 33s
    5. Reviewing field validation options
      8m 16s
    6. Building with container fields
      9m 21s
  7. 14m 8s
    1. Creating and duplicating records
      5m 40s
    2. Editing and locking records
      4m 42s
    3. Deleting records and backing up files
      3m 46s
  8. 21m 6s
    1. Importing data
      9m 57s
    2. Importing records to refresh data
      7m 2s
    3. Exporting data
      4m 7s
  9. 18m 30s
    1. Understanding layouts
      4m 15s
    2. Using the Layout Assistant to create List views
      7m 59s
    3. Using the Layout Assistant to create labels and envelopes
      6m 16s
  10. 27m 11s
    1. Using the Layout Setup dialog box
      4m 54s
    2. Understanding layout parts
      4m 40s
    3. Understanding the new Inspector
      2m 26s
    4. Exploring the Status Area in Layout mode
      6m 46s
    5. Managing layouts and layout folders
      8m 25s
  11. 41m 9s
    1. Arranging, aligning, grouping, and locking layout objects
      11m 5s
    2. Placing and formatting objects, parts, and graphics
      4m 10s
    3. Formatting fields and applying field attributes
      8m 26s
    4. Setting field behaviors
      4m 4s
    5. Using the Tab Control feature
      9m 8s
    6. Setting tab order
      4m 16s
  12. 36m 48s
    1. Using the basic find functions
      7m 31s
    2. Reviewing new requests in the Find mode
      5m 54s
    3. Establishing search operators
      6m 43s
    4. Constraining or extending found sets
      3m 24s
    5. Finding records using date, time, or timestamp criteria
      5m 18s
    6. Using Fast Match and Quick Find
      4m 41s
    7. Working with saved finds
      3m 17s
  13. 17m 28s
    1. Sorting with one criterion
      6m 4s
    2. Sorting with related fields
      2m 18s
    3. Sorting with multiple criteria
      1m 36s
    4. Sorting using custom values
      3m 14s
    5. Sorting using buttons
      4m 16s
  14. 17m 14s
    1. Reviewing Field/Control styles
      5m 43s
    2. Creating and applying static value lists
      5m 20s
    3. Creating and applying dynamic value lists
      6m 11s
  15. 23m 52s
    1. Previewing pages and print options
      6m 20s
    2. Printing in different views
      2m 54s
    3. Sliding objects
      3m 26s
    4. Printing merge letters
      4m 53s
    5. Saving as a PDF or Excel file
      6m 19s
  16. 15m 1s
    1. Building simple reports with summary fields
      4m 36s
    2. Creating subsummary reports
      6m 51s
    3. Creating subsummary reports in Table view
      3m 34s
  17. 52m 19s
    1. Defining calculations
      2m 31s
    2. Exploring the Calculation dialog box
      5m 8s
    3. Using number functions
      12m 41s
    4. Using date and time functions
      4m 58s
    5. Using text functions
      11m 43s
    6. Using get functions
      4m 0s
    7. Using logic functions
      11m 18s
  18. 46m 56s
    1. Understanding scripts and script steps
      2m 23s
    2. Assigning script steps to buttons
      3m 54s
    3. Understanding the ScriptMaker dialog box
      8m 28s
    4. Creating multi-line scripts
      6m 44s
    5. Adding find criteria to a script
      4m 58s
    6. Understanding the If script step
      8m 36s
    7. Using script parameters
      4m 42s
    8. Reviewing the Send Mail option
      7m 11s
  19. 28m 0s
    1. Understanding script triggers
      2m 41s
    2. Using object-based triggers
      11m 58s
    3. Using layout-based triggers
      7m 51s
    4. Using file-based triggers (Open and Close scripts)
      5m 30s
  20. 56m 42s
    1. Using related fields
      7m 18s
    2. Creating portals and using portal filtering
      10m 38s
    3. Using related fields in calculations
      7m 6s
    4. Understanding multi-predicate relationships
      11m 11s
    5. Using the Go to Related Record script step
      7m 26s
    6. Creating a chart
      13m 3s
  21. 30s
    1. Goodbye

please wait ...
Watch the Online Video Course FileMaker Pro 11 Essential Training
9h 11m Beginner Jun 25, 2010

Viewers: in countries Watching now:

In FileMaker Pro 11 Essential Training, Cris Ippolite demonstrates the principal features and functions of this popular database software, including creating tables and relationships, managing fields and records, and working with layouts. The course shows FileMaker developers how to find, sort, and share data as well as how to create reports, calculations, and scripts. It also covers brand new features in FileMaker Pro 11 such as the Inspector tool, charting, and portal filtering. Exercise files accompany the course.

Topics include:
  • Creating databases from templates
  • Creating fields in spreadsheet format
  • Creating tables and relationships
  • Defining key fields
  • Adding validation and auto-enter values to fields
  • Managing records, including duplicating, locking, and deleting records
  • Creating and managing layouts
  • Formatting layout objects
  • Finding and sorting data
  • Creating calculation fields
  • Building reports
  • Printing and saving as PDF or Excel
  • Writing and triggering scripts
  • Using relationships throughout a database
FileMaker Pro
Cris Ippolite

Building with container fields

There is a special type of field that we haven't reviewed yet, that's called the Container field, and Container fields comprise an important building block for any FileMaker Pro solution, in which you want to store and/or display more than just text, numbers, dates, and times, like we've been working with so far. With the Container field, your database solutions can store and display digital images, videos, play music or sounds, and even store electronic documents, such as PDF or Word documents. The Container field is a versatile data repository that can store any sort of binary data, and binary just is a generic term for data that cannot meaningfully be represented as text.

When we set up our fields in our database, under File > Manage > Database, and you'll see that we set up a field already called CompanyLogo and gave it the field type, Container. So let's use this field to experiment with Container fields and the data that they can store. So once we've got a field defined, which we do already, let's go in the Layout mode, and we're going to practice inserting a Container field into our layout. We'll talk more about inserting fields into layouts when we discuss the chapters on working with layouts, but for now we can either choose Insert > Field, or you can choose, on your toolbar, the Field tool, which we'll use in this case.

Simply click down with your mouse, and you'll see your cursor turn to like a hand that's grabbing a field, and we'll drag that down to an area in our layout, and we'll release it. Now, FileMaker pops up and asks us, what field would you like to place here? We'll say CompanyLogo, and hit OK. Since the Container field can contain images or video or sound, we might want to resize it so that it's a little bit larger so that we can actually see the contents contained within. So when you have a field selected, which you'll see by the handles in the four corners, you can grab any one of the corners to click down, drag, and then release to thus change the size of your field.

You can easily identify Container fields on your layout, because they don't have text baselines, and that the name of field stays centered, regardless of how large you make the field in Layout mode. Now, back in Browse mode, if we go under View to Browse and hit Save for our changes, you'll see that we can click into this area now, and now it will allow us to go under our menu and hit Insert, which allows us to add different types of data into the Container field. You'll also notice that if you right- click or hold down the Ctrl key and click, you get these same options.

Let's start by adding a picture. I'm going to choose Insert Picture and go into our Exercise Files, where we are going to choose this file called author.tiff and then select Open. Now you see the picture we chose in the field, and you'll notice that when you navigate back to the previous record, that image doesn't appear. So just like any other piece of data in a field, any one record will store any binary data, but only for that record where you've inserted it.

Also, once you have data in the field and you click on the field, or the contents, by right-clicking, or in Mac, you can hit Ctrl and then click, you'll notice that we now have the option to Export Field Contents. So this way if I choose this option, you see that it allows me to export out the value that we're storing in the container and save it somewhere else on my database. This isn't quite as dramatic if I am the person who put the value in there, But imagine a database that's shared by various different users. if someone wants to take an image or a sound file or a movie that you've created, they can easily just log into the database, navigate to the record, and then right-click to save the file locally on their own desktop.

You can remove data in the Container field by simply clicking on the field and hitting the Delete key on your keyboard. Now let's try adding a QuickTime. This time we'll do through it Insert > QuickTime. Now let's choose Managing Fields in the Exercise Files, and this time we'll choose a movie. I hit Open. Not only do we see the movie, but we see a bar down here that allows us to play the movie and control the volume, much like we would do so with any other type of movie.

The same is true for sound files. So you can include video clips or audio clips, anything you want, and of course it will be only stored in that one record, and then naturally, any other user can just right-click to export that video out to their own desktop. Let's click inside and hit Delete to clear out that value, and now you'll see, if we insert a file, we can choose a TextFile, and you'll notice that when you click a file, it puts the name of the file with the extension and then an icon that represents that type of file.

For example, if I click in and hit Delete again and hit Insert > File, this time I am going to choose a FileMaker file or a PDF, something that's not a standard file, you'll notice that the icon changes but that the entire name with the extension appear. One of the things you might notice here is that we're adding one file at a time to each container. Now, if you ever need to add more than one file to any one record, so for example, let's say you've got a customer record and you want to store their signature page for the original contract, as well as a company logo, that would require doing one of two things: either creating two container fields, one that would store the logo and then one that would store the signature page scan, or you can take any number of files and zip them together into a packaged set of files, and then you can just store that zipped package in the container as one single file.

Now, there's one very important word of caution here. Your database will increase in size every time you add a file to a container field, and it will increase by the size of the file you are storing. What does that mean? Well, it's not a very big deal when you are adding smaller sized files, like PDFs and such, but if you were to add a four gigabyte video, which of course, four gigabytes is our maximum size capacity for a Container, if you were to add a video clip that was four gigabytes in size, that means now that your FileMaker database has just grown four gigabytes in size.

Imagine if you add assets to Container fields for thousands of records of your database; your FileMaker database will get huge. Don't worry; FileMaker does have a file size limit of eight terabytes, which is pretty enormous, but still you're going to quickly encounter some performance issues when you're sharing your database over a network, or even just trying to import your database via e-mail, or any other kind of system like that. So the best idea is to either make sure you are conscious of the size of the files, or you can use this other option I'd like to introduce you to, which is called storing a reference to a file.

So let's click inside here and hit Delete, and then go under Insert to File and choose one of the files that we want to insert, let's say, for example, this TextFile. But you'll notice in the bottom left-hand corner we have an option called Store only a reference to the file. You'll see when I click on that and hit Open, it still displays the image or file at the same resolution or quality as it always would have if I just embedded the file, but now it's just storing the path to the location of the image, or file, or video using the QuickTime engine to display the image itself.

So since it's only storing a path, it's very small amounts of text rather than this huge video file, or image, or sound or whatever it is you are trying to embed in your files; therefore, storing a path almost has no impact on the overall size of your FileMaker file. This is a much more efficient way to store images or videos and just keep them as a reference for that matter, or movies, or files or whatever you want to store inside of Container field. Just keep in mind that the moment that the path breaks, so will the display of the image. So, for example, if I were to clear this out and insert a picture and choose Managing Fields / 05_06, and this time choose our image, storing only a reference to the file, there we have the image.

But if I open my Exercise Files, and I move that image out, let's see what happens when I navigate back to the record. You'll see here, this file cannot be found. That's because I stored a reference that was specifically from this file to that location. If we move that back to the location and then Refresh, you'll see that it finds the image. Now, this can be very delicate, because if your file is stored on a network, that path is really from the server back to the file, so it can get kind of complicated and you need to be careful with it, but certainly there are ways that you can store this media as a reference, not impacting the performance of your file, but at the same time keep a centralized directory somewhere on your network that all users can use.

It's great for you to use, but if however the purpose of the database itself is to store media or collateral documents in a common location accessible to all authorized users, then embedding the files in a Container field may in fact be the best solution for you. If the file size are large, then what you want to do is get a database that stores files on a hosted server, with plenty of fast storage and network access that all of your users can get to. This way when a user embeds something in a stored directory, that way all users will be able to have access from the FileMaker database back to that path.

FileMaker Pro provides you with a really unique and interesting type of field, the Container field. This allows you in your database solutions to store and display digital images, video, play music or sounds, and even store electronic documents, such as PDF or Word files.

Find answers to the most frequently asked questions about FileMaker Pro 11 Essential Training .

Expand all | Collapse all
please wait ...
Q: In the Chapter 16 tutorial, “Using Text Functions,” the instructor discusses how to calculate the First Name and Last Name from the Full Name. However, the method does not account for names ending with  “Jr.” or “Sr.” or “III,” etc.  How can I account for added suffixes in names?
A: For cases like this, you can create a third "Suffix" field. Then change the FullName calculation to:

NameFirst&" "&NameLast&" "&Suffix 

This way, nothing will appear if the Suffix has no value, but if it does have a value the suffix will appear.
Q: What information is actually on the “Invoice Line Item” table in the examples, and how does it actually connect to the tables that it comes from?
A: The information in each line item is native to the "Invoice Line Item" table. The fields are defined in that table and each record represents "A Product appearing on an Invoice."
Each time a product is used on an invoice, a record in the line item table is created. Many of the fields, for example "Quantity," are native to that table because those values only exists when a Product is used in an Invoice, and not as attributes of a Product itself.
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Mark all as unwatched Cancel


You have completed FileMaker Pro 11 Essential Training.

Return to your organization's learning portal to continue training, or close this page.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.