FileMaker Off The Record Podcast

E014 – FileMaker Design Functions Review

Listen Later

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/

    ...more
    View all episodesView all episodes
    Download on the App Store
    FileMaker Off The Record PodcastBy Thomas Mokwa - FileMaker Consultant
    • 5
    • 5
    • 5
    • 5
    • 5

    5

    12 ratings