Field names on a layout

[_samuel_]

Hello,

Is there anyway to print a list of the field name on a layout (not the whole database)? Thank you.

[bruceR]

Look for the fieldnames function:

FieldNames ( fileName ; layoutName )

[_samuel_]

Thank you BruceR for the reply. Would you please explain a little more? I'm not so bright when it comes to FM. I need a list of all the fields on a specific layout. Thanks again.

[_samuel_]

Hey, I got it now. Thank you very much for your help!

[dayzrespite]

Hey,

Let me explain a bit more:

FieldNames ( fileName ; layoutName )

This calculation lists all the names of the fields on a layout.

Therefore, in the fileName you must specify the name of the file or database you are working on, and the layout name on the layoutName parameter.

You can use other functions as well to produce the fileName and layoutName dynamically:

Get ( FileName )

Get ( LayoutName )

So it would look something like this:

FieldNames ( Get ( FileName ) ; Get ( LayoutName ) )

Make sure the result is text for the calculation

[_samuel_]

Great! I'm glad to learn about that too. Thank you Linndgberg and again, thank you BruceR. I love this forum.

Samuel

[bruceR]

Be sure to learn how to use the FileMaker help system. This command is documented there, and once you learned of the existence of the command you should be able to use the help system to figure out how to use it.