<-- This example FileMaker order form uses calculations and functions to help authorized salespeople securely connect to and correctly process sales orders, using PHP scripts to interact with 3 SQL databases and 5 REST APIs in real-time.

In 2024, Adobe Acrobat, Claris FileMaker, Microsoft Excel, and Google Sheets can all be extended with PHP to enable securable dynamic bi-directional data interactions between users, SQL databases, REST APIs, or cloud services.

Forms that can calculate can also communicate, using native functions to validate, format, and send user-supplied parameters to PHP scripts that interpret the parameters, execute queries based on the parameters, filter the query responses, and return the results to specified form fields in real-time.

Each type of form provides different advantages depending on use case.

Any type of form can interact with any number of databases or APIs in any combination or event sequence, dynamically calculating, querying, parsing, merging, recalculating, and updating as users enter data in to form fields.

Completed form results can be packaged into virtually any required format and sent to virtually any specified location for additional processing. Nice!

Adobe Acrobat

Acrobat PDF forms provide extraordinarily adaptable programmable interfaces that can be used as freely deployable data calculation and interaction runtimes. Acrobat forms can be enhanced with JavaScript to add interactivity, making it possible to dynamically calculate, validate, and format data prior to sending it to PHP scripts that interact with SQL databases and REST APIs and insert filtered results back into form fields.

Claris FileMaker

FileMaker database documents can calculate and execute queries that use PHP, PDO, cURL, and ODBC to interact with SQL databases, REST APIs, and cloud services. FileMaker's form tools provide extremely advanced calculation, scripting, and data processing control, excellent for building programmable interfaces that can be shared securely via FileMaker Server, as FileMaker documents, WebDirect forms, or FileMaker Data API.

Excel & Sheets

Microsoft Excel and Google Sheets spreadsheet documents can also use calculations and native functions to execute PHP scripts that interact with SQL databases and REST APIs. PHP scripts can filter and format scalar or aggregate query responses back to active cells in a variety of formats, including Excel dynamic arrays generated from XML-formatted results and Sheets dynamic arrays generated from HTML-formatted results.

This PHP script executes a SQL query that returns summarized sales results...

This PHP script queries a REST API and returns a specified currency exchange rate...

This PHP script inserts a record into a SQL database and returns a unique identifier...

PDO can interact with lots of databases...





cURL can interact with practically any API...





ODBC can interact with databases or APIs...



Place PHP scripts on your server, then...

utilize real-time
SQL or REST API query results in spreadsheet calculations...

share calculating web forms that merge data from distributed and disparate sources...

execute key performance indicator or complex aggregate queries in real time...

add dynamic
SQL or REST API Create, Read, Update, Delete capabilities to Acrobat PDF forms...

deploy really, really, really well connected desktop and mobile workgroup apps



Extending documents with PHP means...

Minimal code



Minimal expense



Minimal dependencies



“Insanely efficient, ridiculously cost-effective.”


“Simplified, lightness added.”


“That is way, way, way less complicated. Thank you!"




Web-enabled desktop or mobile interfaces, simple deployment, minimized dependencies, integrating disparate technologies to build simple or complex data automation solutions.

Take a look at the examples at the top of the page and e-mail with any questions. Thanks!