FileMaker Pro 9

Modifying Fields Video Training - Tutorial

Modifying Fields 1

Would you like to view the full sized version of these tutorials and find out more information about the exciting range of training products on offer.
Hide Caption
Now that we've added our Housekeeping fields to keep track of the creation date and time, the modification date and time, and the count creation and modification, we're ready to go ahead and click OK. And you'll notice when we click OK that it automatically adds those fields to Layout. This is a nice feature when you're starting out, but eventually this becomes annoying and actually can ruin your database. You can actually turn this option off in Preferences. So if you go to Preferences, and remember, on Windows it's under the Edit menu and go to Layout section, you'll see that you have this checkbox, and if you uncheck it, newly created fields and defined database will not be added to the current layout. So, why can this be detrimental to your database? Well, there's several reasons. First of all, those fields may not really belong on the layout you're currently on, so do you really want them to be added there? You'll just have to grab them and put them somewhere else. You may not even want those fields on any layout, in fact. You may just be using them in a script, so they may not be display fields, so adding them should really be your choice. In fact, it could actually ruin your layout. If you already have the interface and everything, what will happen is it will actually push down the body parts and we haven't talked about the parts of Layout mode yet. But what it'll do is push down the body parts and you'll have to remove those fields and move them back up. So, in general, I would say it's not a good idea to have this option on because you should really add these fields yourself. As you'll see when we get into Layout mode, you'll actually start adding these fields in ways so that you can keep the same format to the fields and so this option may not necessarily use that format, so it's really a good idea to do this manually, even though it seems like it may take more time, it actually will save you time in the long run. So we'll click OK here, and we're going to go back to Manage Database, and what we want to do is cover some of the other options in here and see how things work. So let's look at the DOB field and let's say we want to change that to, oh, let's say, a text field. You'll notice that it doesn't make the change until you hit the Change button. Same this is true if you wanted to add some type of comment. It doesn't update until you change it. On the other hand, if you go into Options and choose Creation Date, you don't have to change it, it just automatically applies. So these are things you'll just get used to as you're going along. Now, you can also delete fields. If you hit Delete and tell it to delete, and it asks you this question - Do you want to permanently delete the selected fields? Well, it permanently means it's gone. I mean, when you delete something from defined database in the Manage Database area, it's gone from everywhere, so if we hit Delete right now, and don't discard, click OK, you'll see that the date of birth field actually disappears off the layout. So we'll go back in there, Manage Database, we actually want to add that back in there. So we'll type in DOB, make sure it's the right type, and hit Create. Now, it adds it on in the end because it's displaying everything in creation order. Now, we can also duplicate fields, let's say you needed another field for time stamps or something for accounts, or maybe you needed Address 2. We can go to Address, change that to Address 1, and change it. and now we can make a second field for Address that would maybe carry your suite number or an apartment number, or additional address information that wouldn't fit on one line. Well, what we can do is we can actually duplicate that. Now the nice thing about duplicating is it actually will keep all of your options, so in the case of duplicating Time Stamp Create, you can actually go ahead and duplicate that and make very few changes to it to get it to be Time Stamp Mod. All you'd really have to do is change Address, take that off there, make that a 2, notice that the Change button is not available until we change that. FileMaker's smart and know you can't make two fields with the same name, and we just hit Change, and now you have Address 2. So it's up to you how you do things. Now one of the things you can do is move this up there so it makes more sense. And you'll notice that it's changed to Custom Order over here. But we'll get more into that in a few minutes, but realize that you can change the order of these fields so it better suits the way you're looking at your information. Now you can go back to creation order, and it'll go back to where it was, or go back to custom order, and now you're looking at the way you designed it, the way you want the fields to appear in this dialog. So, what we can do is work with this, now I want to make sure that what we did before when we cancelled, we hit that Cancel button and we hit Discard. When you discard, make sure that you really wanted to discard all that stuff. Because maybe we wanted to get rid of Address 2, but what we also got rid of was the Date of Birth here, so you really have to remember when you click that Discard button all the things you've done in here, it's not going to give you a list of what's been done so you can check it. So make sure you really know what's going on, so now we have to add the DOB field again because it removed Address 1 and Address 2 but it also removed DOB, and that's what we want, so we're going to stick with just the regular Address field here and go from here.

FileMaker Pro 9

John Mark Osborne

US$ 99.95

12.5 hours - 145 Movies

Win Vista XP 2000,ME. Mac OS X

Ground / 2 day / Next Day

33783

176 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: