≡ Menu

24U Toolbox Plug-In Overview

24U Toolbox Plug-In is a robust FileMaker Pro plug-in which allows your FileMaker Pro databases to:

  • Execute FileMaker or System shell scripts to automate tasks inside/outside of FileMaker Pro
  • Execute SQL commands to develop faster and keep your solution clean
  • Match & replace regular expressions to find & replace text fast using patterns
  • Merge data values into text while maintaining styling to apply templates quickly and easily
  • Lookup DNS name for IP & vice versa to find out who is connecting from where
  • Get current public IP to know more about clients and discover potential security attacks
  • Define global keyboard shortcuts to avoid unnecessarily excessive use of script triggers
  • Obtain precise microsecond timestamps to measure nearly unmeasurable chunks of time
  • Get the type of a FileMaker variable to let your scripts make the right decisions
  • Share variables between databases to avoid creating too many external data sources

Execute FileMaker scripts or System shell scripts


24U Toolbox Plug-In is able to run “Bat” and “Visual Basic” scripts on Windows, and “AppleScript”, “Bash” and “PHP” scripts on Mac, and run a FileMaker script from places where the FileMaker software does not allow it – for example from conditional formatting, validations, and calculation fields just placing your mouse over the element.

Running FileMaker scripts dynamically lets you automate tasks better without requiring user interaction, running external scripts even extends this automation outside of the borders of FileMaker Pro to integrate your solution with other systems.

Execute SQL commands


Contrary to the built-in ExecuteSQL function, Toolbox_ExecuteSQL even allows for changing data in your FileMaker database using SQL.

Creating and modifying data in any table from any context without any relationships lets you develop faster and keep your solution clean without unnecessary utility structures.

Match and replace regular expression in text


Toolbox Plug-In will let you get the number of occurrences of strings, and search and replace the strings on the basis of regular expressions.

Using regular expressions allows you to find and replace portions of text even if you don’t know in advance what exactly you will be looking for but you know how to recognize it.

Merge data into text while maintaining styles


Instead of long lasting patterning using native function of the FileMaker software
Substitute(text; [search1; replace1]; [search2; replace2]; … [searchN; replaceN]),
24U Toolbox Plug-In ensures that just linking a text with values of fields or variables suffices.

With Toolbox_MergeText you can merge your data into carefully prepared text templates quickly and easily, while maintaining styling.

Lookup DNS name for IP and vice versa


Instead of browsing lots of Internet discussions about many possible and often complicated ways how to translate IP address to a hostname and vice versa, we have just one line of code for you that will say: “Translate!” to your FileMaker solution.

Ability to easily translate between IPs and hostnames makes it easy to understand who is connecting to your solution and from where.

Get current public IP


Toolbox Plug-In will return public IP address of the network from which FileMaker Pro is connecting, rather than the local network address returned by Get ( SystemIPAddress ).

Knowing the client’s public IP address lets you find out where the client is really connecting from, and easily discover potential security attacks.

Define a custom keyboard shortcut


Defining a custom keyboard shortcut allows user to assign a script to a particular key or to a combination of keys that will work across the whole FileMaker solution, without having to use script triggers.

Global keyboard shortcuts let you avoid having to set up a keystroke script trigger for every single layout and running it unnecessarily for every single key press when you only need a few shortcuts.

Obtain precise timestamp


Unlike native timestamp provided by the FileMaker Pro, 24U Toolbox Plug-In provides timestamp even with microsecond precision.

Such precise timestamps let you measure time elapsed between events immediately following each other, such as quick FileMaker script steps, or even calculations.

Get the type of a FileMaker variable


With 24U Toolbox Plug-In not only you can discover the type of a FileMaker field, but also the type of the value stored in a FileMaker variable, such as “Text”, “Number”, “Date”, “Time”, “Timestamp”, Container”.

Knowing the type of variable value lets your script make the right decisions because they can for example recognize that “123” is valid text result and not an error number 123.

Create a global variable outside of the database


Unlike standard global variables that are accessible only within single FileMaker database, and disappear when you close the database, 24U Toolbox Plug-In lets you create a global variable shared across multiple databases, and if you want, even survive after closing the database that created it.

