Finding empty or non-empty fields

  1. Start a find request.

    See Making a find request.

    2. To find fields that are

    Enter this in the field

    Not empty (fields that have data)

    *

    Empty

    = (see Notes)

  2. Click Perform Find in the status toolbar.

To find empty container fields:

Use one of these methods:

  • Define a calculation field in the same table as the container field. In the calculation, use the GetAsText function. For example:

    Copy 
    GetAsText ( table::container )

    Place this calculation field on the same layout as the container field. Then perform a find request for records in which the calculation field is empty, as described above.

  • Define a script that shows all records and then omits each record with a non-empty container field. For example:

    Copy 
    Show All Records
    Go to Record/Request/Page [ First ]
    Loop [ Flush: Always ]
       If [ not IsEmpty ( table::container ) ]
          Omit Record
       Else
          Go to Record/Request/Page [ Next ; Exit after last: On ]
       End If
    End Loop

Notes 

  • If any value is empty in a repeating field, then a search using "=" returns that field.

  • To find empty fields formatted as a checkbox set or a radio button set, in the find request, right-click the field, choose Operators, then choose =.

  • A search using "=" finds empty fields as well as fields that contain an empty line. To find fields that are entirely empty (no characters or empty lines), perform a find request using "==" in the field.

Related topics