numEmpty ( field )

Returns the number of records in the found set with a blank value for a specific field

Be the first to rate this function Log in to vote

David A Sullivan - Show more from this author
Mandelbrot LLC
http://mandelbrotllc.com

Sample input:

numEmpty ( completedCheckbox )

Sample output:

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

/*
  __  __                 _      _ _               _     _     _     ____ 
 |  \/  | __ _ _ __   __| | ___| | |__  _ __ ___ | |_  | |   | |   / ___|
 | |\/| |/ _` | '_ \ / _` |/ _ \ | '_ \| '__/ _ \| __| | |   | |  | |    
 | |  | | (_| | | | | (_| |  __/ | |_) | | | (_) | |_  | |___| |__| |___ 
 |_|  |_|\__,_|_| |_|\__,_|\___|_|_.__/|_|  \___/ \__| |_____|_____\____|

*/

While ( 

 [
   i = 1 ;
   numEmpty = 0 ;
   thisEmpty = 0
 ] ;

 i < Get ( FoundCount ) + 1 ;

 [
   thisEmpty = If ( GetNthRecord ( field; i ) = "" ; 1 ; 0 ) ;
   numEmpty = thisEmpty + numEmpty ;
   i = i + 1
 ] ;

 numEmpty

)

// [ initialVariable ] ; condition ; [ logic ] ; result

Version 1, 2023-04-01

Comments

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

numEmpty ( field )

Comments

Support this website.

Support this website.