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; } } }

Calculate field type

ShaneClarke

Is there any information on the "calculate" field type? It is listed as a valid field type in the XLSForm "types" worksheet, but I can't find any information in the Survey123 help on this. And the "Calculations" sample uses the "calculation" column, but does not use the "calculate" field type.

Thanks!

Encontre mais publicações marcadas com

Accepted answers

All comments

JamesTedrick

Hi Shane,

As described in XLSForm essentials—Survey123 for ArcGIS | ArcGIS , calculate questions are designed to hold the results of calculations based on other questions. For example, if you are inventorying vehicles, you can have separate questions for the number of passenger cars, trucks and cargo vans. you can have a fourth question that is the total number of vehicles that adds together the previous 3. Calculate questions are not displayed on the form, as they are automatically calculated without the survey taker's interaction. More information on the type of calculations that can be done in a form is at Formulas—Survey123 for ArcGIS | ArcGIS .

ShaneClarke

Thanks, James!

Scott_Sambell

Okay, can anyone tell me what the point of a "calculate" field type is? You still have to add another field to feature layer if you want to use it. What is the difference between that and just a hidden question? What am i missing here? They would actually be a really handy thing to have if you didnt have to add another field to your feature layer eveytime you wanted to use it. As far as i can tell though they are completely redundant.

ChrisCarver

Hey Scott -

To avoid adding another field to your feature you can set the 'bindEsriFieldType' to null. This prevents the field from being a part of your feature. You can then use the calculation value from the calc field to populate a field in your form that DOES exist in the feature. It is a bit cumbersome and kind of roundabout. I typically like to perform calcs directly in the needed field; if that isn't practical then I default to javascript. Hope that is helpful!

Scott_Sambell

Hi Chris. Okay so if i set bindEsriFieldType to Null i an use the "calculate" field type as intended? Awesome. That's really handy. I knew there must be a logical reason for having it. Thanks heaps!

ChrisCarver

No problem! Glad I could help!

JohnMedema

How do we take the result of the calculation and display as a field in the form?

ChrisCarver

Hey John - reference the value of the calc field by using its field name like so: ${myCalculatedField} in your formulas. So if you have a field called 'sum' that adds two other fields 'fieldOne' and 'fieldTwo', the calculation column for 'sum' would look like this: .=${fieldOne} + ${fieldTwo}

Then to reference 'sum' somewhere else, you can use the field reference as the default value, like so: ${sum}

Does that help?

JohnMedema

Hi Chris,

Im confused. Here is how my excel is currently formatted.

type = calculation

name = surveylength

label = ${surveylength}

calculation field = ${surveylength} = ${endstation} - ${bgnstation}

begin station and end station are both type decimal and require user input.

what am I missing?

calc.png

ChrisCarver

Hey John,

So Close!!! Just cut off the red part here: ${surveylength} = ${endstation} - ${bgnstation}

Had to edit this because the word 'snip' must include the 's'......

JohnMedema

Thank you Chris

ChrisCarver

You bet! Happy to help!

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.