Apple

set data of cell "gMember_list" of table "Activities" of document odbActivities to personList

it had 48 items in personList but I only got the first one

On 5 Apr 2015, at 12:34 , Bruce Robertson <email@hidden> wrote:

I prefer referring to a table.

The table name must be the name of a valid table occurrence in the relationship graph, not the name of the base table.

set data cell "gMember_list" of table "Activities" of document odbActivities to personList

On Apr 4, 2015, at 6:13 PM, John Mitchell <email@hidden> wrote:

Scripters

I have an applescript which captures a list of email recipients, and then saves it to a global variable in FMPro, all defined as an Apl script in a FMPro script.

FMPro 13.0v5, OSX 10.9.5

the elements are:

step 1:
property odbActivities : "Activities"
tell application "Mail"
set theMessages to selection
set theEmail to last item of theMessages
tell theEmail
set personList to (name of recipients of theEmail)
set personList to personList & (name of to recipients of theEmail)
set personList to personList & (name of cc recipients of theEmail)
end tell
end tell

Step 2:
tell application "FileMaker Pro Advanced"
set cell "gMember_list" of layout 0 of document odbActivities to personList
end tell

This has been working for a long time (the last edit of this script was 19 Nov 2010)

Now however instead of the list I only get the first item of the list.

I discovered this adding a new script with a similar task.

Paradoxically the saved FMPro script runs successfully, but testing the separate components in SD and the new script both fail.

I used a string instead of a list but equally failed.

Any suggestions please?

regards

John

regards

John

Email: email@hidden • Mob: +61 410 318 131

References:
	>Re: passing a list to FMPro from Mail (From: John Mitchell <email@hidden>)