Does anyone know why the .uppercase option would be missing in this screenshot? I’m wanting to convert the search criteria from the user into uppercase and then search for that search criteria in a database column. The uppercase option is there for one half of the criteria but not the other. The input field is set to text.
Figured it out.
Instead of trying to convert the input’s value to uppercase (which should be possible but oh well), use an arbitrary text value instead which contains the inputs value and then that arbitrary value can be converted to uppercase.
You didn’t activate parenthesis feature right? This is why you don’t have option to set uppercase because actually, you only see operators for boolean (yes/no) at the end of the formula you have. If you enabled the parenthesis feature, you should have another more right after the ticket value to set :uppercase
1 Like
Thanks that worked as well as the one I discovered above. I’m glad there was a solution!
1 Like