{"id":4976,"date":"2014-08-20T09:41:03","date_gmt":"2014-08-20T08:41:03","guid":{"rendered":"https:\/\/gofilemaker.de\/?p=4976"},"modified":"2023-10-04T10:10:55","modified_gmt":"2023-10-04T09:10:55","slug":"extend-filemaker-with-plugins-and-custom-functions","status":"publish","type":"post","link":"https:\/\/gofilemaker.de\/en\/2014\/08\/extend-filemaker-with-plugins-and-custom-functions\/","title":{"rendered":"Extend FileMaker with plugins and custom functions."},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignleft size-full wp-image-1087\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-plugins.jpg\" alt=\"FileMaker plugins and custom functions\" width=\"84\" height=\"84\">Today, the FileMaker platform can be regarded as the most powerful <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>-management system. In its current version 13, FileMaker offers an unprecedented range of functions and can be run on Mac OS X, Windows and iOS. Despite the wide range of functions, FileMaker has already been offering two powerful features for several versions that allow FileMaker's range of functions to be increased even further. Firstly, FileMaker has the option of integrating any number of plug-ins, which are available in large numbers and can extend FileMaker with countless additional functions. With the so-called \"Custom Functions\", FileMaker also offers the option of developing your own functions, which can be called in the formula editor like any other normal function and can also contain any parameters. In this article, we explain the differences between plugins and custom functions and show how these two functions can be used optimally together.<!--more Weiterlesen &gt;&gt;&gt;--><\/p>\n<h2>FileMaker plugins - old hat?<\/h2>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-469\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/logo_troi_dialog_plugin.jpg\" alt=\"Troi plugins\" width=\"200\" height=\"106\">One <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/interface\/\" target=\"_self\" title=\"What is an interface in relation to FileMaker? An interface is...\" class=\"encyclopedia\">Interface<\/a> for external plug-ins has been part of FileMaker for well over 10 years. For example, the Dutch plug-in manufacturer <a href=\"http:\/\/troi.com\" target=\"_blank\" rel=\"noopener\"><strong>Troi<\/strong><\/a> external plugins since 1997, such as the well-known <em>Troi Dialog Plugin<\/em> or also the <em>Troi File Plugin<\/em> for FileMaker. Today, external FileMaker plug-ins are available for almost every purpose - whether for displaying dialogs, controlling scanners, creating diagrams as vector graphics, creating PDF files, sending and receiving e-mails or queries via the web - there are no limits to the possibilities with FileMaker plug-ins.<\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-1730\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/mbs_plugin3.jpg\" alt=\"MBS FileMaker plugin\" width=\"150\" height=\"150\">For some years now, highly integrated FileMaker plug-ins have also been available, which have a very wide range of functions or can be extended, for example, by developing your own routines. For example, the <a href=\"http:\/\/www.monkeybreadsoftware.de\/filemaker\/\" target=\"_blank\" rel=\"noopener\"><strong>MBS plugin<\/strong><\/a> by the German author Christian Schmitz from MonkeyBread Software now has more than 2,500 functions from a wide variety of areas. For example, the plugin allows you to send and receive (HTML) emails, <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>-Connection to <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/external-data-sources\/\" target=\"_self\" title=\"What are external data sources in FileMaker? An external data source is defined as...\" class=\"encyclopedia\">External data sources<\/a>, control of scanners, OCR text recognition, printer control, interface control for USB and MIDI or even the editing of images and PDF files. In addition to the extended range of functions, the plugin also offers improvements for developers: for example, the <em>Syntax Coloring<\/em> improves the readability of scripts and formulas, and the <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>-editor has line numbers.<\/p>\n<h3>Plugins only under Mac OS X and Windows<\/h3>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-4988\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-plugins-mac-windows-ios-web.jpg\" alt=\"FileMaker Plugins for Mac OS X and Windows\" width=\"457\" height=\"100\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-plugins-mac-windows-ios-web.jpg 457w, https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-plugins-mac-windows-ios-web-300x65.jpg 300w, https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-plugins-mac-windows-ios-web-180x39.jpg 180w\" sizes=\"(max-width: 457px) 100vw, 457px\">It is often said that where there is light, there is also shadow. This is also true for FileMaker plug-ins, as they only run on Mac OS X and Windows. <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/filemaker-go\/\" target=\"_self\" title=\"What is FileMaker Go? FileMaker Go is an app that...\" class=\"encyclopedia\">FileMaker Go<\/a> under iOS and <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/webdirect\/\" target=\"_self\" title=\"What is FileMaker WebDirect? WebDirect is a technology that allows...\" class=\"encyclopedia\">WebDirect<\/a> in turn do not support external plugins. Some developers therefore refrain from using external FileMaker plugins, but often only for solutions that are primarily intended for mobile use with FileMaker Go.<\/p>\n<p>For desktop solutions, plugins naturally offer a huge selection of new functions that can be used to extend FileMaker databases. For this reason, FileMaker plugins are by no means old hat, but provide unimagined flexibility in the development of FileMaker solutions. For solutions that are to be executed on the desktop as well as on iOS or WebDirect, however, it should be noted that no plugin functions are called in FileMaker Go or WebDirect. By the way, plugins are also called in <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/running-time\/\" target=\"_self\" title=\"What is a FileMaker Runtime? A FileMaker Runtime is a...\" class=\"encyclopedia\">Runtime<\/a>-solutions that can be created with FileMaker Pro Advanced.<\/p>\n<h2>Custom Functions - your own workshop.<\/h2>\n<p>With Custom Functions, the developer version FileMaker Pro Advanced has the option of developing your own functions and calling them in the formula editor like a normal function. Any number of parameters can be used. In this way, for example, custom functions can be developed that accept a value, perform a calculation with it and return the calculated value. Frequently used functions can therefore be combined in a <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/custom-function\/\" target=\"_self\" title=\"What is a custom function in FileMaker? A custom function is a...\" class=\"encyclopedia\">Custom Function<\/a> and call them up in the formula editor.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-4986\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-custom-functions1.jpg\" alt=\"FileMaker Custom Functions\" width=\"630\" height=\"423\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-custom-functions1.jpg 630w, https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-custom-functions1-300x201.jpg 300w, https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-custom-functions1-297x200.jpg 297w, https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-custom-functions1-180x120.jpg 180w, https:\/\/gofilemaker.de\/wp-content\/uploads\/filemaker-custom-functions1-500x335.jpg 500w\" sizes=\"(max-width: 630px) 100vw, 630px\"><\/p>\n<h3>Custom Functions for download<\/h3>\n<p>The option of implementing your own functions has been available for several FileMaker versions. For this reason, there are now a large number of custom functions available for FileMaker developers to download. Probably the most extensive and best-known archive of custom functions is the Web-<a href=\"https:\/\/gofilemaker.de\/en\/glossary\/portal\/\" target=\"_self\" title=\"Portal - see entry: Excerpt\" class=\"encyclopedia\">Portal<\/a> from <a href=\"https:\/\/www.briandunning.com\" target=\"_blank\" rel=\"noopener\"><strong>Briandunning<\/strong><\/a> represent. However, custom functions are also provided by other sources, such as the&nbsp;<a href=\"https:\/\/www.filemaker-magazin.de\" target=\"_blank\" rel=\"noopener\"><strong>FileMaker Magazine<\/strong><\/a>.<\/p>\n<h2>Encapsulate plug-in functions with custom functions<\/h2>\n<p>FileMaker plugins and custom functions can be combined perfectly for the sustainable development of FileMaker solutions. Because plug-in functions can also be called in a custom function, it is possible to encapsulate the functions of a plug-in or, if necessary, to combine them and optimize them for your own needs. The advantage of encapsulating plug-in functions is that the functions are easily interchangeable and work solution-wide even after replacement.<\/p>\n<p>Imagine you have developed a FileMaker solution that uses a specific plugin in many functions and scripts. Now a new version of FileMaker or the operating system appears with which the plugin no longer works or the plugin is no longer developed further and you now have to fall back on another plugin. In this case, you would have to search your entire FileMaker solution for all places where functions of the plugin are called in order to convert them to use the new plugin.<\/p>\n<p>You can prevent this tedious and error-prone work by outsourcing plugin functions to custom functions and calling the custom function in your scripts instead of the plugin function. In the event of a plugin replacement or function change, only the custom functions need to be changed and all functions will then work correctly again solution-wide.<\/p>\n<h2>Plugins and custom functions make FileMaker really flexible.<\/h2>\n<p>Even though FileMaker Pro 13 already has a very wide range of functions, it is worthwhile for developers to purchase FileMaker Pro Advanced, which offers other very helpful functions in addition to the Custom Functions, such as a script debugger or tools for creating runtime solutions or removing the administrator account in FileMaker solutions.<\/p>\n<p>Plugins can be used to extend the functional scope of a FileMaker solution as required. This applies to FileMaker solutions under Mac OS X and Windows as well as runtime solutions, but plugins are not supported in FileMaker Go on iOS and WebDirect. For the sustainable development of FileMaker solutions, it is advisable to encapsulate required functions as custom functions.<\/p>\n<p>If you like, you are welcome to leave your personal plugin recommendation as a comment.<\/p>","protected":false},"excerpt":{"rendered":"<p>Die FileMaker-Plattform kann\u00a0heute als das wohl m\u00e4chtigste Datenbank-Management-System bezeichnet werden. In seiner aktuellen Version 13 bietet FileMaker einen bisher noch nie erreichten Funktionsumfang und ist auf Mac OS X, Windows und iOS lauff\u00e4hig. Trotz des hohen Funktionsumfangs bringt FileMaker bereits seit einigen Versionen zwei m\u00e4chtige Features mit, die es erlauben, den Funktionsumfang von FileMaker noch [&hellip;]<\/p>\n","protected":false},"author":187,"featured_media":33532,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":16,"footnotes":""},"categories":[3,4,1,5],"tags":[],"class_list":["post-4976","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemakergo","category-filemaker-plugins","category-filemakerpro","category-tipps-anleitungen"],"_links":{"self":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/posts\/4976","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=4976"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/posts\/4976\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/media\/33532"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/media?parent=4976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/categories?post=4976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/tags?post=4976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}