Brian Dunning's FileMaker Custom Functions

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   Hartger Visser
Teuker Beheer BV

Share on Facebook Share on Twitter

  Sample input:
MustEnter ( ThisField ; CheckField ; "customer" ; OfficePhone )
  Sample output:
-- enter data --

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

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:

It helped me, hope it helps you!



Log in to post comments.


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

Under construction. Email me your wish list for improvements.