topic Re: Syntax for calculations referencing a specific repeat record in ArcGIS Survey123 Questions

Syntax for calculations referencing a specific repeat record

ByronTsang — Tue, 22 Oct 2019 18:36:59 GMT

Is there a pulldata() syntax or some other way to perform calculations on a specific/previous record or records within a repeat? I am trying to make a series of calculations that compare the values between sequential records in a repeat.

For example, I have a repeat for collecting data for trees adjacent to a sample location. For report formatting purposes, these need to be recorded in descending diameter (largest tree to smallest). Within the repeat I have two user-entry fields ${treespecies} and ${treediameter}.

I want to also include a note to alert the user if they enter a value larger than a value in a previous repeat. I was hoping to use the Relevant function with a formula along the lines of:

(${treediamater, [previous value]} >= ${treediamater, [current value]}).

Another useful alert would be for assigning values for unusually large trees, for example a warning if a tree diameter is more than double the average diameter across all repeat entries.

Re: Syntax for calculations referencing a specific repeat record

JamesTedrick — Thu, 24 Oct 2019 21:19:02 GMT

Hi Byron,

There currently isn't a direct method for accessing a previous repeat's value in another repeat.

Re: Syntax for calculations referencing a specific repeat record

RobertGeitner — Thu, 24 Oct 2019 21:34:25 GMT

So after a repeat I get a decimal calculation, but I am not allowed to extract that value and use it in another calculation?

Re: Syntax for calculations referencing a specific repeat record

DougBrowning — Thu, 24 Oct 2019 22:41:35 GMT

If you are for sure doing them in order then my trick listed here should work

Populate a field within a repeat from a previous entry within same repeat?

You can use sum and count across a repeat to handle your other question.

See here Formulas—Survey123 for ArcGIS | Documentation

Re: Syntax for calculations referencing a specific repeat record

RobertGeitner — Fri, 25 Oct 2019 15:11:46 GMT

Hey Doug and James,

I have been working on this for about 4 months, and I can get the calculations I need from the repeat outside the repeat. Everything worked fine on that, and I can see the calculations value as a decimal in connect outside the repeat. I then want to use that decimal to use in one final calculation but for some reason it turns those decimal values into a 0 or a 1. I actually put the calculations in the 'label column' as well so in Connect I can actually see the values they are pulling and that is how I know they are using 0s and 1s. I would like to attach the file and have one of you look at it because I am utterly beat at this point.

Please let me know what you find! Your help would be much appreciated.

Rob

Re: Syntax for calculations referencing a specific repeat record

RobertGeitner — Fri, 25 Oct 2019 17:12:03 GMT

James,

I am only returning 0s and 1s from my calculation, yet it is a decimal between 0 and 1. I have attempted to edit the bind:type as well as the type to see if I insert int. or decimal and nothing seems to come back correct. Do you have any idea what I am doing wrong?

Thank you,

Rob

Re: Syntax for calculations referencing a specific repeat record

DougBrowning — Fri, 25 Oct 2019 17:33:39 GMT

You did not attach anything.

Re: Syntax for calculations referencing a specific repeat record

RobertGeitner — Fri, 25 Oct 2019 17:56:45 GMT

Doug,

Sorry, the real issue is that my calculation work but when I go to use them in a proceeding calculation they turn into 1's or 0's. Thanks for the help.

Cheers,

Rob

Re: Syntax for calculations referencing a specific repeat record

DougBrowning — Fri, 25 Oct 2019 18:23:56 GMT

Why do you have all of these as type text? Then you bind to int.

I would think just make the type in column 1 decimal. I think its getting confused as to what type it should be. Line 58 works since it is decimal.

Just a guess.

Re: Syntax for calculations referencing a specific repeat record

RobertGeitner — Fri, 25 Oct 2019 18:48:55 GMT

Doug,

I changed all the type in Column 1 to either decimals or calculations, and up to line 48 everything works fine as usual. However, I highlighted line 49-53 in red because those calculation values continue to convert to either 0's or 1's. I see the values they are pulling from in Connect and they are the correct number (i.e. .25 or .50), but as soon as I pull those numbers into the next calculation they turn into 0's or 1's so my multiplication is then thrown off.

I have tried this with multiple different XLSForms and they all seem to do the conversion to 0's and 1's. Not an aggregate issue, just a rounding issue. Can you look at this new version once more?

Thank you,

Rob

Re: Syntax for calculations referencing a specific repeat record

JamesTedrick — Fri, 25 Oct 2019 20:54:10 GMT

Hi Robert,

In the file you submitted today, your decimal questions have a bind::type of int, which indicates that the result will be an integer. Removing that will cause the formula to work correctly

Re: Syntax for calculations referencing a specific repeat record

DougBrowning — Mon, 28 Oct 2019 15:15:19 GMT

Your form is hard to follow with all the converting of numbers. I do not think you need any of that. All the if(0,1) can just bind to int and be done.

Big ones

I moved the end repeat up to line 24 since I think sum must be outside the repeat to work.

49-52 should be decimal type not int

Removed int bind from lines 28 to 52 since these should be decimal. You are doing a div then bind to int so of course you get 0 since it is 0.6666 int drops the digits.

I see values now.

Re: Syntax for calculations referencing a specific repeat record

DougBrowning — Tue, 07 Jan 2020 21:00:06 GMT

Just saw today that Collector now has this kind of.

Reuse Field Entries

Now you can easily reuse values that you previously entered into your form to minimize repetitive data entry and spelling mistakes. This can be quite useful when entering frequently used text such as a street name or Inspector.

Directly above the keyboard, in the keyboard accessory view, you can tap on “Recent Values” and find up to 3 previous values entered for that field to choose from.

What’s New in Collector for ArcGIS (January 2020)