SelfTest ( UseSelf )

Allow for direct input ("override") of auto enter calc field.

Average rating: 4.3 (39 votes) Log in to vote

Mark D Kerr - Show more from this author
Discovery Reef Design & Consulting

Sample input:

SelfTest ( Self )

Sample output:

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

Let ( [
ACTIVE = Get ( ActiveFieldName ) ;
TEST_FIELD = GetFieldName ( UseSelf ) ] ;

Case (
ACTIVE  = Middle ( TEST_FIELD ; Position ( TEST_FIELD ; ":" ; 1 ; 1 ) + 2 ; 100 ) ; 1 ;
0 )
)

Using "SelfTest ( Self )"

in an auto enter calculation, tests for direct input of a value, while eliminating field renaming concerns, as would occur if using ...

Get ( ActiveFieldName ) = "Date_Final"

Comments

		dbyte solutions, Munich Jun 13, 2009
[QUOTE] tests for direct input of a value, while eliminating field renaming concerns, as would occur if using ... Get ( ActiveFieldName ) = "Date_Final" [/ QUOTE] Hi Mark, use "GetFieldname()" (FM 10) to test for a specified active field without using hard coded names: GetValue( Substitute( GetFieldname( YourTO::Date_Final); "::"; "Â¶" ); 2 )

		Mark D Kerr, Discovery Reef Design & Consulting Aug 14, 2010
Agreed, you see the GetFieldName function as line 3 of the CF. I use this behavior in cross calculating values a LOT. IMHO, it's way easier to input the test/result as... SelfTest ( Self ) ; Self ;.... than to produce.... GetValue ( Substitute ( GetFieldname ( YourTO::Date_Final ) ; "::"; "Â¶" ) ; 2 ) = Get ( ActiveFieldName ) ; Self N'est pas?

		JT Mar 8, 2018
Alternatively, GetFieldName ( Evaluate ( Get ( ActiveFieldName ) ) ) = GetFieldName ( UseSelf )

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

SelfTest ( UseSelf )

Comments

Support this website.

Support this website.