Convert string to upper or lowercase

[deleted-user-En3Sgx626CLb]

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.

[JamesTedrick]

Hi Brian,

There are not built-in functions within the XLSForm spec to generate all uppercase or lowercase text from a response.  This could be done in the field app via a custom javascript function, which is a beta feature - see more at the Early Adopter Community.

[deleted-user-En3Sgx626CLb]

Nice, this is exactly the feature needed and also opens the doors for a lot of the possibilities. Unfortunately, looks like there is a bug tied to it that may be impacting deployment - seeing the Extensions disabled message for non-admin users of the survey in same organization. Appears users have reported it and plans is to fix in 3.5. Need to take a closer look at and see if that resolves the issue, thanks!

[DeonLengton]

Hi James

When will this move out of Early Adopter?

[JamesTedrick]

Hi Deon,

Currently the only issue preventing release involves the authoring process- currently, Survey123 Connect must be restarted if you make a change to the JS file.  We are hoping to resolve that for the next release.

[CindyJayakumar]

This is excellent news. We've been trying out this functionality extensively within the team, so I'm really excited to roll it out on a project as soon as it moves into production.

[ahargreaves_FW]

@JamesTedrick any update on your answer from over 3 yrs ago? The ability to easily switch cases and/or to compare strings regardless of case, is a common need.

[SamuelSchneider]

Is this method of changing the JavaScript file still the recommended method? Am I able to use the UPPER() Excel function in any capacity?

Thanks!

[chelynnes]

Has this been resolved yet? I feel like it should be easier. You can do it to normal excel docs. 

[Scott_Sambell]

Is there any progress on this? I need to compare two GUIDs in a form and for some reason one is coming in as lowercase and the other uppercase.  All i need to do is change one or the other and compare them to trigger conditional visibility on a note.  Very simple stuff but i can't do it without changing the case on one of them.