
This formula checks if the value of the field {custrecord_eff_projecttype} contains the string “zakelijk” in a case- insensitive manner by converting the field to lower case using the LOWER function and then using the Like operator with the wildcard characters “%”, if it’s true it returns “zakelijk found”, else returns “zakelijk not found”.