Compare two text withouth case sensitive

edited October 2019 in Questions
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

Comments

  • edited October 2017
    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
  • edited January 2018
    Thank you Bill!!

  • edited October 2019
    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".
Sign In or Register to comment.