AnsweredAssumed Answered

Convert string to upper or lowercase

Question asked by bbrown_geodecisions on May 22, 2019
Latest reply on Aug 7, 2019 by cindy.jayakumar

Is there a way to convert a string to all upper or lowercase or are there any plans to add this feature in the future? Not seeing any functionality listed in formulas. For validation we need to match two strings, the email of the user signed into S123 against a list of emails stored in the choices tab. The emails stored in Portal do not have consistent casing and the emails we are checking in the choices are coming from a different system. Would be nice to have a feature like: lower(property('email')) = lower(${INSPECTOR}) on the constraint. ${Inspector} is coming from a dropdown of email choices, the user does not type in their email.

Outcomes