Mardi Kennedy | 31 Aug 01:57 2015

Re: FMPexperts Digest, Vol 90, Issue 37

Hi Paul,

You got unlucky!  Usually one of the very helpful folks here would have jumped on this promptly but this post
must have fallen through the cracks.

A more conventional structure would be to have a Species table (as a 'base' one, rather than derived from
your original Plant table) and then a Plant table which records each acquisition of a specific species. 
I'm guessing that the database started out a bit differently from this so it may seem hard to rejig the
architecture, but it probably isn't as hard as you think.  Once the architecture is there, some of those
other questions will virtually answer themselves.

Ask around - there may be someone in your part of the world (South Carolina) who can assist with this tidy up.

Re cultivars - very sorry - I don't know enough about plants!  Presumably, these are not a separate species? 
So they get created by breeding two plants of the same species?  And then they have distinctive characteristics?

It sounds as if you also have images and notes - it's a bit unclear if these are part of the Plant records, or
Species records, or in separate tables.  Should they be a part of the Species record or is it more useful for
the Botanical Gardens, that they be part of the Plant record?  Or does it vary, depending upon the content of
the image/ note?

Good luck with it,


On Aug 26, 2015, at 06:09 AM,
fmpexperts-request@... wrote:

Date: Mon, 24 Aug 2015 20:21:15 +0000
From: Paul Helling <phelling@...>
(Continue reading)

Mardi Kennedy | 31 Aug 01:34 2015

Re: Insert File (external storage)

Not all pdfs are created equal - this might explain the apparent inconsistencies.

If you scan a document, usually it will get saved as an 'image pdf', not a 'text pdf'.  You often then need to run
them through OCR or whatever to convert them to text pdfs.  Alternatively, if the pdf is created via a
different process, eg directly from Word or whatever, it's usually immediately 'text recognisable'
rather than being stuck as image-only.  Also, pdfs created more than several years back are frequently image-only.

