| Claris FileMaker technologies provide simple and efficient ways to interact with distributed data |
|
| 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. |
|
|
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. |
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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.