FileMaker treats string without numbers as false
The Following has a result of: 1
----------------< Start Block >----------------------
Let ( [
~result = "abceefghijlomonp"
];
not ~result
)
----------------< End Block >------------------------
The following has a result of: 0
----------------< Start Block >----------------------
Let ( [
~result = "abceefghijlomonp123"
];
not ~result
)
----------------< End Block >------------------------
Result: 0
----------------< Start Block >----------------------
Let ( [
~result = "1"
];
not ~result
)
----------------< End Block >------------------------
Result: 0
----------------< Start Block >----------------------
Let ( [
~result = 1
];
not ~result
)
----------------< End Block >------------------------
Result: 0
----------------< Start Block >----------------------
Let ( [
~result = True
];
not ~result
)
----------------< End Block >------------------------
Result: 1
----------------< Start Block >----------------------
Let ( [
~result = False
];
not ~result
)
----------------< End Block >------------------------
Result: 1
----------------< Start Block >----------------------
Let ( [
~result = "0"
];
not ~result
)
----------------< End Block >------------------------
Result: 1
----------------< Start Block >----------------------
Let ( [
~result = ""
];
not ~result
)
----------------< End Block >------------------------
Resutl: 1
----------------< Start Block >----------------------
Let ( [
~result = " "
];
not ~result
)
----------------< End Block >------------------------
Result: 1
----------------< Start Block >----------------------
Let ( [
~result = "a b c"
];
not ~result
)
----------------< End Block >------------------------
Result: 1
----------------< Start Block >----------------------
Let ( [
~result = "a b c ,:@#$%^&*()-=~`;'[]{}"
];
not ~result
)
----------------< End Block >------------------------
Comments
0 B
|👍
/👎