True[TRUE] False[FALSE]

Returns TRUE or FALSE in a function where the argument requires True or False data.

Example

The Join Strings [TEXTJOIN] function has the option to ignore empty fields.

TEXTJOIN (“Delimiter”, IgnoreIfEmpty, “Text1”, “Text2”, ...)

 

In the following TEXTJOIN expression, we insert TRUE for the IgnoreIfEmpty argument, which is a True/False data type.

Expression

TEXTJOIN (“, ”, TRUE, Renovation Status, Related Zone Name)

The expression will therefore ignore empty fields.

See Join Strings [TEXTJOIN] for an example.

  • Was this Helpful ?
  • YesNo
Relevant topics
True[TRUE]False[FALSE]
Returns TRUE or FALSE in a function where the argument requires True or False data. Example The Join Strings [TEXTJOIN] function has the ...
Fill Display Mode: True Fill Appearance vs. Bitmap
Each fill type has two faces or display modes: True Fill Appearance and bitmap. By default, all fills in your project are set to be displayed as True Fill, at View > On-Screen View Options. If you turn this control off, fills will be displayed on screen in bitmap mode. However, when ...
Not [NOT]
Changes False result to True and vice versa. Syntax NOT (Logical) Data Types of the Arguments True/False Data Type of the Result ...