Rosenworx

Medodex

Yo Yin Ga

Conran's

Cannabis Calculator

Books By You

Selected FileMaker Works

These are a few FileMaker databases that I have developed.

Rosenworx

All Titles SCreen

Rosenworx is a robust FileMaker system that managed data for Rosen Publishing for 10 years of expansive growth. Let's take a look at a few of the functions that make this database a powerhouse! Pictured above is the Titles Detail page. This screen serves as a dashboard for most users.

Scheduling Module

Rosenworx was originally created to replace expiring scheduling software. The resulting scheduling module's capabilities far surpassed the application it was replacing.

Catalog Overview Screen

Rosenworx saved many, many personnel hours in catalog production, reducing the time spent creating a catalog from several months, to several weeks. Rosen created about 12-17 different catalogs a year. significantly increasing the overall savings of production time, and the associated costs.

Catalog Page Screen 1

Not only can Rosenworx show the pagination of the catalog, but each element appearing on that page can be defined and every detail customized for that particular usage, including price, reading levels, and more.

Catalog Page Screen 2

Knowing what elements appear on what page, Rosenworx could then create entire indexes and tables of contents in seconds. This saved at least a week in production time by itself, as well as significantly reducing editorial corrections.

ISBNs Table View

Rosen purchases ISBNs (International Standard Book Number) in lots of 10,000. Rosenworx checks the validation of the ISBN's checksum, and can automatically select from the correct lot of ISBNs to assign an ISBN to a title set, series, or any other sales configuration stored in Rosenworx.And Rosenworx selects these assignments from the correct ISBNs assigned to each division.

TMF Page

Rosenworx allows the editors of titles to create "Title Marketing Forms", which contain data specific to how that title is to be marketed. This data is entered by the editor, but  requires a marketing supervisors approval. Rosenworx stores the data entered by the editor in a table until it is approved, at which point Rosenworx can push the  approved data to the main table.

Search Screen

Rosenworx can perform standard searches, advanced searches, and even can create custom found sets, given any list of ISBNs or primary keys.

Security Page

In addition to FileMaker's native security, Rosenworx performs many specific important functions that require additional permissions. These functions are managed by this "administrator only" page, where simple Boolean switches are set. These permissions are set in globals when the user logs in, and are referenced when the user attempts to go to screens, or to perform many advanced functions. This screen also controls what navigation is available to each user, as well as the custom menu sets available to each user or user group.

All Titles Table View

Naturally, all data can be viewed in multiple ways. Form, list, and table views are all readily available, and fully searchable wherever applicable.

RWx Online

Last, but certainly not least, Rosenworx also has a browser interface, that allows most functions to be accessed through a WAN, using the FileMaker API for PHP. Read-only screens open to modal windows for editing to ensure that all edits are securely and safely managed.

Client Billing and PTO Manager

The Time Billing module lets employees enter the amount of time that they spend on each billable job through their day. User definable presets helps speed up data entry. The system further allows client billing to privately process each employee's time at their individual rate, for the fastest, most efficient billing process possible.

