Synergize Example UI with SQL App
NOTE: It is recommended that you work through the Example_PHP_APP before trying this App, as deploying this App is slightly complicated.
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:
1 Will Ferrell
2 Christina Applegate
3 Paul Rudd
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.