Let's continue our discussion about Housekeeping Fields and how to get them into your database efficiently and error free. So what we're going to do here is not type them in, we're going to copy and paste them from another table, a template essentially. Now if you don't have FileMaker Advanced, you'll have to look at what we've done and create them from scratch yourself. Because we're going to have to four Housekeeping Fields total when we're done but I'll show you every option, you'll be able to very easily create them if you don't have FileMaker Advanced. So I'm going to go ahead and delete these fields, now you don't want to do this if you don't have FileMaker Advanced because you're going to have to type them in. You're going to want to keep them there but that's what we're going to do if you have FileMaker Advanced. If you have this Copy and Paste Button here. That's how you'll know, one way you'll be able to tell that you have FileMaker Advanced. So I'll click OK here, go up to the Window Menu, choose Template and you'll see we have a template here that has the Timestamp Create, Timestamp Mod, Account Create and Account Mod. So the Timestamp is the same as the Date but it has a space and then the time so it's a little bit more detailed than the Date Create Field we created before. And if you're doing this by hand, you're going to want to change to a Timestamp Create, it just has the date, a space and then the time. Other than that it's just the same as the Date Create we did before. The Timestamp Mod is the same as the Date Mod before but it has the date and the time as well. Now we also have two new fields, Account Create and Account Mod, they work very similar to how the Timestamp Create and Timestamp Mod work but they input the person's who's logged on, on there. So when we get into the Security Section later. We're not going to get into it right now, all you have to know is these few things I'm going to tell you. So once you get into Security you'll find out what this is all about but you, you'll be able to understand what I'm talking about right now. Which is there is Security inside of FileMaker that you're going to apply to a solution so that you can track everybody in your system. So in other words, everybody's going to get an account and a password and when you Auto-Enter the account name, it's going to put their name in there or whatever account name you've assigned to them. When they create a record or when they modify it. Now right now, we're getting Admin in there and that's because there is always security in every FileMaker file, there's always a full access account. You may not know it now because it never asked you but FileMaker automatically created it for you and you'll find out more when you get into the Security Section about this. All you need to know is that this will contain the person's name who is logged on at that time. So we're going to go into Manage Database and here's a good time to mention that you should learn the Keyboard Commands for Manage Database as well as some other highly used Menu Items. I don't ever go into Manage Database by doing it through the Menus because it's not very efficient. I use the Keyboard Command which was Shift Command D on the Macintosh or that Flower Key, it's sometimes called the Apple Key or on Windows you do Control Shift D. Much faster because you're going in and out of Manage Databases, you'll see as you go through these tutorials. So I don't recommend you know all of the Keyboard Commands for every feature just the ones that you use a lot and this is a good one to know. So we'll come here, I'm going to click on the First Field, come down to the last field, hold down the Shift Key, Highlight all of them by clicking and then use the Copy Button. Again, if you don't have FileMaker Advanced you won't have these buttons here, I'll click OK, go back to my Solution, go back into Manage Database and then what we're going to do is Paste. And now you have these fields right inside here, you've done it very efficiently without having to create them again and you're sure that there will be no errors here. So let's take a look at them, we'll go into Options on the Timestamp Create and you'll see that we have a Timestamp Field and it's chosen this Timestamp Date and Time, that's what we've selected here. Simply the same as Date but it's just going to add date and time, it's no different than what we did before and no different on this option here as well, we prohibit Modification. Same with Timestamp Mod, we just choose a second choice and choose Timestamp Date and Time rather than Date and it enters the Modification Date and Time all together in one field and prohibit Modification as well. And here's the things we haven't done yet, notice these are Text Fields and not Timestamp, Account Create Auto-Enters the account name. Now we could have chosen name, what's the difference between these two? People are often confused by them so let me clarify what this is, always choose Account Name. Name refers to your system software, you know the File Sharing Settings, the name of your computer. So somebody is going to another person's computer for the day, you're going to get entered into this record, not the account name but the name of the computer. If you want to follow the person who's doing the data entry you want to have their security credentials in there and that's what Account Name is so I'd highly recommend using this. I have never used the User Name as I like to call this ever in my life. It's, it's really, I can't see a use for it, you might but I'm not going to recommend to use it at all. So we'll come down here and look that we have Prohibit Modification, we have that again. Then we have Account Mod, it's very similar to your Timestamp Mod or your Date Mod where you have Account Name here again and then we have Prohibit Modification. So I can't stress these fields enough, you need the Housekeeping Fields in every table you have because they will really help you track down issues even if you're not displaying them on the layout. I'm going to show you one other way to get the Housekeeping Fields into your file. You may like this method better. If you go over to the Tables Section, you'll see there's an Import Button here. I can simply click Import, locate the file and before we choose Open, see this Import Log? As you copy and paste and use specific FileMaker Advanced Features, it will make a log of everything you did and this maybe handy. It may help you to, to retrace your, your route and see what you've done. You, now if you throw it in the trash, it's because it's going to make it again. So I, I just recommend leaving it there and it will just keep adding to it and you can, you, you may find a use for it. I don't really use it myself but some people do find it handy and there's really no way to turn it off so just work with it. So Template.fmp12, we'll click Open, what you'll see is all the tables in there, we only have one so we're going to check that one but we could import multiple tables. We'll click OK, it'll give you a little summary here, you should check it out but usually there's no problems and there it is. The idea behind this is you type in your New Table Name and hit Change and then when you go over to Fields, as long as you have My Table selected, you're ready to add additional fields here. Or you can switch over to Contact and add additional fields there but the idea here is that you just imported this from another file so you didn't have to open that file, it maybe a little bit quicker. Now there is another way to do this, you can click on a Table from your Template, open up that Template File and we'll do that right now. Come over here to Template, go into Manage Database, click on that, Copy it. Come back here, go to Manage Database again, see how it's not quite as efficient if you're already there and then I'll choose Paste. It did the same thing, it called a Template but it's got the same fields in it. So there many ways to do it depending on which, how you want to do it but we really don't want these tables in here. We have a flat file but if we had you know started with our Housekeeping Fields and then added all of our Contact Fields like First Name, Last Name, we might have done this way. But I'm just going to get rid of these; I wanted to make sure you knew they were there. Now this little message says, Do you want to Remove the Table Occurrences? That refers to Relationships and you almost always want to check this but don't worry about it right now. For right now, if you have to click this, check this option, hit Delete and we'll talk more about Relationships later. For right now, all you want to do is make sure you have all of these Housekeeping Fields in here, Timestamp Create, Mod, Account Create and Account Mod.
TERMS & CONDITIONS OF USE
BY SUBSCRIBING TO THIS SERVICE, YOU ARE CONSENTING TO BE BOUND BY AND ARE BECOMING A PARTY TO THIS AGREEMENT, THE TERMS AND CONDITIONS OF WHICH SHALL PREVAIL IN GOVERNING YOUR RIGHTS OF USE. BY CLICKING THE "BECOME A MEMBER" BUTTON, THE INDIVIDUAL OR ENTITY LICENSING THE PRODUCT ("YOU") IS CONSENTING TO BE BOUND BY AND IS BECOMING A PARTY TO THIS AGREEMENT. IF LICENSEE DOES NOT AGREE TO ALL OF THE TERMS OF THIS AGREEMENT, THE BUTTON INDICATING "BECOME A MEMBER" MUST NOT BE SELECTED, AND LICENSEE MUST NOT INSTALL OR USE THE SOFTWARE.
"VTC" refers to Virtual Training Company,
"You" refers to the user or subscriber.
"Software" refers to the VTC training content and software.
2. LICENSE: VTC hereby grants to You a worldwide, non-royalty bearing, non-exclusive license to use the Software according to the provisions contained herein and subject to payment of the applicable subscription fees.
3. RESTRICTIONS: You may not do any of the following:
Save the Software to Your hard disk or other storage
medium; permit others to use the Software except as specified by addendum;
modify, reverse engineer, decompile, or disassemble the Software; make
derivative works based on the Software; publish or otherwise disseminate
the Software. VTC, Inc., VTC Online University, and the Virtual Training
Company site is owned and operated by VTC, Inc. as a corporation of
All materials on this site are the property of VTC unless otherwise specified. No material from these pages may be copied, reproduced, republished, downloaded, uploaded, posted, transmitted, or distributed in any way. Modification of the materials or use of the materials for any other purpose is a violation of U.S. copyright law and other proprietary rights. For purposes of this Agreement, the use of any such material on any other web site or networked computer environment is prohibited.
4. FEES: The rights granted under this Agreement
are effective only upon payment of the subscription fees, which are
strictly non-refundable other than as expressly provided herein. The
term "monthly subscription" is defined as any 30 day period.
The term "yearly subscription" is defined as one 365 day
period. A yearly subscription ends on the same numerical date as it
began (example July 28, 2004 to July 28, 2005).
The VTC Online University is access to every VTC training tutorial in our library. You pay a flat fee for access to these titles. You are billed according to your renewal selection below, and can renew monthly, yearly, or in any other increment offered. If you choose to be billed monthly, you will be billed every 30 days for the subscription until you request the subscription be cancelled. Our terms of service state that you must cancel a monthly subscription at least two business days before your renewal date. These two days give us enough time to ensure that you will not be charged again.
5. LIMITED WARRANTY: VTC warrants that the Software, if operated as directed, will substantially achieve the functionality described. VTC does not warrant, however, that Your use of the Software will be uninterrupted or that the operation of the Software will be error-free or secure. In addition, the security mechanisms implemented by the Software have inherent limitations, and You must determine that the Software sufficiently meets Your requirements. VTC also warrants that the media containing the Software, if provided by VTC, is free from defects in material from the date You acquired the Software. VTC's sole liability for any breach of this warranty shall be, in VTC's sole discretion: (i) to replace Your defective media or Software; or (ii) to advise You how to achieve substantially the same functionality with the Software as described; or (iii) if the above remedies are impracticable, to refund the subscription fee You paid for the Software. Only if You inform VTC of Your problem with the Software during the applicable subscription period will VTC be obligated to honor this warranty. VTC will use reasonable commercial efforts to repair, replace, advise, or refund pursuant to the foregoing warranty within thirty (30) days of being so notified. If any modifications are made to the Software by You during the warranty period; if the medium is subjected to accident, abuse, or improper use; or if You violate the terms of this Agreement, then this warranty shall immediately terminate. This warranty shall not apply if the Software is used on or in conjunction with hardware or software other than the unmodified version of hardware and software with which the Software was designed to be used as described.
THIS IS A LIMITED WARRANTY, AND IT IS THE ONLY WARRANTY MADE BY VTC OR ITS SUPPLIERS. VTC MAKES NO OTHER WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT OF THIRD PARTIES' RIGHTS. YOU MAY HAVE OTHER STATUTORY RIGHTS. HOWEVER, TO THE FULL EXTENT PERMITTED BY LAW, THE DURATION OF STATUTORILY REQUIRED WARRANTIES, IF ANY, SHALL BE LIMITED TO THE ABOVE LIMITED WARRANTY PERIOD. MOREOVER, IN NO EVENT WILL WARRANTIES PROVIDED BY LAW, IF ANY, APPLY UNLESS THEY ARE REQUIRED TO APPLY BY STATUTE NOTWITHSTANDING THEIR EXCLUSION BY CONTRACT. NO DEALER, AGENT, OR EMPLOYEE OF VTC IS AUTHORIZED TO MAKE ANY MODIFICATIONS, EXTENSIONS, OR ADDITIONS TO THIS LIMITED WARRANTY.
6. PROPRIETARY RIGHTS: VTC reserves all proprietary rights in and to the Software, is protected by copyright and other intellectual property laws and by international treaties. VTC, Inc.
Trademark Notice: VTC, Virtual Training Company,
Inc., The VTC Logo, and VTC Online University, are trademarks of VTC,
Inc. All other company and product names may be trademarks of their
The information contained herein is subject to change without notice. Copyright © 1995 - 2005 VTC, Inc. All rights reserved.
7. TERMINATION: This Agreement shall automatically terminate if You fail to comply with the restrictions described herein. Your obligations to pay outstanding subscription fees shall survive any termination of this Agreement.
8. LIMITATION OF LIABILITY: UNDER NO CIRCUMSTANCES
AND UNDER NO LEGAL THEORY, TORT, CONTRACT, OR OTHERWISE, SHALL VTC
OR ITS SUPPLIERS OR RESELLERS BE LIABLE TO YOU OR ANY OTHER PERSON
FOR ANY INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES OF
ANY CHARACTER, INCLUDING WITHOUT LIMITATION, DAMAGES FOR LOSS OF GOODWILL,
WORK STOPPAGE, COMPUTER FAILURE OR MALFUNCTION, OR ANY AND ALL OTHER
COMMERCIAL DAMAGES OR LOSSES. IN NO EVENT WILL VTC BE LIABLE FOR ANY
DAMAGES IN EXCESS OF THE AMOUNT VTC RECEIVED FROM YOU FOR A LICENSE
TO THE SOFTWARE, EVEN IF VTC SHALL HAVE BEEN INFORMED OF THE POSSIBILITY
DAMAGES, OR FOR ANY CLAIM BY ANY OTHER PARTY. THIS LIMITATION OF LIABILITY SHALL NOT APPLY TO LIABILITY FOR DEATH OR PERSONAL INJURY RESULTING FROM VTC'S NEGLIGENCE TO THE EXTENT APPLICABLE LAW PROHIBITS SUCH LIMITATION. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THIS EXCLUSION AND LIMITATION MAY NOT APPLY TO YOU.
9. Links To Other Materials: Linked sites found at the VTC site are not under the control of VTC, and we are not responsible for the content of any linked site or any link contained in a linked site. VTC may change links based solely on our discretion, and we reserve the right to terminate any link or linking program at any time. VTC does not, by linking to sites, endorse companies or products to which it links and reserves the right to note as such on its web pages. If you decide to access any of the third party sites linked to this site, you do this entirely at your own risk.
Forums, and Chat are not always screened by VTC, and we are not responsible for the content of any public or open forum content at the site. VTC may change these public forums based solely on our discretion, and we reserve the right to terminate any forum at any time. VTC does not, by allowing these forums, endorse companies or products which may be mentioned in these forums, and reserves the right to note as such on its web pages. If you decide to access any of the public forums in this site, or linked to this site, you do this entirely at your own risk.
9. GOVERNING LAW & DISPUTE RESOLUTION: This Agreement is governed by Virginia law. All disputes between You and VTC shall be finally resolved through arbitration in Winchester, Virginia. This site is controlled by VTC from its offices within the United States of America. VTC makes no representation that materials in the site are appropriate or available for use in other locations, and access to them from territories where their content is illegal is prohibited. Those who choose to access this site from other locations do so on their own initiative and are responsible for compliance with applicable local laws. You may not use or export the Materials in violation of U.S. export laws and regulations. Any claim relating to the Materials shall be governed by the internal substantive laws of the Commonwealth of Virginia, USA.
VTC may revise these Terms at any time by updating this posting. You should visit this page from time to time to review the then-current Terms because they are binding on you. Certain provisions of these Terms may be superseded by expressly designated legal notices or terms located on particular pages at this Site.
If you have any questions regarding this policy,
or your information specifically,
you may email us at:email@example.com.