@IsUnavailable (Formula Language)

Indicates whether a field name exists in a document.

Syntax

@IsUnavailable( fieldname )

Parameters

fieldname

The name of a field. Do not enclose the name in quotes.

Return value

flag

Boolean

  • Returns 1 (True) if the field name is not contained in the document
  • Returns 0 (False) if the field name is contained in the document

Usage

Use @IsUnavailable to provide default values for fields in documents created with forms that do not include a particular field name.

CAUTION: Do not confuse @IsUnavailable with @Unavailable. @Unavailable deletes fields and can cause serious damage if used unintentionally in place of @IsUnavailable.

Examples

This example returns Consultant if the field Dept does not exist; if Dept does exist, the value contained in Dept is returned.
@If(@IsUnavailable(Dept);"Consultant";Dept)