Formula to check in a Case-insensitive version of a field

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”.

Leave a comment

Your email address will not be published. Required fields are marked *