All News
Tips and Tricks #2
![](/images/articles/addon_description_contenu/800x600/json.png)
JSON : Using the dot "." as a key element with FileMaker's JSON functions
In FileMaker's JSON function the dot "." is used as a delimiter to navigate between a JSON structure's elements.
But how to use the dot "." inside a key without having FileMaker interprates it as a delimiter ?
Ex :{"a.b":1}
Tips and Tricks #1
![](/images/illustrations/astuces/800x600/photo_8.jpg)
Let’s remind 2 tips that are as old as the world in FileMaker, but that we still use every day:
Sort an external table on one or more fields of other occurrences
Let's take a simple example, your database has 3 tables, schools, classes and students. At the relational level, students belong to a school and a class, and classes belong to a school. Which gives us the following relationships graph:
Update FileMaker.PerformScript and FileMaker.PerformScriptWithOption
![](/images/illustrations/800x600/fmp_icon.png)
FileMaker Pro version 19.0 marks the arrival of a very special feature, the FileMaker.PerformScript(script, parameter) function;
This function is not a FileMaker Pro calculation function, it is actually a JavaScript function, it allows you to call your solution’s scripts directly from your Web Viewers! This function is the logical continuation of the script call via the fmp:// protocol.
Web Inspector for FileMaker Pro’s web viewers
![](/images/illustrations/web_inspector/800x600/web_inspector.gif)
If like many developers you use webviewers to interact with your FileMaker solutions, you may have noticed that it is not so easy to debug the content of a webviewer, whether for HTML / CSS rendering or the execution of your JavaScript code.