Kevin Frank | 29 May 05:48 2015

[FileMaker Hacks] PDF Thumbnails in FileMaker 14


If you work with digital images, you’ve probably noticed the trend 
towards using PDFs as an image file format. I doubt many of use could 
have foreseen this happening when the PDF format was introduced in 1993, 
but in many organizations PDF has become the standard file format for 

The good news is that the GetThumbnail function now works with PDFs in 
container fields in FileMaker 14, and in this article I’m going to 
suggest a couple reasons why you might find this useful, and explore 
some nuances between how PDFs in container fields behave on the Mac vs. 
how they behave on the PC.

Kevin Frank & Associates
kfrank <at>
FileMaker 7/8/9/10/11/12/13 Certified Developer
FMPexperts mailing list
FMPexperts <at>
(Continue reading)

Bob Patin | 28 May 18:26 2015

Problems with using a bluetooth scanner with an iPad & touch kbd.

My client has a bluetooth barcode scanner paired with his iPad; it works great. 

The problem: when he’s paired with the scanner (which he’ll always be), and then taps into a field to
input some text, the touch keyboard doesn’t come up because I assume that the iPad is looking for input
from the BT scanner.

I tried invoking the script step

Enable Touch Keyboard [ On ]

when he enters a text field, but it didn’t make any difference. 

Is there a way to force the iPad to display the touch keyboard, even when a scanner is paired with the iPad?


Bob Patin
Longterm Solutions
bob <at>
FileMaker 9, 10, 11, 12 & 13 Certified Developer
iChat: bobpatin <at>
Twitter: bobpatin
FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

(Continue reading)

David Zakary | 28 May 16:03 2015

FMP 13/14

> On May 28, 2015, at 9:52 AM, fmpexperts-request <at> wrote:
> 1. Does it have the ability to send email without an email client installed?
If FileMaker Server has been configured to use an SMTP server then the answer is yes. If you’re working
locally, then you need an email client.

> 2. Is there any type of audit log built in?
No but there are plenty of 3rd party options out there. Check out Ray Cologon’s website. 

> 3. Can the server script runner do import script steps yet?
It is possible. The file has to be available in the documents folder on the Server machine. This has been
possible for a while now. Not the most straightforward thing to set up but it can be done.


Madness takes its toll.  Please have exact change.
David Zakary
zakary <at>

FMPexperts mailing list
FMPexperts <at>
HOnza Koudelka | 28 May 15:52 2015

[ANN] 24U releases 24U SimpleDialog Plug-In 5.0 for FileMaker Pro 14

Prague, CZ -- May 28, 2015 -- 24U Software announces a major upgrade of 24U SimpleDialog Plug-In to enable
FileMaker Pro 14 to display dynamically created professionally looking OS-native error messages,
input dialogs, and progress bars in both 32-bit and 64-bit modes.

24U SimpleDialog Plug-In allows FileMaker solutions to interact with users via professionally looking
dialogs to provide excellent user experience with minimum development effort. Since its first release
back in 2001 the plug-in has grown to a feature rich user interaction addition for FileMaker solutions,
while still retaining its ease of use and offering syntax that's as simple as the dialog it is supposed to display.

Major changes introduced in the version 5.0:

 - Full compatibility with FileMaker Pro 14 in both 32-bit and 64-bit modes
 - The dialog displaying and handling core updated to use the current OS technologies
 - Resolved collision of multiple copies of the plug-in being installed

Other recent changes and new features:

 - Full support for text styles in dialog fields (except for color on Windows)
 - Dialogs can be updated on the fly without dismissing and re-displaying
 - Conditional popup menus

24U SimpleDialog Plug-In 5.0 is immediately available for download free of charge as a fully functional
14-days trial version, which can be activated after purchasing a license.

Pricing: $49 single-user, volume licenses and upgrades discounted

More info:

(Continue reading)

VanBuskirk, Patricia | 28 May 15:13 2015

FMP 13/14

We are in the process of upgrading to FMP14 (from v11).  Can anyone answer the following?

1. Does it have the ability to send email without an email client installed?
2. Is there any type of audit log built in?
3. Can the server script runner do import script steps yet?

I will probably have more questions as we get closer to d-day (deployment day).  

FMPexperts mailing list

Keith M. Rettig | 28 May 02:09 2015

Which script step is faster?

Using Filemaker Server 14

