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:
field1
field2
field3

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

retrieve field names from specified table

 

Comments

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

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.

Regards

Nick
 
David   David, Toronto
Jun 18, 2018
Hi Nick,

The function is case sensitive, perhaps that might be the issue. https://www.dropbox.com/s/rkizyum1jl0rp99/FmTableFields.fmp12.zip?dl=0

David
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. 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 15 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:

Under construction. Email me your wish list for improvements.