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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: