FIELDISEMPTY Function

From Planfix
Revision as of 14:31, 23 June 2025 by Dmitri (talk | contribs) (Created page with "{{#seo: |title=FIELDISEMPTY Function |titlemode=append |keywords=planfix, Function, IF, reports, FIELDISEMPTY |description=FIELDISEMPTY Function }} '''FIELDISEMPTY()''' is a function that helps you check whether a field in Planfix is empty. Return Values: *1 (true — the field is empty) *0 (false — the field contains data) == Format == *FIELDISEMPTY(variable) == Example == The most common use case is inside an IF function, without comparing the result to 0 or 1: <no...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

FIELDISEMPTY() is a function that helps you check whether a field in Planfix is empty.

Return Values:

  • 1 (true — the field is empty)
  • 0 (false — the field contains data)

Format

  • FIELDISEMPTY(variable)

Example

The most common use case is inside an IF function, without comparing the result to 0 or 1:

IF(FIELDISEMPTY({{Task.Agent reward}}); "Please fill in the agent reward field"; "")