The Days Off Request module allows employees to easily request individual days, or a range of days, off. The system includes supervisor approval functions, as well as the ability to request partial days off (long lunch breaks, doctor's appointments, etc.) Individual user presets stores commonly used requests for even faster use.

The Days Off Request module presents both employee and supervisor with all the data they need to request and approve days off, including seeing all employees that have requested the same day(s) off. Employees can also see an overview of how much time off they have used, and how much remains for the year.

The calendar view allows the user to view their requested and used days off in a familiar, convenient manner

Medodex Go

Mededex Screens 1

Medodex Go is a FileMaker Go app based on my popular Medodex hybrid app. Medodex allows people with chronic illness to access critical care information quickly and easily. There were several reasons for redesigning Medodex as a FileMakerGo app. Not the least of these being that with the addition of JSON parsing, it allowed for a backup and restore system using the JSON parsing functions.

Mededex Screens 2

Medodex makes it easy to stay in contact with your doctors and other healthcare personnel.With plenty of fields for storing specific data, alerts and reminders, and all the contact function that you would need, Medodex makes contacting and scheduling appointments a breeze.

Mededex Screens 3

Naturally, your medications are of paramount importance if you are chronically ill. Medodex can follow each medications history. From changes to dosage and scheduling to refill reminders to detailed reporting on medication costs, Medodex is uniquely poised to make the patient's life a lot easier!

Mededex Screens 4

As previously mentioned, backup and restore capabilities was easy to create using the JSON parsing functions. With just a few clicks you can send a backup of all user entered data in the system, and send it to any email you wish, for "offsite backup." Restoration is just as easy. Just copy/paste the data from the backup email you received into the collect field, and press Import. Your data will be fully restored!

Mededex Screens 5

Medodex can store lots of other data, including your pharmacies contact and personnel info, and your insurance data too. And don't worry, Medodex is password protected, to keep your data safe. and sound.

Yo Yin Ga

Yo Yin  Ga Screens 1

Yo Yin Ga is an app that I built for a professional yoga instructor to manage her classes, pupils, and fees for the classes. Yo Yin Ga lets the instructor keep a complete history of each pupils activities and financial position. Yo Yin Ga features a complete backup and restore system, utilizing FileMaker's JSON parsing functions.

Yo Yin  Ga Screens 2

The "card" and the calendar pages serve as home bases for the functions in Yo Yin Ga.

Yo Yin  Ga Screens 3

Yo Yin Ga will let the user view all classes and holidays in a day, a week, or in a custom, user set range. Adding a client to the class automatically deducts that class from the clients pre-paid card as soon as the instructor sets the class to "occurred."

Conran's Bridal Registry

Conran's Dashboard Screen

This powerful yet easy to use database system was created for internationally recognized designer Terrence Conran, for use in his high end shops in New York, London, and Paris. A powerful bridal registry system, Conran's employees can enter customer data, including their registry items, shipping addresses before and after the event, people involved in the event, and much more. A complete bridal registry system for a busy, sophisticated, high end point of sale.

Cannabinoid Infusion Calculator

Infusion Screen

With the legalization of cannabis around the U.S., I became interested in creating tinctures for edibles and tonics. I created this robust and accurate calculator to provide proper dosing. To begin, you enter the number of divisions you wish, and the desired dosage of each division. You then process your way back up until the calculator reveals the exact amount of cannabis needed to achieve your dose and divisions.

Recipes Screen

The calculator is also a recipe storage house. Recipes and tinctures are linked, and the linked tincture and recipe are displayed in all tabs.

Ingredients Amount Calculator

When cooking with cannabis, it can often be necessary to adjust the recipe to fit the tincture. That's why I added this simple yet powerful tool for adjusting the entirety of your recipe by the same amount. The new recipes can be saved and treated as independent recipes.

Books By You

BBY Screen 1

Books By You was a program put on by Rosen Publishing that allowed the families of U.S. service personnel to create and send personalized books from home to any U.S. base in the world, free of charge. This program helped service men and women to feel closer to their families while they were far away. Over 3,000 books were made and sent using this system.

BBY Screen 2

One of the functions of the BBY FileMaker system was to manage the BBY "back office", handling order fulfillment, customer orders, and more.

BBY Screen 3

Bar codes for "design kits" would be generated, as well as shipping labels to send the kits to customers. The barcodes could be read by the BBY system to quickly access all data related to that order.

BBY Screen 4

The BBY system used FileMaker as the "brain", automating the process of batch scanning the pages created by the customer, setting up the pages based on customer determined preferences, and printing the pages, including the cover. The operator would set the appropriate switches with the customer's decided prefs, hit the GO button, then do other work while the pages processed. The finished pages could be picked up, printed and ready for binding. Screens like the one above, were never "designed" because they were never actually seen by the operator, or any clientele. Images were stored as references to keep the file size low.

BBY Screen 5

The details of the Photoshop actions to be performed on the different pages were set by chunks of code set in FileMaker. This code was then auto-exported as files to the appropriate directory where Photoshop was expecting the file to be. This allowed each page to be automatically set up to the customer's specifications while still remaining fully automated.