So besides the 'secure storage bug' (which I can't comment on), it may also be the nature of the individual
pdf itself.

Regards, Mardi
FMPexperts mailing list

kigmaker | 29 Aug 22:45 2015

Smart Sort List View v1.0.2 technique file


I have developed a simple solution for sorting list views.

It consists of one script only.

Sorts occur dynamically. Each column restores it's last sort order and a
default sort order can be set for each field type.

 I have already bounced it off of the members at <>
and gotten good feedback plus recommendations I have incorporated.

Feel free do download and offer suggestions if you'd like.

If I incorporate any of your suggestions, I will give you credit in the
script and upload the new version here and at <>.

Thank you,

Colm | 27 Aug 18:54 2015

Insert File (external storage)

Hi Experts

I've got a container field in a table in a hosted database. It's set to 
store the data externally (secure storage). I have an Insert File script 
step, which seems to be doing its job, but the way the container is 
displaying is confusing me.

The file is a 3-page PDF.

If I display the container field, optimised for Interactive Content, I 
just get a grey box, with the normal '+', '-', 'Open in Preview' and 
'Save as PDF' grey buttons at the bottom, though they don't do anything. 
But if I display it as optimised for Images, I can see the image of the 
first page, although the interactivity is missing.

This is what it looks like:


(I've cropped the right of the document, as it's an official car logbook.)

What I really need is the image and the interactivity! Am I asking too 
much? Have I missed something obvious?

Does anyone have any idea why the grey box is showing for the 
interactive content?


(Continue reading)

David Powell | 27 Aug 15:16 2015

Substitute variation

Dear experts,

I'm really hoping there is a simple answer from someone who's already been
down this path...

I have a text file that I'm reading into memory, and have a need to
substitute all instances of a single double quote.
There are lots of instances of 2 double quotes together and I want to leave
them well alone so the substitute function will not work.

I could read through each character in turn and compare it with the
previous and next to ensure it is isolated but this seems a long winded way
of doing things.

I've not found anything fit for purpose on briandunning but does anyone
know of a custom function that already exists before I embark on writing my

Or maybe there's another method I've not considered? Maybe using regex and
a plugin....?

Thank you as always for any help or insight.



David Powell
Wulfgang Ltd
m: 07712 524 894
(Continue reading)

Paul Helling | 24 Aug 22:21 2015

Can't store a calculation


I work with a database at a botanical garden. We have a "Plants" table that keeps tracks of every time we buy a
plant, so the same plant species can have multiple records if we've bought it several times. To count the
number of unique species, I populated a Species table with name information from every record in Plants.
Then, I set up a system to check for duplicates using a serial number and a self-join relationship and the
following calculation:  Check = If( Counter = ListGenSpc::Counter; "Unique"; "Duplicate").
ListGenSpc is the name of the self-join table and the Check field is a calculation.

This works as intended. However, I also want to generate a report of unique hybrids and other levels of plant
naming. To count the number of species, I tried using a tally system that we use for notes and images. I made a
calculation field Count = If(CultivarCheck = "Unique"; 1;0) and a calculation field Tally =
Sum(list_taxa 2::CultivarCheck). The table ListGenSpc is a self-join that matches names and list_taxa
2 is a self-join that matches serial numbers (I noticed that my other tallies for images and notes were
matched on photographer and author so I didn't know what to match here). I have a separate self-join table
to test for the uniqueness of each level of nomenclature and that works correctly too. What doesn't work is
that the Tally can't add the Count because the Count is unstored.
  When I try to store it, I get an error about how it can't be indexed. I tried storing the Check field since it is
referenced by the Count field but this field can't be stored either.

My current hypothesis is that I can't store the calculation field Check because of the self-join
relationship. Changing count to a Text field with auto calculation lets me store it but all the existing
records lose their value of "Duplicate" or "Unique". Is there a way for me make a summary report with the
total number of species? I know that if I'm asked for a number, I can just do a search for "Unique" and use the
number of records in the found set as my number but my supervisor would like a layout he could go to with all
the relevant numbers.


(Continue reading)

Mike McErlean | 24 Aug 16:39 2015

Automator/Applescript issue -

Hi Folks.

This peripheral to a  FileMaker project, but you are always kind to the knowledge challenged . . .. Mac OS X - no
FileMaker plug ins. 

I have to import an image to a server folder that is required to be named in a specific way. The image comes from
FileMaker Go, and is placed on the server (so far so good)  I have an automator script that creates a
generically named  folder and places the image in the folder. The problem arrises when trying to rename the

I’ve tired a few methods, but the one that I’m working on is using applescript within the Automator
workflow to extract the name of the image from the image itself, then renaming the folder I created in the
automator script. 

The applescript works as intended when I manually choose the image,  The automator script runs but the
applescript does not pass the name back correctly. All my tests get the full path to the picture (not really
useful for  a folder name), yet the script result box, although marked successful, is always empty. I
suspect the issues is how I’m passing the the image name from Automator to Applescript.

Is there enough information for someone to point me in the right direction to getting this working as
intended? Is there a better way to accomplish this?

I’ll post the automator/applescript when I get to the office.



Mike McErlean
(Continue reading)

UUID - Which Approach?

I am frankly a bit overwhelmed with the options for UUID
instantiation.always keeping in mind:

1. Speed to create
2. Speed to search
3. Uniqueness

I have read the lengthy article on

The thread is rich, yet a bit dated.
So far, the best approach I see is:

UUIDAsRFC4122 ( theID )
Jeremy Bannte

(wherein "theID" seems to be the Get ( UUID ) function from FMP)

I would like to know what approach the cool kids use....please comment.

Jonn Howell
DataExperience, Inc.
Certified FileMaker Developer
dba Bootcamp for FileMaker
(Continue reading)

Kevin Frank | 22 Aug 19:56 2015

[FileMaker Hacks] FileMaker UI Tricks: Dual-Purpose Layout

Editor’s note: Today it’s my honor and privilege to present an article 
by guest author Beverly Voth, whose contributions to the FileMaker 
community are numerous and much appreciated. It’s great to have her back 
here on FileMaker Hacks.

Kevin Frank & Associates
FileMaker 7/8/9/10/11/12/13 Certified Developer
FMPexperts mailing list

Lawrence Camp | 22 Aug 12:19 2015

Running a FM script as a server schedule

The script in question does a simple find for records to process and sends
an email for the found set.  When run as a server schedule It works as long
as there¹re records to process, but fails with the server schedule status of
³FileMaker Script Error² when no records are found.  So it appears that
finding no records which returns a 401 error stops the server schedule.
Once stopped it won¹t run again.

Setting error capture on doesn¹t change the outcome.

I am missing a simple solution or is there really no way to run this script
as a server schedule?

Thanks for your input,

Lawrence B. Camp
LB Camp Consulting, LLC
FileMaker 7, 8, 9, 10, 11, 12, 13 Certified Developer
l <at>

215 Evans Street
Morganton, NC 28655
828.437.1002 Fax
828.443.7136 Cell

Be green: Print this message only when necessary.

CONFIDENTIALITY NOTICE: The data transmitted here is intended only for use
of the person or entity to which it is addressed and may contain
(Continue reading)

Hans Gunnarsson | 22 Aug 11:01 2015

How to calculate PPMT, IPMT etc.


I’m working on a solution that amongst other things should create a loan payment schedule.

For this I need things like IPMT and PPMT to calculate monthly payments and monthly interest.


I have researched and tried things I found on the Interenet, like:

pmt(c) = r / ((1 + r)^N - 1) * -(pv * (1 + r)^N + fv)
fv = -(c * (1 + r) * ((1 + r)^N - 1) / r + pv * (1 + r)^N) 
ppmt = c - (-(c * ((1 + r)^(per-1) - 1) / r + pv * (1 + r)^(per-1)) * r)   
ipmt = -(c * ((1 + r)^(per-1) - 1) / r + pv * (1 + r)^(per-1)) * r


Where the variables mean:

c = Payment amount per period (month)
r = Interest rate. - The number entered is divided by 12 and 100 to calculate monthly interest.
N = Total number of monthly payments
P = Original amount of loan (principal)

fv = The future value, Amount left unpaid after calculating the current payment

pv = P = The present value, or the total amount that a series of future payments is worth now; also known as the principal.
nper = N

type = 0 Payment is made at the end of a period
(Continue reading)