Filemaker® Databases
The following databases are just a few examples of the various FileMaker® databases that I have created and maintained. The largest database was the SAi Bugs Database. This was a re-design used by employees and partners all over the world. It linked to other databases, such as the Projects database to auto-enter data based on project number and utilized over 100 custom scripts. All of the following databases contain many layouts/sections and multiple tables and relationships, some more complicated than others, and some containing complicated scripts to perform user functions.
Island Earth Studio can work with you to create a database for your home or business that makes your life easier and your information more accessible. The databases can run within FileMaker® if you already own it or we can make them stand-alone applications for Mac or Windows.
Client Tracking
Big Mouth Subs & Catering (left) came to me requesting a database to help them generate a list of clients and their order frequency so they could quickly contact their regulars. This stand-alone database can also generate reports on sales, deliveries, print client address labels and more.
Chico’s Vibe is a 9 piece party and event band. The Event Management database (right) was created to ease the management of the band’s gigs. It lets the manager handle referrals, member substitutions, contracts, playlists, to do lists, payments, contacts, and even maps to the venues. Everything the band needs to know about past, current, and upcoming events can all be found here.
Product Tracking and History
The Projects Database (left) was originally created for SAi, a software devloper, to keep track of product's disc numbers but quickly grew to include many important details for all software products to come out of SAi. Everything can be entered here including languages, release dates, specifications, security information, development status and tracking, and active and inactive discs for any project.
The Forrest Green Farm database (right) was designed to help them catalog and track the many herefords (cows) on the farm. The database stores gender, offspring, their weights at different times, purchase and sale information, photos and more.
Football Pool
The Football Pool was created for a little fun at work and home. It allows easy management and automated scoring for all players involved. Of course, no player can see the other player’s picks, so custom access privileges were used. Weekly and overall standings can be easily generated after each week’s play is complete. There are also special pages for administrative operations versus user operations. This database continues to grow and is probably the most complex database I've yet created. The image on the left shows the many tables and relations that are used to keep everything in order.
SAi Project Hours and Bugs Database
The Project Hours database (left) was created to record and track all hours worked by Engineering and QA on any specific project. This database utilized custom access privileges to enable managers’ extended access and limit access to all others. It was also very important to grant users access only to their own time cards. For the employee’s convenience, the account section also allowed them to keep track paid time off.
The Bugs Database (right) was used to track software defects and was accessed by the entire company. It was streamlined with over 100 custom scripts and functions to meet the specific needs of each department who used it. Special layouts were made to facilitate its worldwide use via web publishing by foreign offices and partners like HP, Canon, Graphtec, and Seiko among others. It is also linked to the Projects Database to easily jump to details of the related product.
