Brian Dunning's FileMaker Custom Functions

___NE ( theField )

Check for NO value in a field

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

Don Wieland   Don Wieland
DW Data Concepts
http://www.dwdataconcepts.com

Share on Facebook Share on Twitter

  Sample input:
____NE(Color) if the field Color has the value "Red"

____NE("") if the field Color is EMPTY
  Sample output:
1


0

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

Quick CF - part of some basic timesaving CF's I setup prior to starting development. Great for scripting.

Check for data in a field. Returns a "0" if there is no value in a field ELSE a "1".

Underscores prior to the CF's name causes them to sort at the top off function list in ScriptMaker.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.