1 Reply Latest reply on Mar 12, 2017 7:00 AM by macmesser

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

    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.