HELP!!! :

I have a converted solution that uses AppleScript to send emails via Entourage.

It seems to fail when trying to pass a value back to FileMaker. Here's the original applescript code where the failure is occurring:

set cell "g_num" of (current record of database "Correspondence.fp5") to theValue

I played around a little and found that if I changed it to something like this:

set field "g_num" of table "Correspondence" of database "Correspondence" to theValue

I have been able to create a scratch file where I get this to work, but I can't seem to pass a value back to the hosted "converted" file.

Any help would be greatly appreciated!

TIA,

Aaron

Edited August 12, 201015 yr by Guest

Why did you change "cell" to "field"?

In both old and new versions, a field is an entire column -all records in found set or all records in database depending on more details of the reference. A cell belongs to a single record.

Grasping at straws really. It's a global field, so it shouldn't matter should it?

Scratch that.. I see it does matter. It appears that "set field" will update all records, whereas "set cell" operates against the record you are on. While a global field does contain the same value for all records, I can't wait for all rows to be processed.. Changing to set cell on the line I was playing with did the trick.