MustEnter ( ThisField ; CheckField ; CheckValue ; StandardValue )

Checks for entry and validates if you want.

Average rating: 4.0 (30 votes) Log in to vote

Hartger Visser
Teuker Beheer BV
http://www.teuker.nl

Sample input:

MustEnter ( ThisField ; CheckField ; "customer" ; OfficePhone )

Sample output:

-- enter data --

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

/*-------------------------------------------------------
Function Name: MustEnter()
Syntax:
MustEnter ( ThisField ; CheckField ; CheckValue ; StandardValue )

Shows text "-- enter data --" in red in the field ThisField if the value of CheckField contains CheckData. If data is entered, it is shown normally. If no data is enterd in ThisField, it takes a preset value that it enters (on creation etc.)

Author - Hartger Visser
----------------------------------------------------------*/

If ( PatternCount( CheckField ; CheckValue   ) > 0 and IsEmpty ( ThisField ) ; TextColor ( "-- enter data --" ; RGB ( 255; 0 ; 0 ) ) ; If ( ThisField = "-- enter data --" ; "" ;
If (IsEmpty ( ThisField ) ; TextColor ( StandardValue ; RGB ( 0 ; 0 ; 0 ) ) ; TextColor ( ThisField ; RGB ( 0 ; 0 ; 0 ) )) ))

Some fields need data. This function shows your users IN THE FIELD which fields need data by displaying a red '-- enter data--' in the field.

Since this function uses the Auto-enter calculation function of FileMaker, it can also enter data automatically. Be sure to unmark the 'don't override data entered' checkbox.

ThisField: The value of the current field
CheckField + CheckValue: The text '-- enter data --' is only displayed if CheckField contains CheckValue (can be empty too).
StandardValue: Auto-enter a value when no data is entered. This is almost like the FM function Auto-enter data.

Demo file is availlable at: www.teuker.nl/demos/mustenter.html

It helped me, hope it helps you!

Comments

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

MustEnter ( ThisField ; CheckField ; CheckValue ; StandardValue )

Comments

Support this website.

Support this website.