MustEnter ( ThisField ; CheckField ; CheckValue ; StandardValue )
Checks for entry and validates if you want.
Average rating: 4.0 (30 votes) Log in to vote
Teuker Beheer BV
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: www.teuker.nl/demos/mustenter.html
It helped me, hope it helps you!
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.