FileMaker 12以降
 
Let (
[
$query = " SELECT TableName ,FieldName
FROM FILEMAKER_FIELDS
WHERE
TableName IN('TableName1','TableName2'','TableName3)/*テーブルを指定する場合*/
AND
FieldClass = 'Normal'
AND
FieldType LIKE 'global%'
AND
FieldName NOT IN('FieldName1','FieldName2','FieldName3')/*除外するフィールドを指定する場合*/
"
];
ExecuteSQL ( $query ; "::" ; "" )
)
 
グローバル
Sample output(出力例):
formula(式):

Let (
[ 
$query = " SELECT TableName ,FieldName
FROM FILEMAKER_FIELDS
WHERE 
FieldClass = 'Normal'
AND
FieldType LIKE 'global%'
"
];
ExecuteSQL ( $query ; "::" ; "" )
)