Convert string to upper or lowercase

388
5
05-22-2019 06:10 AM
Highlighted
New Contributor

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.

Reply
0 Kudos
5 Replies
Highlighted
Esri Esteemed Contributor

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.

Reply
0 Kudos
Highlighted
New Contributor

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!

Reply
0 Kudos
Highlighted
Occasional Contributor II

Hi James

When will this move out of Early Adopter?

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

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.

Reply
0 Kudos
Highlighted
New Contributor

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.

Reply
0 Kudos