
From FileMaker's point of view, the MBS plug-in is the centerpiece.
The MBS plugin enables interaction with FileMaker and content from a web viewer placed on a FileMaker layout and acts as a kind of "bridge" between web viewer content and FileMaker. For example, the MBS plug-in can be used to query which menu item of a website has been selected within a web viewer, how many pages a PDF document has in the web viewer or which button has been selected on a website in the web viewer. In the current version, the MBS plug-in offers 44 functions for querying web viewer content directly in FileMaker. But that is by no means all that the MBS plugin provides for FileMaker developers: There are also functions from the areas of AppleScript, FileMaker container fields, SQLan extremely extensive library for image editing, slideshows, PDF files, system info and much more. You can find more detailed information about the functional scope of the MBS plug-in for FileMaker on the Website of the manufacturer. A license for five users costs 119 euros including VAT, a license for developers and unlimited distribution with own solutions costs 469 euros. The MBS plugin is essential for implementing the solution described below.
JQuery for the web-based part of the user interface.
The web-based menu itself is implemented with JQuery in the solution presented. JQuery is an extensive JavaScript-based class library that is particularly suitable for navigation. There are a number of free or inexpensive plugins for JQuery for navigation on websites that can be easily found using Google or other search engines. Some navigation plugins, for example, can be found on the official Website of JQuery to find. The latest version of the JavaScript class library is also available on this page. When selecting a suitable JQuery plug-in, however, care should be taken to ensure that it is not overly complex so that the underlying menu structure can later be easily mapped in FileMaker data fields.
The web viewer in FileMaker takes on a new meaning.
With the solution presented in this article, the web viewer in FileMaker takes on a much greater significance. From now on, it is no longer just a matter of displaying content from the Internet within a web viewer, but is used for nothing less than the main navigation within a FileMaker application.Database responsible. When using a web viewer as a navigation element, it becomes an integral part of every screen layout on which the central navigation is to be available. The advantage of navigation in a web viewer lies in the flexibility gained when expanding and sorting the available menu items. This solution also makes it easy to restrict or expand menu items based on various criteria such as user rights or status-related situations. In his article, developer Jens Liebelt recommends using a vertically structured menu, as the more extensive the menu items become, the more space on the screen quickly becomes too limited with a horizontally structured menu. With a vertical menu, it is also possible to use several levels without any problems - in his solution, a maximum of two sub-levels were implemented.
The abstraction of the menu in FileMaker
After installing the MBS plugin in FileMaker and selecting a suitable JQuery plugin, both technologies must be brought together within FileMaker - in other words, abstracted. For this purpose, developer Jens Liebelt only needs five database fields in his solution to transfer the model to the FileMaker database. The simpler the list structure of the JQuery menu, the simpler the abstraction in FileMaker. To display the menu in a FileMaker web viewer, a simple Script to create the local "website" (the menu). This local website contains the sliding menu and the callback scripts and is recreated after every change in the menu. Jens Liebelt uses TextWrangler to convert the typical FileMaker character set format UTF-16le to UTF8. The script in FileMaker is used to create the list (UL/LI) and the JavaScripts for working with FileMaker. The sorting of the menu items is also taken into account in the script.
Video shows details for the development of dynamic menus with JQuery.
To explain how his solution works in more detail, the developer has published a video tutorial:
FileMaker and JQuery are a perfect team for dynamic menus.
FileMaker developer Jens Liebelt shows in his Technical articlethat a web viewer in FileMaker can be much more than just an area for displaying web pages. With the web viewer and the MBS plug-in, it is possible to realize the entire navigation within a FileMaker database in a highly flexible way, whereby the entire creation and administration of the menu can also be realized within FileMaker.
Further information can be found on the Website of Jens Liebelt.

Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.



