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

How to format display of calculated result in Survey123

JimTolbert

I am using Survey123 for a Road Tour app. Part of that is calculating the square yards of a segment. Currently, I am successfully calculating the area with a "calculate" statement as displaying the result with a "note" statement. I have been unable to successfully format the result to an integer. I have tried input mask, but it is not an input and I tried "esriFieldTypeInteger" in the "bind::ersi:fieldType". The length and width are read from previous data with pulldata(). Any suggestions? Many thanx............ jt

Finde mehr Beiträge mit dem Tag

Accepted answers

JamesTedrick

Hi Jim,

You will need to manually apply the conversion to integer in the calculation. There are two functions that you could use:

- int() - transforms to integer by dropping the non-integer portion

- round() - rounds the result; using 0 as the number of decimal places will result in an integer

All comments

JimTolbert

Screen shot of Survey123 Connect

JamesTedrick

Hi Jim,

You will need to manually apply the conversion to integer in the calculation. There are two functions that you could use:

- int() - transforms to integer by dropping the non-integer portion

- round() - rounds the result; using 0 as the number of decimal places will result in an integer

JimTolbert

Perfect! Thanx!

Now I want to take that result and multiply by a factor ( number of ways to do that) so that, in the screen shot above, it would show

Asphalt Overlay ~ $117,320 (which is $40 per sqr yard * total Square yards)

Chip Seal ~ $9,326 ( which is $3.18 per squ yard * total square yards)

etc.

Any suggestions there?

JamesTedrick

Hi Jim,

That shouldn't be an issue - if the number is hard-coded, you can include it in the calculation or as an additional calculation. It could also be a choice list or other question and then plugged into the formula by reference.

JimTolbert

Hi James.... My query is more on utilization of real estate on the screen. What I have now is a select multiple other statement. Can I put a calculation into the options for the selection list? I have tried just adding ${var-name} in the label and that didn't work. Thanks much for your help!

AdiKurniawan

Hi James,

I also face a similar problem. My calculation result shows that the number is store as a string instead of integer format when I try to access through an indicator in operation dashboard. I have tried to follow your suggestion to add a syntax int() in the Calculation column. Is there any suggestion from you?

Thank you.

Regards,

Screenshot_27.jpg

Screenshot_28.jpg

DeonLengton

Hi Adi

To force the type to Integer you need change the bind::esri::fieldType value of the question to esriFieldTypeInteger

By default most questions in Survey123 resolve to String types.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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