Survey123: Capitalize user's input/Replace whitespaces

Question

Hello all,

I'm using Survey123 Connect with ArcGIS Enterprise 10.5 feature services

I am wondering if there is a way in a Survey123 XLSform to take a user's input to a text field (example: serial number -> g964-b764) and perform a calculation to change all lowercase letters in the string to uppercase. Also, I would like to replace any whitespace in a text string with either no whitespace, or a hyphen. Is this possible?

In python, these are equivalent to str.upper() and str.replace()

Thanks!

cnnlly · Answer

If the length of the entry is going to be variable, mask may not work unless you just make the X string very long.

AaronThompson · Answer

Carmel,

Thanks for the response. If my understanding of the input masks is correct, I can't make it an unknown length and apply it to all characters, or allow for either text or number in any given index of the string.. So it doesn't seem to me like this fits the bill for my situation?

cnnlly · Answer

Hi Aaron,

This should work by using a mask: Esri custom columns—Survey123 for ArcGIS | ArcGIS

Entering something like >xyz will allow a 9 character string with all letters capitalised

If serial numbers vary in length you may need to make changes to allow for this.

If the serial numbers are consistant, you could use something like this for the mask:

>xyz-xyz

Hope that helps!

Carmel