Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
When you're working with layouts in FileMaker, you'll notice that they are divided up into several different layout parts. For example, if we go into Layout mode, we'll notice on the left-hand side that we've got the small, little bubbles, and there are also these dividing lines. These dividing lines indicate when a part has changed, and the bubble is a label for the part. In the case of the Customer layout, or really any standard form layout, we'll have a Header, a Body and a Footer. In this movie, I'm going to describe the different roles of these parts and how you can manipulate the parts that are currently on your layout.
First of all, you should know that each layout must have at least one part, and layout parts can contain fields, portals, buttons, text and any other layout object. The dotted horizontal lines that I mentioned earlier mark the division between layout parts, and the part Label appears at the left of the divide line. There are other ways that you can view the layout parts; for example, if one of the layout parts is covering a field or a layout object that you want to work with, you can go to the very bottom of your screen and click to either toggle between Horizontal or Vertical display of the layout parts.
Viewing them vertically is a pretty good way to keep them out of the way when you are designing your layouts, but by default you'll see them displayed horizontally, so that you can see the full name of the part. Layout parts are broken into two groups, Non-summary parts and Summary parts. Let's first take a look at the Non- summary parts, the way you work with the different layout parts is by going into the Part Setup dialog. You can access the Part Setup dialog under the Layouts menu and choosing Part Setup, here you'll see the parts that we currently have available, as well as some action buttons on the right-hand side.
You'll notice that if you hit Create, you'll get another dialog called the Part Definition, which shows us all the different parts that we can create on a layout. We'll start at the top, and we'll just review the non-summary parts. The Title Header that you see selected by default will appear only at the very first page that gets printed, and will replace the normal Header on that page. The Header part, which is grayed out here because we've already selected one, will allow any layout object that's placed in that part to appear on the very top of every page that gets printed off of your layout.
The Title Header, of course, will supersede that on the very first page; the same is true with Footers which are grayed out because we've already got one selected. That, of course, will allow any layout object that's placed in the Footer to appear at the bottom of any printed page or any page viewed in Browse mode, and Title Footer will do the same thing. It'll supersede the Footer and allow you to print only something on the very last printed or viewed page of your layout. The only non-summary part that leaves you with is then the Body. Of course, the Body is also grayed out here in this part Definition dialog because we already have a body in our layout.
The majority of the layouts you are going to create will contain a Body, but there are some specialized, and somewhat intermediate techniques that involve having no Body part at all, so it's certainly not required. You can only have one Body part per layout in each object that you put in the body including any field object like a field, or text objects or even graphics, will appear once for every record in the Found Set that you create. We've seen that with list views when we create a very short or not very high Body part that will iterate itself over -and-over again, many different times depending on at what resolution your screen is set to.
So if you create a Body part that has a smaller height, then you can create a List View. If you create a Body part that's the full height of your screen, you'll just see one record at a time. So if we hit OK to escape this option, you see that we had the Title Header selected, and it has now added the Title Header to our layout. Through the part Setup dialog, however, we can choose the Title Header either change it to a different part, or delete it completely, which we'll do in this case. You can also change the order of the parts, if you have multiple different parts together, by clicking on it and moving the handles.
You see the locks here in this case because the Header cannot be moved anywhere, but at the top of the page, and the Footer can only be moved to the bottom of the page. So you really don't have any options to move these. But when you get several different summary parts involved, you might want to move them into different locations using the handles. And all the different selections that we've discussed will be made based on the needs of your specific layouts. We will be talking about the non- summary parts, like Leading Grand Summary and Sub-summary when sorted by, and Trailing Grand Summary, when we get over to the reports section, as they become vital components to creating subsummary reports in FileMaker Pro.
Having an understanding of the different layout parts that are available to you will help you when you're planning and creating the different layouts in your FileMaker database.
Find answers to the most frequently asked questions about FileMaker Pro 11 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.