Application-wide global variables are great for developing modular systems because they let you easily share temporary session data between multiple database files even without linking them through external data sources.


24U Toolbox Plug-In 2.0


24U Toolbox Plug-In 2.0 is the latest version of our plug-in, including the most useful calculation functions for daily use, which have been rewritten to be fully compatible with FileMaker Pro 16, and introduced with the following improvements:

  • Full compatibility with FileMaker Pro and FileMaker Pro Advanced
  • Stability on server was greatly improved
  • Better registration interface

Full 64-bit compatibility with FileMaker Pro


Unlike the previous version of the plug-in whose 64-bit support was focused and tested only on FileMaker Server, 24U Toolbox Plug-In 2.0 is now fully compatible also with FileMaker Pro 16 and FileMaker Pro Advanced 16 in both 32-bit and 64-bit architectures.

You can upgrade your FileMaker solution to the recent version of FileMaker Pro or FileMaker Pro Advanced immediately when you are ready and keep enjoying all useful features of the plug-in.

Improved stability on server


Thanks to the support for the 64-bit architecture, 24U Toolbox Plug-In can be used also with FileMaker Server where multiple tasks using the plug-in can happen to take place at the same time. Features of the version 2.0 have been redesigned to work reliably when the same plug-in is accessed from multiple threads and sessions simultaneously.

Better reliability and stability of the plug-in makes it safe enough for you to use even on a mission-critical FileMaker Server.

Better registration interface


The new version of 24U Toolbox Plug-In provides more ways to register the plug-in, and to find out whether the plug-in is registered even without user’s interaction.

The new possibilities of the registration interface allow developers to ensure that end-user comes into a contact with the registration interface only the way that’s desired.


Plug-In functions

24U Toolbox Plug-In provides all its functionality to FileMaker Pro and FileMaker Pro Advanced via the following set of calculation functions:

  • Toolbox_Version( { versionFormat } )
  • Toolbox_Register ( selector )
  • Toolbox_ExecuteSQL( SQLCommand { ; fieldSeparator { ; recordSeparator } } )
  • Toolbox_DoSystemScript( scriptText ; scriptInterpreter )
  • Toolbox_DoFileMakerScript( scriptName { ; scriptParameter } { ; delayOrTime } )
  • Toolbox_GetNameForIP( hostIP )
  • Toolbox_GetIPforName( hostName )
  • Toolbox_GetClientPublicIPAddress
  • Toolbox_GetSpecialWindows
  • Toolbox_GetPrinterNames
  • Toolbox_GetDefaultPrinter
  • Toolbox_SetDefaultPrinter( printerName )
  • Toolbox_SetScriptShortcut( key ; scriptName { ; scriptParameter } { ; scriptControl } )
  • Toolbox_RegExp_PatternCount( text ; searchPattern )
  • Toolbox_RegExp_Substitute( text ; searchPattern ; replaceString1 { ; replaceString2 … } )
  • Toolbox_MergeText( text )
  • Toolbox_ValueType( value )
  • Toolbox_Get( selector )
  • Toolbox_Set( selector ; newValue )
  • Toolbox_SetGlobal( key ; value { ; moreOptions } )
  • Toolbox_GetGlobal( key )
  • Toolbox_GetTimestamp
  • Toolbox_Encode( encoding ; text )
  • Toolbox_Decode( encoding ; text )

Examine the whole syntax description

System Requirements

The plug-in is fully compatible with FileMaker Pro 12, 13, 14, 15 and 16, and with FileMaker Server 12, 13, 14, 15 and 16.
Detailed compatibility table

Recomended configuration:

Mac OS X: Any Intel Mac, 4 GB RAM, macOS High Sierra 10.13 or newer, FileMaker Pro 16 Advanced or newer.
Windows: Dual Core 1.6 GHz processor, 4 GB RAM, Windows 10 or newer, FileMaker Pro 16 Advanced or newer.

Minimum requirements:

Mac OS X: Any Intel Mac since 2008, 2 GB RAM, Mac OS X 10.10 Yosemite, FileMaker Pro 13.
Windows: 1 GHz processor, 2 GB RAM, Windows 7, FileMaker Pro 13.

Products Sales Other