If you prefer totals and overall summary information at the bottom of a report, it would go in this part.įooter. You’ll learn all about this layout in Chapter 6. These parts help you add things like subtotals to complex reports. In list view, or when printed, it repeats once for every record. The body shows the actual record information. Reports, which help you compile and analyze your data, are nothing more than a special kind of layout, as you’ll learn in Chapter 6.īody. Leading Grand Summary and all the other “summary” parts are how FileMaker creates reports. Since FileMaker is all about making all your data easy to see, search, print, and otherwise use, switching among various layouts is a big part of the game. Likewise, if you do a find on the Form - Main Address layout, and then switch to the List layout, you’ll see just the found records in the list. In other words, FileMaker stayed on the same record while you switched layouts. You’re now viewing details of the record you selected when in list view. Since you are viewing this layout as a list, as you change records, the little black line along the left edge of the window moves, as explained on Section 2.1.2.įrom the layout pop-up menu, choose Form - Main Address. The following two steps show how this layout works.įrom the List view layout, use the status area’s book icon to switch to another record. Since the layout affects only how the data shows, your found set and current record stay consistent as you change layouts. ![]() FileMaker remembers which view you last used with each layout. The List View layout shows in the window. Now that you finally understand the difference between layouts and views, the silly database has the nerve to name a layout “List View.” Remain calm: The name just happens to be the best way to describe the layout (at least the developer thought so), because this layout is a List and it’s displayed in list view. (The status area control is explained back in Figure 1-2.)įrom the layout pop-up menu, choose List View. If the status area isn’t showing, click the status area control to show it. If you need a sample database to play with, you can find it on the Missing Manual Web site ( Section 3.4.5), complete with sample data. When you’re ready to see all the data, you switch to the one-at-a-time detail layout. ![]() The list provides an easy way to scroll through records and find what you’re looking for without getting data-overload. Very often, you create both a detail layout and a list layout for each table in your database. FileMaker can automatically create layouts for many envelope sizes and common label formats. This layout makes addressing envelopes to people in your database a breeze. Reports can even have groups of data and intermediate summaries or running totals (see Section 6.9).Įnvelope and Label layouts format the data so that you can print it directly onto an envelope or a sheet of peel-and-stick labels. They usually show multiple records in a list form, often with a title at the top and summary information at the bottom. Report layouts are designed for printing (see Section 2.9). ![]() The only say the layout has in how things look is in which fields you see, and how FileMaker formats each individual field. Instead, it shows a clean, simple list just like a spreadsheet. It pays no attention to how fields are arranged, or what colors or pictures you’ve used to decorate things. In Table view, FileMaker ignores the layout almost entirely. The layout dictates how each of those records should look, and you use the scroll bar to zip through them. In List view, it shows all the found records, each below the one before it. In Form view, it shows one record, using the layout to decide how that single record should look. The view, on the other hand, tells FileMaker what to do with the layout. When you pick a layout, FileMaker uses it to decide how things look. Most of the time, the layout tells FileMaker how each record should look on the screen: where different fields appear, what fonts, sizes, colors, and pictures show up, and how much space it all takes up. For instance, if you have a Client List layout, you typically use List view. Detail layouts are usually shown in Form view, while list and report layouts usually use List view. Each layout is usually designed to work best with a certain view. So what’s the scoop?įirst of all, in every FileMaker window, you have a layout and a view selected at all times. And you hear a lot about lists, tables, forms, and so forth when talking about either. You can switch from layout to layout or view to view with ease. Both affect the way FileMaker displays your data. FileMaker learners often confuse views and layouts.
0 Comments
Leave a Reply. |