Brian Dunning's FileMaker Custom Functions

FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude )

retrieve field names from specified table

  Average rating: 3.5 (2 votes) Log in to vote

David Schellenberg   David Schellenberg - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
FmTableFields ( "table" ; "" ; "id,mod" ; "Calculated" ; "timestamp" ; "z_" )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

retrieve field names from specified table



Nick Stockbridge   Nick Stockbridge, Transmedia Communications Ltd
Jun 17, 2018

I'm trying to use your very useful-looking function but can't get it to work. Please could you help?

I'm trying to get all the field names from a table called Staff.

My syntax is:

FmTableFields ( "Staff" ; "" ; "" ; "" ; "" ; "" )

I have also tried storing the filed name in a field but that doesn't work for me either.

Many thanks.


David   David
Jun 18, 2018
Hi Nick,

The function is case sensitive, perhaps that might be the issue.


Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: