nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Syntax for calculations referencing a specific repeat record

ByronTsang

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.

Encontre mais publicações marcadas com

Accepted answers

JamesTedrick

Hi Byron,

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

All comments

dougbrowning

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)

dougbrowning

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.

JamesTedrick

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

Form 8.xlsx

RobertGeitner

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

Repeat Transect.xlsx

RobertGeitner

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

Repeat Transect.xlsx

dougbrowning

You did not attach anything.

RobertGeitner

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

RobertGeitner

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

dougbrowning

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

RobertGeitner

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

JamesTedrick

Hi Byron,

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.