Mark's databases
I envison, design, build and maintain data structures in FileMakerPro. Here are some of the larger databases i've built. For obvious reasons it's not possible to make system access availible widley so i have some brief descriptions and a few screenshots of the active systems.

Jajeongeo
A bicycle touring organization needed to combine paper and primitive computer records to track tours, clients, partners, interest, mailings, publications and more. I created a 9 table relational database with extensive scripting to manage present and future as well as 30 years of historical data. As of 2021 i continue to support this system. (2015 - present)

screenshots: home screen, Client list, Client view, Tour view, Tour report, Nation view, relationship graph

Furt
A 25-table, heavily scripted, relational database which tracks the Rosters, Player transactions, Season, Club and Match statistics for a national professional soccer league. (2014 - present)

screenshots: home screen , Player view, Club view, Match view, Match summaries, relationship graph sample

AKA
A committe that and deploys volunteer HAM radio operators to support public events and emergency preperation needed a way to contact, track and assign volunteers. I led a team that built a heavily scripted multi-table relational database that tracks volunteers, events, assignments and paperwork, it allows web registration and email distribution of documents. (2014 - 2019)

screenshots: home screen, Events list, Episode view, Assignment form view
For privacy reasons no Registration or Person views are availible.

Canvintory
An art collector moving from a family home to a small condo needed to manage the distribution of the collection. I built and managed a small flat file, photo centered, on demand, web based, ipad inventory system which grew to include all contents of the house. (2014 - 2017)

screenshots: home screen , Item photo, Item details , full Item view, list view , Action buttons

Ashtabula
An inner city youth leadership/bicycle advcocay agency neeeded to combine records kept on paper and in the founders' heads. I created a large multi-table relational database with scripting which tracks the interwoven progress of bicycles, youth and adult volunteers through series of classes and events at the organization. (2013 - 2018)

screenshots: home screen , Adult view , Youth view , Youth visits

Panthera
A coffee delievery start-up was upgrading versions of FMP. I was a subordinate member of the small team that rebuilt the entire driver interface inventory database system. This included live iPad logins, internet presence and large document managment. (2014 - 2016)

For confidentiality and security reasons no views are availible.

FFIS
A major international film festival had a 20 year old 40 file FMP database system that was failing. I rebuilt the internal structure, created scripts and subsystems for new procedures. I taught users the system. As of 2021 i continue to maintain portions of the structure and support users. (2016 - present)

For confidentiality reasons no views are availible.

Zug
A nested table relational database heavy on real time numerical calcuations. Built for personal use. (2007 - present)

screenshots: home screen, train list, train view

ultrachek
A flat file, scripted database for tracking ultramarathon rest stop check ins and check outs. (2007 - present)

screenshots: home screen, check in times, check in grid

Qrapple
An innovative multi-table relational database built for personal use. Tracking border crossings and time spent in nations and states. This database uses conditionals and scripting to repurpose tables based on situations. Previous versions in other systems go back to 1984. (2005 - present)

screenshots: opening splash, settings view, Border Crossings list, Crossing view, Nations list, Nation view, Territories list, Continents list, relationship graph

eBase+
A state-wide Bicycle Transportaion Advocacy organization acquired a membership/ donorship managment template that needed management and expansion. With extensive volunteer help i customized, refined and managed the system and added an Auction module. (2001 - 2009)

For confidentiality and security reasons no views are availible.

fiets mijlen
A multi-table calculation heavy relational database to track bicycle milage. Built for personal use. Utlizes an innovative system of relationships to create columnar calender calculations. Previous versions in other systems go back to 1985. (2009 - present)

screenshots: home screen, miles by year & month highlighted by era, miles by month & day, relationship graph calednar section

back to mrk.land