isField ( reference )

Use to find out if a string is a reference to a field or not. Can be an actual field reference or just the same text as a field

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

Paul - Show more from this author
Peak 14 LLC
http://www.peak14.solutions

Sample input:

isField ( "myField" )
isField ( myTable::myField )
isField ( "myString" )

Sample output:

1
1
0

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

/*
 *  CUSTOM FUNCTION
 *      isField ( reference )
 *
 *  DESCRIPTION
 *      Use to find out if a string is a reference to a field or not. Can be an actual field reference or just the same text as a field
 *
 *  PARAMS
 *      reference: What are you trying to find out whether is a field or not
 *
 *  RETURNS
 *      Boolean
 *
 *  CHANGELOG
 *      2021-02-12: Paul McCudden: Created
*/

not (
    EvaluationError ( GetField ( reference ) ) and
    EvaluationError ( GetFieldName ( reference ) )
)

Use to find out if a string is a reference to a field or not. Can be an actual field reference or just the same text as a field

Comments

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

isField ( reference )

Comments

Support this website.

Support this website.