Hope this is Left brain stuff..

 

I have a single record, there are 5 global field1, field2 field3 etc

I need  a calc global field, to show how many are empty of those filled in

 

Can't figure..

TIA

R

to show how many are empty of those filled in

 

Not sure I understand this last sentence; I assume you want to count the number of empty globals:

Sum
( 
  IsEmpty ( globalField1 ) ;
  IsEmpty ( globalField2 ) ; 
  IsEmpty ( globalField3 ) ; 
  IsEmpty ( globalField4 ) ; 
  IsEmpty ( globalField5 )
)

ValueCount ( List ( globalField1 ; globalField2 ; globalField3 ; globalField4 ; globalField5 ) )

I was thinking that Rod was looking for a way to know which fields were empty.

 

 

Case ( IsEmpty ( globalField1 ) ; "globalField1" & ", " ; "" ) &

Case ( IsEmpty ( globalField2 ) ; "globalField2" & ", " ; "" ) &

Case ( IsEmpty ( globalField3 ) ; "globalField3" & ", " ; "" ) &

Case ( IsEmpty ( globalField4 ) ; "globalField4" & ", " ; "" ) &

Case ( IsEmpty ( globalField5 ) ; "globalField5" & ", " ; "" )

Rod said, "...to show how many are empty of those filled in"

 

Count ( field1 ; field2 ; field3 ; field4 ; field5 ) will count how many have any value so if you have 5 fields are want to know how many are empty, it could be:

 

5 - Count ( field1 ; field2 ; field3 ; field4 ; field5 )

 

Don't ya just love how there are so many approaches with FileMaker?  Take your pick, Rod!!    

Don't ya just love how there are so many approaches with FileMaker?  Take your pick, Rod!!    

 

Yeah, nice to have so many approaches towards an unidentified goal. 

Actually I thought Rod was very clear in his need. 

Thanks you all...

 

I liked this one

 

Sum
( 
  IsEmpty ( globalField1 ) ;
  IsEmpty ( globalField2 ) ; 
  IsEmpty ( globalField3 ) ; 
  IsEmpty ( globalField4 ) ; 
  IsEmpty ( globalField5 )
)

 

I might allow 5 agents to log in..

As agents log in, I populate one of the GlobalFields with their persistent_ID  ( is that long not used for anything id)...

I think this calc field now, will let me have a count of still avail agents or if all are agents log out, maybe run another admin routine.