Builder View

+ Rule adds one condition. Each condition is three picks: a field (your column set's columns, by display name), an operator, and — for most operators — a value.

The operator list fits the column you picked:

• Text columns get `contains`, `starts with`, `ends with`, and `like` (patterns — see, plus `=`, `≠`, `in`, `not in`, and the "is null" / "is null or empty" family (those last ones need no value — they ask whether the column is missing or blank).

• Number and date columns get `<`, `>`, `≤`, `≥`, `between`, and `not between`, plus the same `=` / `≠` / `in` / null family.

• Yes/no columns keep it plain-language: is true, is false, and is false, null, or empty — no value box at all. That last one is the safe way to say "not a yes": it also catches plays where the column was never filled in.

Values are just as forgiving: free text, number, or date; columns with a known
value list give you a dropdown instead of a box; and `in` / `between` take
comma-separated values in one box ("3, 4" or "0, 10").

Combining conditions:

• The AND / OR buttons at the top of a group set how its conditions combine — AND means a play must pass every test; OR means any one will do.

• + Group nests a sub-group inside, with its own AND/OR — as deep as you like ("Pass plays AND (3rd down OR 4th down)").

• Not flips a whole group — "everything that doesn't match this".

• ✕ removes a rule or a whole group.