How do you format integer input in Survey123 Connect?

[BRYANHERRON]

OK, so in my industry we have what we call Engineering Stationing. Say you have a centerline of a highway and the start of the highway at some road intersection is 0' from the beginning, or 0+00, 100' down the road there's a manhole, that manhole is at engineering Station 1+00. 3000 feet from the beginning of the road there's an intersection, that would be 30+00. This is Engineering Stationing and in Excel the cell formatting is XX+XX so whatever you type in the "+" is always the 3rd digit from the right. Unless you allow for decimals and change the formatting to accommodate. If I put XX+XX into the inputMask column it works ONLY if the input is 4-digits.

So how do I put this into Survey123 for these results on these inputs?

input 1 = 0+01

input 11 = 0+11

input 123 = 1+23

input 1234 = 12+34

input 12345 = 123+45

input 123456 = 1234+56

input 1234567 = 12345+67

[BRYANHERRON]

Hey Mikaila, I'm actually not adding anything. The plus is not a mathematical plus. This is an industry standard engineering unit of measure called Engineering Stationing (ES). Whether you are engineering a highway centerline or a pipeline centerline the beginning point of the centerline is zero, expressed as 0+00. Ten feet down the centerline is expressed as 0+10. Think of it as another unit of measure where 100 feet= =1 ES, just like 10 mm = 1 cm. So 125 feet = 1.25 ES, but with ES we replace the decimal with the +, so 125 feet = 1+25 ES. 123,456 feet = 1234+56 ES, no commas.

So, essentially it's a two-placed decimal, but displaying the decimal point as a +.

[SarahBenner]

Hi Bryan,

I know this is a bit of an old post, but in case anyone else had a similar question (like I did).  Another way to accomplish this, especially if you want it to only allow numerical input is as follows:

In the body::esri:inputMask column, you would enter
0000000000+99

This will allow the user to enter up to 10 numerical characters on the left of the + , followed by two required numerical characters.  Note, that the user can just type 123 (without putting in the plus sign), and it will be stored & shown as 1+23.  The only thing to remember is that in the case of your first example for 0+01, the user would need to enter 01 instead of just 1, because two numerical characters are required on the right.