0

Nested IF Statements

When I create a function like this, I receive an Error: This formula may not modify data:

let text1 := "";
if Address2 := null then
text1 := "xxx"
else
text1 := "yyy"
end;
text1

Any idea what I am doing incorrectly?

2 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    In your if expression you are using the assignment operator instead of the comparison operator.

     

    This:

    if Address2 := null then

    Should be this:

    if Address2 = null then

     

    Ninox reads your expression as if you are trying to assign null to Address2.

    • chuckhoffman
    • 5 yrs ago
    • Reported - view

    Thanks! Now I see it.

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1458Views