Skip to main content

Hi at all,
I’ve created a formula
IF({{Telefono}}=={{$Model.Pratica.data.0.Azienda__r.Phone}},“”,“!”)

It’s working fine but I want It case insensitive. 
Any idea?
Thank you

Andrea,

Add UPPER() to both sides of your comparison.  This should get you what you want.


IF(UPPER({{Telefono}}==UPPER({{$Model.Pratica.data.0.Azienda__r.Phone}}),"","!")


Thanks,

Bill


Thank you Bill!!


Very helpful, thanks Bill! It would be great for Skuid to add this to the function menu (Are there any Skuids Listening???)
-Disregard… I see it in there now, but it brings up another issue, I am unable to scroll to the bottom of the function menu with my mouse in Chrome. I had to use my touch screen to scroll past “Round”.