If queries

For enumerations, for example, the default value formula could consist of If functions that check which type the respective object belongs to.

CODE

If(Then-Fall; Then; Else)

You can nest these functions by using another If function as Else :

CODE

If(Then-Fall; Then; If(Then-Fall; Then; Else))

For example, if you have created a user-defined field in which the currencies "EUR", "USD", "GBP" and "Other" can be selected from a selection list, you would have to nest three If functions in the default value formula:

CODE

If(Then-Fall; Then;  If(Then-Fall; Then;    If(Then-Fall; Then; Else)))

The formula could be as follows, for example:

CODE

If(Währung.Kürzel="EUR"; "Euro";   If(Währung.Kürzel="USD"; "US-Dollar";     If(Währung.Kürzel="GBP"; "Brit. Pfund"; "Sonstige")))

This formula first checks for each input object whether the currency code is "EUR". If this is the case, it returns the string "Euro" as the result. If this is not the case, it checks whether the abbreviation is "USD" and so on. If the abbreviation is neither "EUR" nor "USD" nor "GBP", it returns the string "Other" as the result.

Lists of keywords can be found in the MM-Talk reference.