GetFieldType ( theFileName ; theFieldName )

Returns the field type for a given field (text).

Average rating: 5.0 (1 vote) Log in to vote

Ethan - Show more from this author
Tactile Medical
https://www.linkedin.com/in/ethyoder

Sample input:

GetFieldType ( "" ; GetFieldName ( PERSON::birthday ) )

Sample output:

Date

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

//	NAME		GetFieldType
//	DESCRIPTION	Returns the field type for a given field.
//
//	PARAMETERS	theFileName (file name): the file the field is in
//			theFieldName (full TO/field name, text): the field you want to check
//
//	RETURNS	text (field type)
//
//	EXAMPLE	GetFieldType ( "" ; GetFieldName ( PERSON::birthday ) )
//	RESULT		Date
//
//	DEPENDENCIES	<<none>>
//
//	2021-10-27, eyoder, Created CF


GetValue ( Substitute ( FieldType ( theFileName ; theFieldName ) ; " " ; ¶ ) ; 2 )

Returns the field type for a given field (text). Easier than having to pull this information from FieldType() manually.

Comments

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

GetFieldType ( theFileName ; theFieldName )

Comments

Support this website.

Support this website.