topic Re: How do you format integer input in Survey123 Connect? in ArcGIS Survey123 Questions

How do you format integer input in Survey123 Connect?

BRYANHERRON — Tue, 05 Nov 2019 18:22:00 GMT

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

Re: How do you format integers for Engineering Stationing?

RobertBorchert — Tue, 05 Nov 2019 19:45:02 GMT

This is a very good question. and I had to dig into it.

In Pro

when building your table. Go to the attribute. Set it as a long integer. Go the Number Format option

Choose custom and type in your format string. Make the first set of pound signs at least as long as your longest first part

Test it out.

Type in your numbers

When you hit enter it will have the plus sign

Re: How do you format integers for Engineering Stationing?

BRYANHERRON — Tue, 05 Nov 2019 20:08:48 GMT

Yes, same as formatting the cells in Excel, but I am not building an attribute table in Pro or Desktop. I see now that I didn't express that anywhere in the question. Now I need to figure out how to edit the original question.

I am using Survey123Connect to build forms, so I'm building this all in the XLSForm. I can add the formatting in the esri:inputMask column as XX+XX and it works as long as it's a 4 digit #. I can't get it to format regardless the # of digits. Also if the Engineering Station is 1 or 11 the result should maintain the leading zeros.

1 = 0+01

11 = 0+11

111 = 1+11

1111 = 11+11

Re: How do you format integer input in Survey123 Connect?

JamesTedrick — Tue, 12 Nov 2019 19:19:27 GMT

Hi Bryan,

You can add # to get to the maximum number of entries on the left side. Given that text is entered left to right, you would need to have the 0's typed in to ensure proper spacing.

Re: How do you format integer input in Survey123 Connect?

BRYANHERRON — Tue, 12 Nov 2019 20:07:08 GMT

Technically there is no maximum number of digits preceding the "+", but in reality you rarely see more than 4.

Are you just commenting that my initial assessment was correct and that the esri:mask will not recognize the Excel cell formatting the way Excel does and only allows for same number of digits? That's where I was when I posed the initial question. All I'm asking is if anyone knows how to make this happen.

If setting the esri:mask to the maximum number of characters and having the field guys type in 8 characters regardless, I won't bother.

In excel when I custom format cells as XX+XX, an input of 1-9 results in +1, and integers between 10 and 99 result in +10 through +99 and I can live with that. Any integer above 10, up to where excel starts throwing exponents, works perfectly placing the + as the 3rd character from the right.

So back to the poorly ocnveyed meaning of my original question. Can someone show me how to accomplish this excel outcome in Survey123.

Re: How do you format integer input in Survey123 Connect?

JamesTedrick — Wed, 13 Nov 2019 22:29:44 GMT

Hi Bryan,

As I've outlined, Survey123 can support an input mask like ####+## to support this entry; however, text entry is left-justified, so you would need to input with leading 0's

Re: How do you format integer input in Survey123 Connect?

BRYANHERRON — Thu, 14 Nov 2019 13:43:18 GMT

Thank you James, but we aren't hearing each other, for whatever reason. Nothing you've said addresses the actual question I have, even after clarifying and restating it again. You aren't getting what I'm saying and I'm not getting anything from your responses that actually address my question. No fault given, I just think we're on different wavelengths. I don't comprehend an "outline" of anything, but a vague restatement of my original discovery of the limitations of the mask and nothing hinting to whether there is any other way to accomplish what I am trying to do, and all I know to do is ask the original question in a different way. So forgive me for my frustration, but we are not communicating in a productive way, at all.

I fully vetted what you have offered in your replies before submitting the original post and I thought it was clear that I was asking for a solution for the outcome I desired, any solution, or conformation that this is currently not possible.

I guess, instead of the following, from the original post...

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

I should have asked "Is there any way to format an integer question so that regardless of the number of characters typed in, the result. is a two-place decimal with the decimal point replaced with a + sign?". Actually that one sentence should have been the entire post. hehe

Re: How do you format integer input in Survey123 Connect?

BRYANHERRON — Thu, 14 Nov 2019 13:56:20 GMT

James, I just thought of something. Could I use relevance, based on the number of characters input, to choose which mask is used? That way I could use a single digit mask, a 2 digit mask, a 3 digit mask and so on.

Re: How do you format integer input in Survey123 Connect?

MikailaBell — Thu, 14 Nov 2019 14:42:53 GMT

Hi Bryan, I would try using text fields, for the data you wish to sum. Summing numbers-as-text often gets reported as a bug. When text fields containing numbers are summed, it performs the sum operation in the weird-ass engineering way that you desire. That is not what most people want, so they get told to switch to numeric fields.

In your case, you want that weird form of addition. So I suggest you try using text fields, to store your numbers, and then perform the sum operation.

Good luck!

Re: How do you format integer input in Survey123 Connect?

BRYANHERRON — Thu, 14 Nov 2019 15:04:03 GMT

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 +.

Re: How do you format integer input in Survey123 Connect?

JamesTedrick — Thu, 14 Nov 2019 22:32:45 GMT

Hi Bryan,

Yes, in theory you could have a separate question for each different length of digit accepted.

To clarify, Survey123 will not allow for what you have exactly described. It can support, via the input mask, the text pattern of station marking, but the number must be padded with 0's for any number not present (i.e., if you have it set to accept 5 numbers to the left of +, 1+01 needs to be entered as 00001+01). This is because text is entered from the left with a subsequent character being placed to the right (as you enter text in a word processor), not from the right with each character shifting the previous characters to the right left (as you see a number entered in a calculator).

Re: How do you format integer input in Survey123 Connect?

SarahBenner — Tue, 19 Jan 2021 16:29:21 GMT

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.