Super-smart well-connected real-time data interfaces. Boom.

Claris FileMaker technologies provide simple and efficient ways to interact with distributed data
  • FileMaker Pro is an Apple or Windows desktop application that builds programmable database interfaces
  • FileMaker Server provides simple and reliable ways to securely share FileMaker Pro interfaces
  • FileMaker WebDirect is a service that publishes FileMaker Pro interfaces as HTML forms
These technologies can be used by individuals or teams to design, connect, share, and iterate real-time process automation interfaces that enable authenticated users to search, input, upload, update, calculate, sort, merge, print, send, or run parameterized scripted processes using data from single data sources or combinations of FileMaker, MySQL, SQL Server, Oracle, or PostgreSQL databases or APIs.
  • create new or auxiliary interfaces that connect and add functionality to existing systems
  • design interfaces with pixel-level control of fields, labels, buttons, grids, navigation elements
  • add relational logic, calculations, custom functions, scripted processes, or event triggers as required
  • use AI to generate PDO and cURL scripts that execute parameterized queries on SQL databases or APIs
  • utilize PDO prepared statements and typed data parameters for safer and more injection-resistant queries
  • filter and return query results to form fields in real-time, conditionally update related form calculations
  • define privilege sets, field-level security permissions to determine user access and capabilities
  • print pixel-perfect reports, PDFs, labels, tags, cards, export filtered data in custom formats
  • share forms interfaces with up to 1,000 authenticated desktop, web, or mobile users
Extraordinarily fast solution development, simple management, minimal investment. Hosted FileMaker solutions cost less than $1.00 US per day per user for unlimited forms interfaces and scripted processes. PHP, SQL, PDO, cURL, JavaScript, PDF are open-source.

No SaaS subscriptions, transaction fees, security concessions, or third-party dependencies. You own the code.

Experienced FileMaker programmers are available at $80.00US/hour for custom programming services.

FileMaker

Claris FileMaker is an extremely versatile application, integrating best-in-class form builder with relational database engine, advanced calculation editor, scriptable process automation controls, securable authentication and session management. FileMaker files can be shared with up to 1,000 users via desktop application or WebDirect forms, and can optionally be extended with PHP to enable real-time interactions with SQL databases or APIs.

PHP

PHP is a popular general purpose server scripting language, currently used on approximately 75% of websites globally. PHP Data Objects (PDO) and cURL code libraries provide efficient, securable, injection-resistant methods for performing database, API, or file system processes. PHP is open-source technology, meaning no licensing costs, transaction fees, or subscriptions are required to own and use simple, reliable, industrial strength code.

Artificial Intelligence

We take full advantage of Anthropic's Claude-related Large Language Models (LLMs) to generate commented PHP, SQL, PDO, cURL, and FileMaker scripts that define connections and interactions between interfaces, databases, APIs, and file systems. We occasionally use Text2SQL.ai to generate more complex SQL code if required. We also utilize OpenAI ChatGPT LLMs to describe and generate semantically related word lists for images.

What kind of solutions can be built with FileMaker technologies?


Accounts Payable Enhancements

Created to enable a department to track and examine expenses in greater detail than a legacy accounts payable system could easily accommodate. Information from incoming invoices is extracted and classified by departmentally defined project, matter codes, and attributes. A subset of the data is summarized to print payment request forms in the format expected by the legacy system, while additional data is used to create detailed reports and exported for pivot table analysis.

Bulk E-mail Automation

When a corporate e-mail server suffered an unrecoverable failure immediately prior to its scheduled daily backup, a database was quickly built that could parse the server's transmission logs and send each user an individual message listing details of messages lost in the failure. The technology was later used to automate mass transmission of individually tailored messages including encrypted and compressed file attachments.

Corporate Brand Protection

This system integrated four legacy databases into a single resource, creating a coordinated mechanism for brand protection services while providing a searchable catalog of trademark infringement, opposition, and counterfeit intelligence. Users in North America, Asia, and Europe maintain the database, with related documents and images imported, cataloged, and stored on a secure intranet server and retrieved via standard web browser.

Corporate Secretary

Tracking corporate information for a portfolio of 100+ international companies — including reporting obligations and deadlines, shareholder and board member details, directorships, share distributions, policy statements, by-laws, charters, and minutes — this system was co-developed by administrators on three continents working collaboratively on interface and functionality iterations.

