Demo file: file ids, table ids and field-level schema.zip (requires FM 18 or later)
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…