If you want to trigger scripts with our Troi Activator Plug-in or Troi Serial Plug-in or use Drag and Drop with our Troi File Plug-in script triggering may not always work with FileMaker files created in FileMaker Pro 19.2 and later.
Rob Salusbury wrote to us that he is using our Troi URL plug-in to make FileMaker Pro into an incredibly powerful web client, in particular for communicating with SQL databases.
He thinks we are sitting on a real game changer that potential customers might not be aware of. Combined with Troi File and Troi Encryptor it delivers the ability to create very fast (VERY fast), very secure SQL applications that provide a ton of extended capabilities over any browser-only based solutions.
You can find the quote on our comments page.
The link below points to a page on his site that explains a little more about the concept.
http://customdataservices.net/sqlclients.htm.
We have to admit we don’t completely understand how this works, so you’ll have to quiz him on the details. We are amazed what our users can accomplish with the help of our plug-ins.
Many more functions
This is just one of the functionalities added by the Troi URL Plug-in. Another possibility is for example to send tweets to Twitter.
On the Troi URL Plug-in page you can download a fully functional demo with all the functions explained:
www.troi.com/software/urlplugin.html
It is a great and easy way to enhance your database for you or your customers.
You can get this list easily into FileMaker Pro with the TrFile_ListFolder( ) function. In ScriptMaker add this script step to a script:
Set Field [ result, TrFile_ListFolder( “-Files -Folders” ; “Mac HD:”) ]
This will return a text list of all files and folders on the hard disk “Mac HD”. The two switches -Files and -Folders indicate you want both types returned. This might return for example this:
Test.fmp12
Desktop Folder
Program files
Financial report.xls
and so on…
Continue Reading
FileMaker is a powerful database, but it cannot do everything. Luckily you can extent FileMaker Pro with plug-ins. Troi Automatisering has been creating several plug-ins since 1995.
FileMaker plug-ins can be found here: