Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You see here what we've got is a FileMaker database that we've created by opening up a spreadsheet inside the FileMaker Pro application. What that has done for us is not only brought in 653 Records that were once rows inside of a spreadsheet, and represents them here in our database. But it's also done something that you'll see, if you go under File > Manage > Database, it's created these things called Fields, which are represented in our Spreadsheet view as a column, but it's created these fields for us in the database. But one thing we haven't talked about yet is a Table.
When we created this FileMaker database from our spreadsheet, it created a default Table for us. A Table is something that we're going to be talking about in the upcoming movie. But in short, a Table is the part of the database that stores different types of data. You can have many different Tables inside of your FileMaker database. In this chapter, we're focusing on easy and quick ways to go from 0 to 60 to create your database. So here I'm going to show you, in this database we can also add additional tables to it, as well. So here already we've got an Itinerary table. Let's say that we want to add adventure information to this database, not only the adventure data, but the adventure fields and all those stored within an adventure table.
The easiest way to do that is to go under the File menu, to Import Records, and choose File and navigate over to your 02_03 Exercise Files folder. Here we can choose Adventures. You see that Adventures is a text file, which is indicated by the .txt at the end of the file. Hitting the Open will bring up something called the Import Field Mapping. What we're doing here is we're actually importing in information from another source into our FileMaker Pro database. But what's interesting here, if you choose this option called New Table, after we choose New Table, we now see all of the different Source Fields listed in the middle of the Import Field Mapping window.
These are the different columns of information inside of the text field Source that we're trying to import in. But since we've chosen New Table, we're not only going to import in the new records, but we're also going to import in a new Adventures table for those records to be stored. You see that we don't have field names yet, but if we choose this option, Don't import first record, you'll see that now what it's done is identified that the first record in the Import Source, in this case the Adventures text file, has names or column headers, which will then become the field names inside of our database.
So later in the title, we're going to talk about importing data into FileMaker Pro. But we're using the File, and then Import Mapping window here just to create a new table. So in this case, we're going to hit the Import button. You see we've got some information that we've got records added and no errors. We see we've got a new Layout automatically added to our database. This one is called Adventures. You see that in addition to the first two that were created when we first created the database from a spreadsheet. Not only do we have the New Table created in FileMaker and a new Layout created, but we've got 10 Records.
We've got 10 Records and all these various fields. You'll see that if you go into the File > Manage and Database option, you'll notice that under the Tables tab, we now have two tables: the original Itinerary table, and now we have Adventures. You'll see under the Fields, we've got all the fields defined from within Adventures. So without knowing anything about how to create Tables or how to define Fields or add records to a database, we've been able to create a database from a spreadsheet, and then add new tables to that from different sources. So we've, in this case, taken a spreadsheet and a text document from separate sources, and combined them together into one FileMaker Pro database.
Adding Tables from various different data sources is a fast and easy way to get these Tables, Fields and Data into your new FileMaker database.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91221 Viewers
80 Video lessons · 138197 Viewers
59 Video lessons · 57027 Viewers
52 Video lessons · 70666 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.