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
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.
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 ) ;
firstValue = Substitute(LeftValues ( listOfFields ; 1 ); ¶;"") ;
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.