Synergize Example UI with SQL App

Synergize Apps are simply bundles of HTML, Javascript, PHP, CSS, images, etc, that have been packaged into a single FileMaker container. These can then be used within FileMaker by creating FileMaker functions to provide access to the app’s features.

NOTE: It is recommended that you work through the Example_PHP_APP before trying this App, as deploying this App is slightly complicated.

Click the link to read a detailed guide on how to Deploy a Synergize App, & replace the Example App on the guide with the App on this page.

Contents of the files required for the Synergize Example UI with SQL App

Information required to Deploy & test the UI with SQL App

When this app is deployed, a single function will be created in FileMaker:

Synergize_App_UI_Table_View ( columns ; table )

Assuming Synergize is listening on port 9191, running this function would cause Synergize to generate the URL based on the parameters provided:

Synergize_App_UI_Table_View( “id,name” ; “sample_table” )

If a web viewer would be set to this URL, either by assigning this function as the URL, or by setting it in a script, the contents would look like this:

id            name

1              Will Ferrell

2              Christina Applegate

3              Paul Rudd

The Javascript required to run this app may look fairly complicated, but is actually quite simple. First, it uses the request ID provided by Synergize to get the remaining parameters provided by the user. After it has these, it creates the table header using the comma separated list of columns. Then, it creates an SQL query to find the data in that table, and builds the rest of the table with the results.

As well as being able to run SQL queries, Synergize is able to evaluate any FileMaker function (e.g. “Get(FileName)”), or even trigger a script to be run. With this, you can create powerful dynamic UI elements, which can be used by any FileMaker developer without them needing to understand what is happening under the hood.

Click the link to the right to download the files for this Synergize App.