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.