A FMT Preferred FileMaker Consultant - Developer
Log in
Hot & Trending on FMT

The FileMaker FieldNames Function

FieldNames
FieldNames( fileName ; layoutName or tableName)
FMP Version: All current versions of FileMaker
Returns A Text Result

The FieldNames function gives you the name for each field on a specified layout or in a specified table. Each field name is listed on a row by itself ( in other words carriage return delimited ).

A somewhat odd and hidden feature is the ability to substitute the name of a relationship table occurrences for the name of the layout. In cases like this, FileMaker will supply you the fields in the TO.

EXAMPLE: FieldNames ( Get ( FileName ) ; Get ( LayoutName ) )
Here is a calculation that will return all the current fields on the current layout. It uses a get functions as the parameter settings for what file and layout you want. ( fyi ... make sure you have the result unstored ) The order in which the fields appear will correspond to the order in which the fields appear in the layer of each layout.

EXAMPLE: FieldNames ( Get ( FileName ) ; Get ( LayoutTableName ) )
Here is a calculation that will return all the current fields for the current table that current layout is using. It uses a get functions as the parameter settings for what file and layout you want. ( fyi ... make sure you have the result unstored ) The order in which the fields appear will correspond to the order in which the fields were created.

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.

Dwayne Wright

Dwayne Wright is quite simply put one of favorite authors. Dwanye has been around with us since the days of AOL. No matter what FileMaker subject you are looking for Dwayne has wriiten something on it.

Be sure and visit his blog listed below.

Website: www.dwaynewright.com/