@CrossedAutoEnter ( thisFieldRef ; anotherFieldNum ; anotherValue )

Allows to auto-enter calculations in two fields that depend on each other.

Be the first to rate this function Log in to vote

Alex Zueiv - Show more from this author
Tashkent
https://github.com/zueiv

Sample input:

@CrossedAutoEnter ( Self ; 0 ; Meters * 3.280839895 )
@CrossedAutoEnter ( Self ; 1 ; Feet * .3048 )

Sample output:

3.280839895 or 1
1 or .3048

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

/**
* @CrossedAutoEnter ( thisFieldRef ; anotherFieldNum ; anotherValue )
*
* Allows to auto-enter calculations in two fields that depend on each other.
*
* Parameters:
*
*	thisFieldRef	= Self
*	anotherFieldNum	= 0 or 1
*	anotherValue	= calculation with reference to another field
*
* Usage example:
* 
* 1. Create two standard fields: Feet and Meters
* 2. Enable the options 'Auto-enter: Calculated value' with the following formulas:
*
* 	Feet:	@CrossedAutoEnter ( Self ; 0 ; Meters * 3.280839895 )
* 	Meters:	@CrossedAutoEnter ( Self ; 1 ; Feet * .3048 )
*
* 3. Unselect the checkboxes 'Do not replace existing value' for both fields
*
* Now you can enter the length either in the field Meters or in the field Feet.
*
*
* Created 2020-06-01 by Alex Zueiv
* https://www.briandunning.com/cf/2382
**/


// if the change flag of the other field is set
If ( $$az.cf.cae.FieldChangedFlag [ anotherFieldNum ] ;

	// then CF is called from the unchanged field
	// destroy the global variable and replace the value
	Let ( $$az.cf.cae.FieldChangedFlag [ anotherFieldNum ] = "" ; anotherValue ) ;

	// else CF is called from the changed field
	// set a global variable and save the changes
	Let ( $$az.cf.cae.FieldChangedFlag [ not anotherFieldNum ] = True ; thisFieldRef )

)

1. Create two standard fields: Feet and Meters

2. Enable the options 'Auto-enter: Calculated value' with the following formulas:

Feet: @CrossedAutoEnter ( Self ; 0 ; Meters * 3.280839895 )
Meters: @CrossedAutoEnter ( Self ; 1 ; Feet * .3048 )

3. Unselect the checkboxes 'Do not replace existing value' for both fields

Now you can enter the length either in the field Meters or in the field Feet.

Comments

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

@CrossedAutoEnter ( thisFieldRef ; anotherFieldNum ; anotherValue )

Comments

Support this website.

Support this website.