AnsweredAssumed Answered

AppleScript get/set value of a (container) field  in found records?

Question asked by macmesser on Mar 10, 2017
Latest reply on Mar 12, 2017 by macmesser

I am using FMP Advanced 15.0.3 with Mac OX 10.11.6 and can't seem to get/set field values of a set of found records, or indeed reference the fields properly. I have a three table database and one table,called Image_Files, has a container field manually set to store an image externally by reference. I can access the field "Image" in every record with the following script but I need to access a found set rather than every record in the table:

 

--use AppleScript version "2.4" -- Yosemite (10.10) or later

use scripting additions

 

tell application "FileMaker Pro Advanced"

       tell document 1

 

       set AList to field "Image" of table "Image_Files"

       count of AList --is count of all records

       set theFile to item 1 of A

            tell application "Finder"

            name of file theFile --correct value

            end tell

 

          end tell

end tell

 

In the above, AList is a list of all records. I need to work with only the found set. I tried to accessing by document and database and by layout and window (both with found set displayed) but got errors when trying to reference records, fields and cells. How does one access a set of found records? Thanks for any insights.

Outcomes