#clickworks

The Boys from Belgium – FileMaker Developer Interview – YouTube

This was my first interview with 3 people at once:  The Boys from Belgium: Joris Aarts, Jeroen Arts, and Jan Stieperaere, all with ClickWORKS in Belgium.  You may have heard of Jan recently:  He discovered and blogged about a technique to Perform Script on Client (PSOC, not to be confused with PSOS–Perform Script on Server).  This…

Instantly Restore Deleted FileMaker Records

  Instantly Restore Deleted FileMaker Records?  How is that possible?  As it turns out, it’s not that all that hard, but does require some up front planning.

The secret is to put new related table in front of the table with the data, and relate the new table to the old table based on the primary key.  The new table has only the one primary key – all other data is pulled into the layout from the…

Trigger a script on another FileMaker client – YouTube

  I posted on ClickWork’s trick to trigger a script on a remote client back in August, and was very impressed with the concept.  Richard Carlton likes it so much he made a video demonstrating some of the possibilities:

Published on Jan 7, 2015

FileMaker does not natively contain this ability on its own… and normally it would take a Plugin… to get the ability to have one client start a script……

Export FileMaker to Excel with custom column names

  The need to export FileMaker data to Excel with custom column names is something most developers will encounter from time to time.  Face it, people don’t want to read obscure column names or try to figure out what they really mean when they need to change them.  Jeroen Aarts of Clickworks shares his technique:

Could you please be more specific?

Well, OK then, our solution relies on:

Creating…

Rename container files on the fly | Clickworks

Yet another nice feature of Base64Encode:  Rename files embedded in a FileMaker container field with a script step.  Without exporting and importing:

This technique makes use of FM13’s new Base64Encode() & Base64Decode() functions. When decoding a base64 string, filemaker gives you an optional parameter to specify a filename. This is the key to rename your container file.

The total function…

Trigger a script on a different FileMaker client

A VERY CLEVER WAY to trigger a script on another #filemaker client by #clickworks.  The core secret is to use the #onrecordload script trigger to run when a user deletes a record on the remote client.  Since it is a script being triggered, almost anything you can script can be triggered on the remote host.  

Concept This technique can be used to trigger every desired script on another user’s…