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

rivet   rivet
Rivet Design Communications

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, Toronto
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.

Under construction. Email me your wish list for improvements.