E014 – FileMaker Design Functions Review
Manage episode 311118714 series 3083392
Thomas Mokwa - FileMaker Consultant에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 Thomas Mokwa - FileMaker Consultant 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.
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 에피소드