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 - Show more from this author

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)

Let ( [ tab = Char ( 9 ) ; // for readability
theFile = Get ( FileName ) ; // for readability
numOfValues = ValueCount ( listOfFields ) ; 
// LeftValues alone messes up the output format with extra returns 
firstValue = Substitute(LeftValues ( listOfFields ; 1 ); ¶;"") ; 
// Format: FileName / Table / Layout / Field / Option / Type / Index / Repetitions
// FieldType output is space-delimited ; replace with tabs 
fieldInfo = theFile & tab & Get ( LayoutTableName ) & tab & Get ( LayoutName ) & tab & firstValue & tab & Substitute ( FieldType ( theFile ; firstValue ) ; " " ; tab ) & "¶" ;
remainingValues = MiddleValues ( listOfFields ; 2 ; numOfValues - 1 ) ;
resultList = Case ( numOfValues = 1 ; ""; listFieldTypes ( remainingValues ) ) ] ; 
// add header on last repetition 
If ( numOfValues = 1 ; "FileName	Table	Layout	Field	Option	Type	Index	Repetitions¶" & resultList & fieldInfo ; resultList & fieldInfo
) )

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, 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 ); Â¶;"") ;

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

listFieldTypes ( listOfFields )

Comments

Support this website.

Support this website.