21 Jan 2021: demo has been updated to fix a couple bugs; article has been updated to reflect these changes.
Demo file: file ids, table ids and field schema, v4.zip (requires FM 18 or later)
INTRODUCTION
Recently I was asked to help document a FileMaker solution by creating and populating a “schema” table as per the above screen shot.
One of the requirements was to programmatically determine internal ID numbers for the file and for the tables (as opposed to table occurrences) within that file, and this was accomplished by leveraging some script steps that were introduced in FileMaker 18.
(Thank you Rob Russell for pointing me in the right direction, i.e., to Save A Copy As XML.)
RUNNING THE DEMO
Clicking this button…
Continue reading “File IDs, Table IDs and Field-Level Schema”