Subtitles of the Movie

So we've talked about Form View and List View and mentioned Table View. Let's talk a little bit more about Table View. Table View is a third choice here or the choice here. And looks a lot like a spreadsheet. So it's really more akin to a list view than a form view so it make more sense usually to look at a Table View and a List View. They would be the same type of layout although I generally make a layout and keep it in the same View As. It's more akin to a List View so it makes more sense to view as a Table View from a List View layout so we'll look at it from here. So we'll go to View as Table. And it looks a lot like a spreadsheet. Now I generally don't like Table View because I don't have as much control over the Interface as I do with the List View so I generally don't include them but a lot of people like them for these reasons. You can sort just by clicking on the header. You can come up here and rearrange the fields. You can resize the field if you want just like a spreadsheet. In fact with FileMaker pro ten and FileMaker Pro 10 Advanced, you have this modify option. And this allows you to take fields on and off. Notice that these ones are locked right here. That's because these are the fields that the developer put on the layout. This modify option is available to people who don't have access to layout mode. They might but that's generally the idea is that people can come in here and modify their table view this way. So the fields that the developer put on the layout certainly could be not shown on there, just like that you saw the state field go away. But they can't be removed, you can't Delete them. But you certainly add another field if you want. So they can come in here and add the Company Field if they want. It won't have that Trash Can there because we can delete it, it won't have that lock there, we can Delete it off there. As well as not show it. So this is an interesting little feature for Table View, give people more control over the Table View, which is really naturally the idea behind it. It's a more controllable view than List View or Form View. You can rearrange the columns and things like that, so this is a natural feature of this. So let's Click OK. Again, notice when we go to Layout Mode, the Company Field is not there, it has not been added on there. But what I do want to show you is some of the options for Table View. We can go into Layout menu and choose Layout Setup. You'll be going to Layout Setup a lot. We're going to skip a lot of this stuff and we're going to go right to Views. Now you'll notice that we have the available views, Form, List and Table. And if I uncheck that that means that this particular layout that we're on cannot be changed to Form View. In other words the View Menu, it will have that option dimmed out. But I generally don't do this because I usually make a layout for just one mode. And I actually dimmed out the menus through Accounts and Privileges and Custom Menus. I don't usually do it this way but this is a quick way without getting involved in Accounts and Privileges to dim this option out for people. It's up to you I still recommend Accounts and Privilege but it's here. So what we're going to do is go into Table View. And you notice you have a lot of control over what happens. We can change the grids, we can do horizontal and vertical and we can change the grid style and the color. So fiddle around with this stuff, it's pretty interesting how much control you have over the way you look and feel. You can't really do as much as you'll see with List View that I think you can as far as putting graphics and things on there, but you do have some good control here. You can include a header and a footer part, notice that our List View wording didn't show up when we looked at it previously but if we checked that it would show up then. And that's important to notice the difference between Form View and List View. You notice when you scroll in List View, that the header stays in place and so would the footer. But in Form View it just doesn't really act the same way because you're not looking at multiple records. So you have a lot of options here. Resizable columns, you can tell them they can't do that if they don't want to. Sort data when selecting the column. Do you want to re order the columns, those are all by default. And you can have custom heights for the rows if you want. So there's all kinds of things you can change here, in fact you can specify in pixels and other options. So I'm not going to change any of these options here. But I want you to know that they're there. And again they'll display once you go into Browse Mode but only when you have Table View selected. So I'm going to switch this back to List View because it's really my preferable option. As I as saying, notice how in the List View, the header just stays right there. If we go over to our Form View, you really don't see that there's a header there. It's there, it's right in there because we haven't typed anything but it really wouldn't react any differently. You wouldn't see it react as you do in List View where it just stays in place. It's a different way. So you got to realize how all these parts interact with List View, with Browse Mode, with Table view and even when you're printing or previewing it reacts differently so you've got this all inside your head and the only way you can do that is by fiddling around with it, getting that experience with FileMaker, so fiddle as much as you can and remember to build what we're doing here. Don't just watch these videos, build what we're talking about and that will really help with the retention on how these things work and just make you a good FileMaker programmer.