IF (condition1) AND (condition2) THEN (result:= )
- If (condition1) AND (condition2): those conditions are the same as the basic if-then statement condition, user can use normal operators and formulas here.
Caution: both of the conditions has to be true before it gives the result, otherwise it will look for another alternative result that requires an Else statement .
If (0<[property1]) and ([property1]<10)
If ('[property1]' = 'Text') and ([property2]<10)
If ('[property1]' = 'Text1') and ('[property2]'='Text2')
- Then (result:=): this is the result of the if statement when both of the above conditions are true
Caution: the returned value for the result will need to share the same type, being either a text or number, with the "inherited-from" property.
Then (result:=[property])
Then (result:='[property]') (if the property type is a text)
Then (result:=[property]-10) (if property type is a number)
Example 1: if a equals 10 and b equals 20 then d will be 10
Example 2: if a equal 10 and b is "text" then d will display "It is correct"
- If (condition1) OR (condition2): those conditions are the same as the basic if-then statement condition, user can use normal operators and formulas here.
Keep in mind: EITHER one of the conditions has to be true, It will give the result. Otherwise it will look for another alternative result that requires an Else statement .
If ([property1]=10) or ([property1]<10)
If ('[property1] = 'Text') or ([property2]<10)
If ('[property1]' = 'Text1') or ('[property2]'='Text2')
- Then (result:=): this is the result of the if statement when EITHER one of the above conditions or BOTH are true.
Caution: the returned value for the result will need to share the same type, being either a text or number, with the "inherited-from" property.Then (result:=[property])Then (result:='[property]') (if the property type is a text)Then (result:=[property]-10) (if property type is a number)
Example 1: either a equals 10 or b is "text". d will display "It is correct"
Example 2: either a is a number smaller than 10 or b is text . d will display "It is correct"