Skip to main content

Understanding "Empty" vs "F" in NetSuite Filters

Use "is not T" for checkbox fields to match both F and empty — they behave differently in NetSuite.

Kolleno Support avatar
Written by Kolleno Support
Updated over a month ago

When setting up conditions in workflows, for checkbox fields coming from NetSuite, it's important to understand the difference between the values Empty, F, and T.

What’s the Difference?

In NetSuite, checkbox fields can have three possible values:

  • T — the box is checked (True)

  • F — the box is unchecked (False)

  • Empty — the value has not been explicitly set

So when you create a condition like:

  • "When [field] is empty"
    → This will not match F — it only matches if the field has no value at all.

  • "When [field] equals F"
    → This will not match empty fields — it only matches if the field is explicitly set to F.

Recommended Approach

To avoid confusion and unintended matches, we recommend using:

  • Operator: is not

  • Value: T

This setup will match both F and empty, which are typically treated the same in business logic — i.e., “not true.”

Summary

Condition

Matches T

Matches F

Matches Empty

equals F

is empty

is not T (recommended)

Use this approach to ensure your workflow behaves consistently when dealing with NetSuite checkbox fields.

Did this answer your question?