Brian Dunning's FileMaker Custom Functions

listFieldTypes ( listOfFields )

Returns a tab-delimited list of fields & field type info for every field on the current layout

  Average rating: 4.5 (21 votes) Log in to vote

Andrew Sasaki   Andrew Sasaki - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
listFieldTypes ( FieldNames ( Get ( FileName ) ; Get ( LayoutName ) ) )
  Sample output:
FileName Table Layout Field Option Type Index Repetitions
TestDB table1 table1 Text1 Standard Text Unindexed 1
TestDB table1 table1 RecordID Standard Number Unindexed 1

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

Recursively processes fields on the current layout, listing metadata for each in a tab-delimited format with header. Assumption: the source value list is a list of fields on the current layout. Useful for documentation.

UPDATED 2017-06-07 to add suggestion from Giancarlo Meak.

 

Comments

Giancarlo Meak   Giancarlo Meak, Turin Italy
Nov 20, 2015
Thank you, very useful function :-)
I had to change a line to view fields called with underscore at the beginning like "__pk_id"
If anyone get this issue may consider changing this line from
firstValue = LeftWords ( LeftValues ( listOfFields ; 1 ) ; 10 ) ;
to
firstValue = Substitute(LeftValues ( listOfFields ; 1 ); ¶;"") ;
 

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 20 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: