E014 – FileMaker Design Functions Review

FileMaker Off The Record Podcast

Content provided by Thomas Mokwa - FileMaker Consultant. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Thomas Mokwa - FileMaker Consultant or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://staging.podcastplayer.com/legal.

6+ y ago

M4A•Episode home

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/

30 episodes

#Tech #Business #Entrepreneur #Thomas Mokwa - FileMaker Consultant #Podcasting Education