I am parsing the raw response from Paypal for a credit card charge.  There are about 27 different
descriptions of the outcome from Paypal telling me if successful and if not why.
Right now my script step is divided into the different responses...

	if ( Case( PatternCount ( response_from_paypal ; “blah blah" ) > 0; 1 ;…..; 0)
		set field “Status” = “Success”
	else if ( case ( 14 different pattern count options; 1; 0)
		set field “Status” = “Declined”
	else if ( case ( 10 different pattern count options; 1; 0)
		set field “Status” = “Failure”
	else if
		set field “Status” = “Total Failure”

but now I am thinking I should have just a single Set Field step;

	Set field “Status” ; calculation= Case ([27 different pattern count options = "<correct
value>”]; “Total Failure”)

Is either way faster?  And if so, is it significantly faster?
	I am assuming the Set Field script step only is faster since it is one step rather than four.  Though loading
the 27 different options (even if only process a few of them) might require processing time.
	I am also assuming I can make it even faster by organizing the Case statement by most likely to least likely
outcomes. [definitely becomes harder to read though]

In this case, speed of execution is more important to me than readability since there are about 2500 paypal
transactions a day (and climbing).

Thanks for any feedback and/or confirmation of my thinking.
(Continue reading)

Barker, Al [NMCA-STL] | 27 May 20:18 2015

FMP v14 ODBC Data Sources

Hey gang -

I'm running FMPA-14  on my personal laptop, which also has FMPA-13 installed on it (Strong Win7 64 bit
machine) with a SS Drive.  The version of FMPA-14 I'm running is 32 bit, because I'm dependent on some older
32 bit plugins.

I'm seeing a condition at the moment, that does NOT allow me to import from any of my many 32 bit ODBC data
sources.  When you go to File|Import|ODBC I do not see any of my System defined ODBC setups.  I suspect that
Filemaker is showing my the 64 bit ODBC data sources, of which there are none.  It did not do this yesterday,
I'm positive it was showing me my 32 bit ODBC data sources.  I've completely shut down, and restarted, and
they do not come back.

If I start up my FMPA-13 application, all the data sources are there.

Has anyone else seen this?  Is it unique to the 32 bit version?  I have not tried it yet, but am I going to be forced
to duplicate all my data sources as 64 bit datasources?  <for an application that is not 64 bit?>.

Alan Barker
Nidec Motor Corporation
FMPexperts mailing list

ktprism | 27 May 18:11 2015

Re: Filter Portal To Show All Records


Thank you!!  Now that you explain it, it *is* simple.  I had the relationship set up differently.  You’ve
solved the problem, and given me more clarity on relationships that will It *was* simple -- I had the
relationship set up differently.  Not only have you solved the problem, but your explanation has given me
more clarity that will help on future problems.  

As far as your recipe for disaster . . . Yes!  I definitely need to address that problem, because I don’t like
layouts changing under my fingertips.

I really appreciate the help.

From: Justin Close
Sent: ‎Wednesday‎, ‎May‎ ‎27‎, ‎2015 ‎12‎:‎07‎ ‎PM
To: FMPexperts <at>, ktprism <at>

Sounds like a recipe for disaster, or at least lost efforts, not having a coordinated development effort. 
If you and whoever else are deleting and modifying each other's work without communication...yikes.  As
(Continue reading)

ktprism | 27 May 16:01 2015

Filter Portal To Show All Records

I have an Invoice TO (PK) related to a Products List TO (FK), with allow creation checked on the products

From the Invoice context, I have a portal based on the Products TO, which does show records where the FK
matches, but I want to filter by a Global Field.

I set the filter to 

isempty (GlobalField)


FindWordPartsInText, which is the custom function I found here:

Last week, this all worked, but I’m not the only one who has been accessing this file (I don’t love that
but don’t have a choice).  The custom functions, refresh script, etc all disappeared.  I’ve recreated
it all multiple times over the past two days. . . and it will not work.  

The portal shows related records (that I created in the portal so the FK matches).  If I delete the custom
function and just leave the isempty, the portal shows only related records. If I type in the global field, I
can watch the script as it refreshes or goes to the portal and sets a field (tried it both ways), but the
contents of the portal are unchanged.

(Continue reading)

Pixel height loss in WebDirect with new icon tool bar on FM Server 14?

I notice that FileMaker Server has added a new tool bar row to the browser
(CHROME in our case)  for WebDirect. The bar sits below all other tool bars,
and the only icon on it is a Gray FileMaker "folder" icon, for logging out.

Is there a way to move or turn off this icon appearance? Our solution
requires that pixel height by design. Now everything is moving down about 45
pixels, on laptops that cannot display that much helght (1366 x 768 ). This
was an unexpected overhead in WebDirect by Server 14. We designed it to work
well on Server 13, but now must 
migrate forward.


Jonn Howell
DataExperience, Inc.

FMPexperts mailing list

HOnza Koudelka | 26 May 16:09 2015

[ANN] 24U released 24U SimpleFile Plug-In 3.0 for FileMaker 14

Prague, CZ -- May 26, 2015 -- 24U Software announces a major upgrade of 24U SimpleFile Plug-In for managing
files and folders directly from FileMaker Pro or FileMaker Server, adding new features, along with
support for 64-bit FileMaker Pro 14 and FileMaker Server 12, 13, and 14.

New features introduced in the version 3.0:

 - Full compatibility with FileMaker Server 12, 13, and 14
 - Full support for 64-bit architecture on both OS X and Windows
 - Better stability and reliability necessary for a server-side plug-in
 - More options in file/folder selection dialogs
 - SFile_Open now allows for selecting what application will open the file
 - SFile_Reveal opens file's enclosing folder and selects the file
 - SFile_Run can run any application with provided extra arguments
 - SFile_Compress and SFile_Decompress can zip and unzip files and folders

Other Features include:

 - Creating, deleting, copying, moving, and renaming files and folders
 - Checking kinds and sizes of files and folders
 - Checking and setting creation and modification date & time, privileges
 - Choosing file, folder and new file name via system dialog
 - Reading folders (list of items)
 - Reading and writing files (whole contents or part, append, modify)
 - Support for full and relative paths (cross-platform)
 - Automated recognition of different path formats
 - Support for explicitly specified text encodings
 - Reading and writing binary files as hexadecimal dump
 - 100% Unicode

24U SimpleFile Plug-In 2.0 is immediately available for download free of charge as a fully functional
(Continue reading)