{"id":586,"date":"2011-03-27T19:04:26","date_gmt":"2011-03-27T19:04:26","guid":{"rendered":"https:\/\/gofilemaker.de\/?p=586"},"modified":"2022-03-29T07:39:03","modified_gmt":"2022-03-29T06:39:03","slug":"dynamic-navigation-with-filemaker-jquery-mbs-plugin","status":"publish","type":"post","link":"https:\/\/gofilemaker.de\/en\/2011\/03\/dynamic-navigation-with-filemaker-jquery-mbs-plugin\/","title":{"rendered":"Dynamic navigation in FileMaker with JQuery and the MBS plugin."},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignleft wp-image-609 size-full\" title=\"Dynamic navigation in FileMaker with JQuery and the MBS plugin\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker_dynamische_menues_artikelbild1.jpg\" alt=\"Dynamic navigation in FileMaker with JQuery and the MBS plugin\" width=\"160\" height=\"170\">A layout-based user interface can be realized in FileMaker in different ways. The easiest way is certainly to simply place buttons on the layout, label them and assign scripts to them. Although this method is the quickest, it is also the least convenient solution. As soon as a menu item is to be added or the sorting of the menu items is to be changed, this often has to be done on many layouts and therefore takes a lot of time. A somewhat more flexible method for a navigation menu in FileMaker is the use of corresponding global fields. In the global fields, the label for a button is saved as a text field and, if necessary, the button itself is saved as a container field and called up on the layout. Global so that the buttons can also be displayed in search mode. This approach is more flexible than the first method mentioned, but it is relatively complex to implement and therefore also very time-consuming. Jens Liebelt takes a completely different approach, creating dynamic menus in a web viewer with the help of <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/jquery\/\" target=\"_self\" title=\"What is JQuery in FileMaker? jQuery is a free JavaScript library that...\" class=\"encyclopedia\">JQuery<\/a> and the MBS plug-in. This gives FileMaker databases a highly modern, very flexible and yet easy-to-administer user interface - naturally also with practically limitless possibilities in terms of animation or menu structure. This article explains what is behind this in detail. <!--more Weiterlesen &gt;&gt;&gt;--><\/p>\n<h3>From FileMaker's point of view, the MBS plug-in is the centerpiece.<\/h3>\n<p>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, <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/sql\/\" target=\"_self\" title=\"What is SQL and what is SQL used for? SQL (Structured...\" class=\"encyclopedia\">SQL<\/a>an 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 <strong><a title=\"MBS plugin function overview - Overview of all functions of the plugin.\" href=\"http:\/\/www.monkeybreadsoftware.de\/filemaker\/reference\/\" target=\"_blank\" rel=\"noopener\">Website of the manufacturer<\/a><\/strong>. 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.<\/p>\n<h3>JQuery for the web-based part of the user interface.<\/h3>\n<p>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 <strong><a title=\"JQuery plugins for navigation within FileMaker databases.\" href=\"http:\/\/jquery.com\" target=\"_blank\" rel=\"noopener\">Website of JQuery<\/a><\/strong> 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.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-604\" title=\"Calculation of JavaScripts directly in FileMaker.\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_javascript.jpg\" alt=\"Calculation of JavaScripts directly in FileMaker.\" width=\"630\" height=\"518\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_javascript.jpg 630w, https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_javascript-300x246.jpg 300w\" sizes=\"(max-width: 630px) 100vw, 630px\"><\/p>\n<h3>The web viewer in FileMaker takes on a new meaning.<\/h3>\n<p>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.<a href=\"https:\/\/gofilemaker.de\/en\/glossary\/database\/\" target=\"_self\" title=\"What is a database? A database (database system, DBS) is understood to be...\" class=\"encyclopedia\">Database<\/a> 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.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-603\" title=\"Manage dynamic menus directly in FileMaker.\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_administration.jpg\" alt=\"Manage dynamic menus directly in FileMaker.\" width=\"630\" height=\"519\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_administration.jpg 630w, https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_administration-300x247.jpg 300w\" sizes=\"(max-width: 630px) 100vw, 630px\"><\/p>\n<h3>The abstraction of the menu in FileMaker<\/h3>\n<p>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 <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/script\/\" target=\"_self\" title=\"What is a script in FileMaker? A script can be used in a FileMaker database to create any...\" class=\"encyclopedia\">Script<\/a> 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.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-605\" title=\"FileMaker script for editing the dynamic menus\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_script.jpg\" alt=\"FileMaker script for editing the dynamic menus\" width=\"630\" height=\"557\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_script.jpg 630w, https:\/\/gofilemaker.de\/wp-content\/uploads\/dynamische_menues_filemaker_script-300x265.jpg 300w\" sizes=\"(max-width: 630px) 100vw, 630px\"><\/p>\n<h3>Video shows details for the development of dynamic menus with JQuery.<\/h3>\n<p>To explain how his solution works in more detail, the developer has published a video tutorial:<\/p>\n<p><object width=\"630\" height=\"519\" classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http:\/\/download.macromedia.com\/pub\/shockwave\/cabs\/flash\/swflash.cab#version=6,0,40,0\"><param name=\"src\" value=\"http:\/\/www.youtube.com\/v\/6WdBklExMpI&amp;feature\"><embed type=\"application\/x-shockwave-flash\" width=\"630\" height=\"519\" src=\"http:\/\/www.youtube.com\/v\/6WdBklExMpI&amp;feature\"><\/embed><\/object><\/p>\n<h3>FileMaker and JQuery are a perfect team for dynamic menus.<\/h3>\n<p>FileMaker developer Jens Liebelt shows in his <strong><a title=\"Dynamic menus with FileMaker, MBS plugin and JQuery\" href=\"http:\/\/www.jens-liebelt.de\/filemaker-pro\/filemaker-dynamische-menues.html\" target=\"_blank\" rel=\"noopener\">Technical article<\/a><\/strong>that 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.<\/p>\n<p>Further information can be found on the <strong><a title=\"Jens Liebelt - FileMaker developer\" href=\"http:\/\/www.jens-liebelt.de\/\" target=\"_blank\" rel=\"noopener\">Website of Jens Liebelt<\/a><\/strong>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Eine layoutbasierte Benutzeroberfl\u00e4che kann in FileMaker auf unterschiedliche Art und Weise realisiert werden. Der einfachste Weg ist sicherlich, einfach entsprechende Schaltfl\u00e4chen auf dem Layout zu platzieren, zu beschriften und ihnen Scripte zuzuweisen. Diese Methode ist zwar die schnellste, aber auch die unkomfortabelste L\u00f6sung. Denn sobald ein Men\u00fcpunkt hinzugef\u00fcgt oder die Sortierung der Men\u00fcpunkte ge\u00e4ndert werden [&hellip;]<\/p>\n","protected":false},"author":187,"featured_media":32984,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":9,"footnotes":""},"categories":[16,4,1,5],"tags":[],"class_list":["post-586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemaker-loesungen","category-filemaker-plugins","category-filemakerpro","category-tipps-anleitungen"],"_links":{"self":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/posts\/586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/users\/187"}],"replies":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/comments?post=586"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/posts\/586\/revisions"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/media?parent=586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/categories?post=586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/tags?post=586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}