iff(condition,true,false)


Description

executes the trus statement if the condition is true otherwise the false statement is executed.

Examples

iff([checkbox],"T","F")
this expression will enter a T into the folder if the [check box] folder has a value and F otherwise.

iff([Engineering Projects],"""H:\20"+match(ITT,'\b(\d\d)\d\d\d\b')+"\" + match(ITT,'\b\d\d(\d\d\d)\b')+"""","")
If the folder [Engineering Projects], a checkbox folder, has value then a string based on the item text is created of the form "h:\20dd\ddd" where the 'd' represents extractions from the ITT.
If the folder [Engineering Projects] has no value then "" , null, is used.

References