Web Inspector for FileMaker Pro’s web viewers
Tips and Tricks #2
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 ?
Tips and Tricks #1
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
FileMaker Pro version 19.0 marks the arrival of a very special feature, the FileMaker.PerformScript(script, parameter) function;