TRUE

The TRUE function is a boolean function in Data Sync that returns the logical value true. It is used when you need to return a boolean value that represents the true state.

Syntax

bool TRUE()

Example

You can use TRUE inside other functions, for example IF.

Suppose you have a boolean column that tells you if an invoice has been paid or not, but you want to return a text value to represent this. You can use the following:

IF(InvoicePaid == TRUE(), "Paid", "Unpaid")

This will return Paid if the value in InvoicePaid is true, otherwise it will return Unpaid.