Personnel Records: FileMaker Pro 12 Starter Solution

The Personnel Records Starter Solution quickly gets your 201 files in order. It's one of the 16 pre-made templates that's available for you to start using for your database requirements. It's fully unlocked so you can view and modify the database tables, relationships, layouts, and scripts.

When you start out FileMaker Pro 12, just click File > New From Starter Solution… and select Personnel Records. Type the name you want for the database (in case you'll have multiple of the same database), specify where you want to save it, and click Choose.

The Time Off tab keeps track of Leaves and Vacations.

You'll be presented a new record where you can begin typing in the personnel details, such as Status, Employee and Badge Numbers, Job and Department, Addresses, Pay Information and Photos. There's a Time Off tab to enter Sick Leaves and Vacation information; these can be filtered by date for easy access. There's a Printable View as well to let you print a one-page summary of the record.

The Personnel Report.

Clicking the Personnel List button shows you a list of all records you've created, with an option to sort it by Status, Employee Number, Employee Name, Job Position, and Department.  You can also import and export item records to any of the file formats supported by FileMaker Pro, and print out all the records you're viewing in Label or List format.

The Personnel List view.

Aside from the professionally designed templates that look great on the desktop version of FileMaker Pro 12 (for Macintosh or Windows), additional layouts for FileMaker Go 12 for iOS and built-in scripts in the Starter Solution automatically show the best layout based on your mobile device (either iPad or iPhone/iPod Touch). Here's what the iPad layout looks like:

Personnel List in iPad.

Personnel Detail in iPad.

You can work with this starter solution in your iOS device in several ways:

• You can sync it with your iPad or iPhone/iPod Touch using iTunes.
• You can email the file to your iOS device and open it with FileMaker Go 12.
• You can enable FileMaker Network Sharing in FileMaker Pro 12, and open the file remotely using FileMaker Go 12.

Enjoy!