Currency Exchange Utility

Programmed to query a REST API containing exchange rates for 170 countries, this utility parses rate information and builds a comparison table of each currency's units per base rate and base rate per unit. Updated information is then passed into an accounts payable database for inclusion in currency-related calculations.

Distribution List Manager

This database repackages data extracted from a legacy mainframe directory application to create an MS Exchange server's e-mail distribution list input file. Administrators gain precise control over rules for defining list membership and error detection in e-mail address components. The system also serves as an enhanced corporate directory with hierarchical departmental cross-references and comprehensive records on 14,000+ employees, contractors, and temporary workers.

E-commerce Video Catalog

Utility databases that provide a simple way to incorporate video content into e-commerce product listings. Adapted to existing systems, they make it significantly easier to correctly add, modify, or delete product information in Shopify or WooCommerce catalogs containing unlimited numbers of products.

E-mail Message Parser

A department required the ability to process web form submissions without adding database functionality to the web server. A database was built to batch-collect forwarded e-mail messages from the CGI, parse out relevant data, and transfer it into dynamically created records in a multi-user database.

Event Log Monitor

A rules-based database that runs scheduled examinations of server event logs seeking specific administrator-defined error messages. Once a target error is detected it can trigger a variety of actions including running commands, scripts, and batch processes, or sending e-mail alerts, pages, or SMS reports.

Information Merge Editor

When two departments discovered overlapping data collections with no common field to relate them, a database was built that used multiple criteria to compare components in each collection, narrowing potential matches to a pick list. A workgroup was trained to make final selections based on visible record properties, and the two collections were accurately merged in a single afternoon.

Intranet Forms

After evaluating various commercial electronic forms management applications, a database system was built to transfer paper business forms into electronic format. Form designers can scan paper documents or build layouts from scratch, embedding complex calculations, conditional pop-up choice lists, relational lookup fields, and rich online help. Deployed via FileMaker WebDirect, users fill out forms using a standard web browser with real-time data collection and automated procedures triggered by submitted data.

Inventory Control and Point-of-Sale

A busy specialty retail consignment business with hundreds of thousands of consigned items across 16 locations in three states needed a centralized solution to better manage inventory. A database system was created utilizing the company's established business logic, providing a simple forms-based interface for point-of-sale functions and a central administrative interface for generating payment checks.

Jewelry Evaluation Calculator

A fine jewelry appraisal company's growth was being limited by the lack of automated processes for appraisers to describe and accurately price client items. A database was built that translated the company's business logic and methods into forms with multi-parameter lookups and dynamic calculations, generating high-quality appraisals along with optional Report Cards and e-mailable PDFs.

Litigation Reference

Providing attorneys a simple method to keep accurate tabs on various litigation management components, this system is a searchable catalog of detailed court and counsel information, case analysis, litigation types, case statuses, key dates, parties involved, damages claimed, and depositions scheduled. It also tracks legal fees by vendor, invoice, and date, and provides links to the accounts payable system for drill-down fee detail.

Microfiche Index

This database references 250,000+ pieces of jacketed microfiche. An error-checking utility was first built to import the catalog data from a legacy mainframe application, then a reference application was built to contain file classifications, data type descriptions, and retention schedules. A purge module and web-enabled search interface for authorized users were also developed.

Off-site Records Storage

A searchable database of 200,000+ folders stored in 66,000+ containers, indexed by file classifications, key dates, and user-supplied content descriptions. A web interface enables authorized users to search for and request retrieval of records storage contents.

Technical Recruitment

This system makes it easier for a technical recruitment service to quickly and accurately match candidates to open positions. Incoming job orders and resumes are verified and entered into separate tables; relational links are created as recruiters match positions to candidates, with all transaction activity logged chronologically and viewable from either the jobs or candidates record.

Trademarks Management

Developed by a licensing department to track 9,500+ trademark registrations and associated certificates, this system is accessed by users on three continents to monitor general trademark information and maintain a docket of scheduled registrations, renewals, affidavits, and follow-up actions. The database stores 22,000+ thumbnail images linked to high-resolution certificate scans on a secure intranet server.

“Extraordinarily efficient, ridiculously cost-effective.”


“Simplified, with added lightness.”


“That is way less complicated. Thanks!"


Desktop, web, or mobile interfaces, simple deployment, minimal requirements, connecting disparate technologies to build simple or extremely complex data automation solutions.