FIELDISEMPTY Function: Difference between revisions
From Planfix
No edit summary |
|||
| Line 14: | Line 14: | ||
== Example == | == Example == | ||
The most common use case is inside an IF function, without comparing the result to 0 or 1: | The most common use case is inside an IF function, without comparing the result to 0 or 1: | ||
<nowiki>IF(FIELDISEMPTY({{Task.Agent reward}}); "Please fill in the agent reward field"; "")</nowiki> | <nowiki>IF(FIELDISEMPTY({{Task.Agent reward}}); "Please fill in the agent reward field"; "")</nowiki> | ||
== Go To == | == Go To == | ||
*[[Standard functions]] | *[[Standard functions]] | ||
Latest revision as of 14:33, 23 June 2025
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"; "")