Simply drag and drop the '' icon.Conditional'' to the desired position in the column ''.Properties''. Or ''Double click'' on the icon ''.Conditional''.


 


The property defined as such allows you to use conditions in properties.

The command line is entered in the field ''.Conditional''. The syntax ''IFF'' can be used in upper or lower case ''.iff''. The '' character|The '' character is obtained by combining the ''Alt Gr'' and ''6'' keys. To retrieve a property, place the '' character$'' before the property name (case sensitive).

The '' typeConditional'' must be located in the column ''.Propertiesafter the properties it retrieves.


Examples

The '' propertyFinish'' created is to be entered using the following syntax :

IFF($Material=Steel|Polishing|Painting)

If the property ''Materialsis equal to ''Steel''. then the property ''Finish'' will be equal to ''Polishing'' otherwise the property ''Finish'' will be equal to ''Paint''.


The '' propertyType Material'' created is to be entered using the following syntax :

IFF($Material=Steel|$SiSteel|$Other)

If the property ''Materialsis equal to ''Steel''. then the property ''Type Material'' will be equal to the property ''SiAcier'' otherwise the property ''Type Material'' will be equal to the property ''Other''.


You can also nest several conditions one after the other. The sky's the limit!


IFF($Material=Steel|IFF($Material=Alloy Steel|$SteelType|$Other))

The above syntax is not correct, as the IFF must always be in the value SINON.


The correct syntax is :

IFF($Material=Steel|$SiSteel|IFF($Material=Alloy Steel|$TypeSteel|$Other))

- If the property ''Materials'' is equal to ''Steel'' then the property ''TypeMatiere'' retrieves the value of the '' propertySiAcier''.

Otherwise

- If the property ''Materials'' is equal to ''Alloy steel'' then the property ''TypeMatiere'' retrieves the value of the '' propertyTypeSteel''.

Otherwise

- The '' propertyTypeMatiere'' Retrieves the value of the '' propertyOther''.


The following syntaxes can be used for condition equalities:

"=" (equal) for text or numeric values.

"<>" (different from) for text or numeric values.

">", ">=", "<", "< =" for numerical values.


It is also possible to use concatenation, using the '' character.&'', in the instructions ''IFF''.

Fraction values are recognized in the '' instructions.IFF''.

Example - Depending on the value of the '' propertyScale'', the property ''Format'' meets the following condition:

IFF($Scale=1/2|$Format=A4|A3) the value ''1/2'' returns ''0.5''. If the value of the property ''Scale'' is equal to ''0.5'' then the property ''Format'' will take the value ''A4'' otherwise it will take the value ''A3''.


Possibility of using the '' wildcard character*'' in conditional operations :

*Steel to take into account values ending with the characters Steel.

Steel to take into account values beginning with the characters Steel.

*Steel* to take into account values containing the characters Steel.