E014 – FileMaker Design Functions Review

FileMaker Off The Record Podcast

We review each of the Design Functions in FileMaker Advanced 17. We also discuss

• DatabaseNames A list of the names of all files open on the computer.
• FieldBounds The location, in points, of each field boundary and the field’s rotation in degrees.
• FieldComment The specified field’s comment.
• FieldIDs A list of all field IDs in fileName and layoutName.
• FieldNames A list of the names of all fields on layoutName in fileName.
• FieldRepetitions The number and orientation of repetitions of a repeating field as formatted on a layout.
• FieldStyle The field formatting applied to fieldName on layoutName in fileName.
• FieldType Information about fieldName.
• GetNextSerialValue The next serial number of fieldName in fileName.
• LayoutIDs A list of all layout IDs in fileName.
• LayoutNames A list of the names of all layouts in fileName.
• LayoutObjectNames A list of the names of all named objects on layoutName in fileName.
• RelationInfo A list of four values for each relationship directly related to tableName.
• ScriptIDs A list of all script IDs in fileName.
• ScriptNames A list of the names of all scripts in fileName.
• TableIDs A list of all table IDs in fileName.
• TableNames A list of all table occurrences in the relationships graph for fileName.
• ValueListIDs A list of all value list IDs in fileName.
• ValueListItems A list of the values in a value list.
• ValueListNames A list of the names of all value lists in fileName.
• WindowNames A list of the names of windows that are currently open.

https://www.databuzz.com.au/using-executesql-to-query-the-virtual-schemasystem-tables/

https://mightydata.com/sql-reserved-words-in-filemaker/