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.
FileMaker 10 Beginner
John Mark Osborne
US$ 99.95
15 hours - 172 Movies
Win Vista XP 2000,ME. Mac OS X
Ground / 2 day / Next Day
33925
75 In Stock
Apex Web Media ( Hyperteach ) P.O Box 398 Bolton BL7 9YS, United Kingdom. Tel: +44 (0) 1204 592071 Fax: +44 (0) 1204 592092 Email:
Apex Web Media ( Hyperteach ) 600 17th Street, Suite 2800, Denver CO 80202 Tel: Toll free 1866 402 1903 (USA) / 434 878 4158 Fax: 1 207 433 4356 Email: