October 6, 201114 yr I'm looking for a custom function that will give me all the names of the field objects on the frontmost tab. I can make one, but I'd rather save myself a couple hours work if I can. Anyone have one? Thanks, David
October 6, 201114 yr Author All right, didn't take me as long as I thought and I clarified my requirements for myself. /*Empty Fields ( object ; counter ) by David Jondreau, www.wingforward.net This function is meant to take a tab name as the object parameter and return a 1 if any of the named fields are empty, 0 if they have values */ Let([ objects = GetLayoutObjectAttribute ( object ; "containedObjects" ) ; end = ValueCount ( objects ) ; thisObject = GetValue ( objects ; counter ) ; thisType = GetLayoutObjectAttribute ( thisObject ; "objectType" ) ; isField = ( thisType = "field" ) ; empty = isField and IsEmpty ( GetLayoutObjectAttribute ( thisObject ; "content" ) ) ; result = Case ( IsEmpty ( end ) ; 0 ; empty ; 1 ; counter ≥ end ; 0 ; EmptyFields ( object ; counter + 1 ) ) ]; result )
Create an account or sign in to comment