Brian Dunning's FileMaker Custom Functions

_NotEmpty ( Prefix ; Field ; Suffix )

Simplifies the process of adding characters before or after a field if its not empty.

  Average rating: 4.3 (35 votes) Log in to vote

Josh Morton   Josh Morton

Share on Facebook Share on Twitter

  Sample input:
_NotEmpty ("| "; "Name" ; ",")
  Sample output:
| Name,

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

This function simplifies the process of creating text blocks with variable data sets. For example if you want a Fullname calc field from 3 separate name fields (F,M,L) but don't want the extra space if there is no value for the Middle name field.



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.