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
http://www.rivetcom.ca

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.

Under construction. Email me your wish list for improvements.