The Original Filemaker Community - Forum
FileMaker News | FileMaker Tutorials | FileMaker Videos

The Leading Filemaker Developer Tools

Password protection and security…

The FileMaker FieldNames Function – FileMaker Today


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.

Comments are closed.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

Privacy & Cookies Policy