Latest Contributions by BRYANHERRON

‎11-13-2019

Got it. Order is restored to the universe... until I break it again. Thank you.

‎11-13-2019

Do you mean set the bind:esri:fieldType column to esriFieldTypeInteger? I did that and there was no change. I was certianly hoping that was going to be the fix; it sounded like it was going to be. I rebuilt a new form typing in everything in the type & name column from scratch and copy/pasting the rest of the form. No change. Actually after I typed in the 14 name fields for Employee1, I copied them to Employee2-4 and changed the number accordingly. Evidently you can't do that either. It seems that if you window everything in columns C thru AE in one form and paste that into a new form, that none of the pulldowns will work in C thru AE in the new form. WHAT CAN YOU COPY/PASTE?

‎11-13-2019

OK, I have a survey123 form that exports to a paper form that among other things is set up to capture hours worked on specific tasks for up to 4 employees on a specific job. On the left, Employee1 totals correctly, Employee2, 3 & 4 does not. These were all working correctly until I rearranged the form. I inserted rows and copy/pasted entire rows to put the questions in better order than they originally were. Why is editing these forms such a pain? First off the leading zeros are the default that is set. Overwriting them or leaving them makes no difference in the calculations. In the second pic you can see that the top 4 input boxes are multiplied by 10 and added together, or Survey123 is appending a 0 to the end. Regardless, 1+1+1+1=40. In the last 2 pics you can see that the time entered in the Soil testing box is not added, but is appended to the end of the integer in the total box, 1+1+1+1+1=401 and 1+1+1+1+2=402 Possibly the dumbest thing I've ever seen. Why did/does this happen? Can it be fixed? How do i fix it? Retype everything from scratch without copy/paste? Surely that's not what is expected.

‎11-12-2019

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.

‎11-05-2019

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

‎11-05-2019

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

‎11-05-2019

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+00, 100' down the road there's a manhole, that manhole is at 1+00. 3000 feet down 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. So how do I put this into Survey123 for these results on the input? 1+23 12+34 123+45 1234+56 12345+67

‎10-16-2019

This understanding will solve other problems I thought I had, hehe.

‎10-16-2019

Actually, This is my first form and I just learned something..... I had the code correct to start with, but my expectations were incorrect. you can enter anything you want and the form will happily allow you to continue on down the road and only alert you to the error of your ways when you try to submit the form. Is there any way to automatically kick out bad input on the spot?

‎10-16-2019

Yep, I thought I had tried that as well. I have Gremlins...

‎10-16-2019

The work our guys do usually can't be done when the ground is frozen, so -20 may be giving them a lot of leeway.

‎10-16-2019

Easy for you to say. hehe I am not familiar with setting up a domain.

‎10-16-2019

I can't get the constraint's syntax correct for a range of -20 to 120.

‎10-16-2019

I have a Survey question that is simply the temperature. Our field guys won't be working on days that are -200 degrees or 200 degrees, but I can't figure out how to force there answers to the question between a certain range. How do you do this?

‎10-15-2019

Jim & Sun, thank you both for shedding a little light on this. I haven't read the link Jim sent yet, but will after adding a little detail to the situation. Here's the details. I have a list of 17 Employee Names. Each employee has a classification (Corrosion Tech 1-4, a couple engineers, etc.) So I use the select_one or_other allowing for the option to add a name that's not on the list. I am also exporting these reports to a word document form, so I can't use repeats. So with the or_other I had to add the Collated field in line 133 to capture the answer to the question for the form. Then, for each Employee name, I have a note with e relevant calculation and if the relevance is satisfied the note with the appropriate classifications appears in in the Survey123 app, for each name including the or_other option which I default to Tech-1, but the Classification does not does not upload to with the survey. There's a column for each Classification, but no data entered. I think I'll Collate the classification answer to see if that will upload.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by BRYANHERRON

Re: 1+1+1+1+1=401?

Re: 1+1+1+1+1=401?

1+1+1+1+1=401?

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

Re: How do you format integers for Engineering Stationing?

How do you format integer input in Survey123 Connect?

Re: Can you create custom number formatting in Survey123?

Re: Setting a Temperature Range

Re: Setting a Temperature Range

Re: Setting a Temperature Range

Re: Setting a Temperature Range

Re: Setting a Temperature Range

Re: Setting a Temperature Range

Setting a Temperature Range

Re: How do I get "note" type data to upload with the rest of the survey?

Setting a Temperature Range

Re: Can't follow my own XLSForm programming!?!?

Re: Pulldata in multiple surveys from single sourc...