AnsweredAssumed Answered

Search and omit multiple empty container fields

Question asked by kschjei on May 20, 2016
Latest reply on May 23, 2016 by kschjei

I have 5 container fields and if all or any 1 of them is empty I want to omit the record. My goal is to just show the records that have documents in all 5 of the containers. I found the below calculation for finding a single empty container field and omit it. Thanks in advance for any help you can give me.

 

Show All Records
Go to Record/Request/Page
[ First ]

Loop
      If
[ IsEmpty ( TestFile::container ) ]

          Omit Record

     Else

         Go to Record/Request/Page [ Next; Exit after last ]

     End If

End Loop

Show Omitted Only

Outcomes