topic Re: Calculations using Survey123 form in browser in ArcGIS Survey123 Questions

Calculations using Survey123 form in browser

TaylorRobin1 — Fri, 03 Aug 2018 16:03:24 GMT

When filling out a Survery123 form using a browser, my calculations from Survey123 Connect do not go through. On my mobile device and the desktop app they work. Is this know issue? Is there something I can do to get this to work on the browser?

Re: Calculations using Survey123 form in browser

Anonymous User — Mon, 06 Aug 2018 03:13:58 GMT

Hi Taylor,

Not all questions and calculations are supported in the web app that were created in Connect and supported in mobile app. Can you please provide an example of a calculation that is not working?

Alternatively, can you share your xlsx file with details of which questions and calculations are not working in the web app, so we can see if it is an issue or bug with web app, or they are not supposed to be supported at this stage.

Phil.

Re: Calculations using Survey123 form in browser

RobertMarros — Mon, 17 Sep 2018 17:28:45 GMT

Hi Phil,

I am currently experiencing a similar issue to what Taylor outlined above. When I complete a survey through the web browser, not all of my calculations occur like they do when completing the same survey using the Survey123 app on my mobile device/computer.

I am utilizing two external spreadsheets for my calculations and as you can see in the image below, my Risk Assessment score do NOT populate like it does on the mobile/desktop version of Survey123:

Web Version Mobile/Desktop

What I find interesting is that the Web Version is able to calculate some values though as you can see in the image below where the Risk Score for question 4 populates.

Thanks,

Steven

James Tedrick‌, Philip Wilson‌

#webapp survey123‌ #survey123web‌ #survey123calculations‌ #survey123

Re: Calculations using Survey123 form in browser

JamesTedrick — Mon, 17 Sep 2018 19:51:33 GMT

Can you share the XLS file? Given the NaN value for a score, one thing to check would be that value types are explicitly set in calculations, using the number() function.

Re: Calculations using Survey123 form in browser

RobertMarros — Mon, 17 Sep 2018 21:18:12 GMT

James,

Is it ok if I email it to you? I will send you my main XLS file, plus the two external ones.

Steven

Re: Calculations using Survey123 form in browser

JamesTedrick — Mon, 17 Sep 2018 21:59:36 GMT

Yes, e-mail is fine - jtedrick AT Esri.com

Re: Calculations using Survey123 form in browser

JamesWilson2 — Thu, 04 Oct 2018 02:36:07 GMT

I have the same problem, I am using Note fields to display an average of values. As String fields they show 'NaN' as Decimal fields they show blank:

Have attached my xlsx

Re: Calculations using Survey123 form in browser

RyanDeBruyn1 — Tue, 16 Oct 2018 01:13:58 GMT

HiJames Tedrick, I too am having issues with the calculations on the webform not calculating answers from previous questions, whereas the same survey using the Survey123 app on my mobile device/computer does work as expected. It would be nice to understand the requirements, my error, or if there is an issue?

As noted the Survey123 apps show the calculation (in my case the difference between two time fields, when a lift is reopened). The fields on the web form do not update as expected. For client reasons, I want to be able to rely on web version rather than the app so this is a bit of an issue.

I have tried to use the number() function and did not change to the output. For example,

int(number(${StartTime}) - number(${StopTime})) div (1000*60)

It is as if the webform is not dynamic?

Thoughts, appreciated.

Web form:

Re: Calculations using Survey123 form in browser

JamesTedrick — Tue, 16 Oct 2018 22:58:02 GMT

Hi James,

I'm not seeing the errors you are describing. Just to check, what version of Survey123 was this form published with?

Re: Calculations using Survey123 form in browser

JamesTedrick — Tue, 16 Oct 2018 22:59:53 GMT

Hi Ryan,

In the web form, time is treated as a text object. This will be addressed in the next version of Survey123 by introducing the decimal-time() function to convert time to a fractional day (i.e., 6:00 am = 0.25). From there mathematical operations can be done.

Re: Calculations using Survey123 form in browser

JamesWilson2 — Tue, 16 Oct 2018 23:31:20 GMT

GDay Mate, I published this in connect v3.0.142. To see the problem in action, try this link https://arcg.is/5qbHW

Re: Calculations using Survey123 form in browser

JamesTedrick — Tue, 16 Oct 2018 23:33:06 GMT

Loading your form, the fields are blank until all the values contributing to the equation have been filled in - this is to be expected, given the equations you have. Are you needing the average to occur when an incomplete form entry occurs? If so, you can use coalesce() functions to provide an alternate value when a question is unanswered

coalesce(int(${q}), 0)

Re: Calculations using Survey123 form in browser

RyanDeBruyn1 — Wed, 17 Oct 2018 15:17:48 GMT

Thank James, so specific to time calculation these are not supported in the web form ?

Based on your comments I can see what you mean now if I add a note field (graphic below).

Looking at samples and doc... it states this should be accomplished with decimal-date-time()? However it does not work in the web when tested. . So this statement is not true?

Decimal date time—Survey123 for ArcGIS | ArcGIS

https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis

Objective	Epoch time calculation	Decimal time calculation
Time spent for lunch in minutes	int(${LunchEnd} - ${LunchStart}) div (1000*60)	int((decimal-date-time(${lunchends}) - decimal-date-time(${lunchstarts})) * 24*60)

Re: Calculations using Survey123 form in browser

JamesTedrick — Wed, 17 Oct 2018 21:01:48 GMT

Hi Ryan,

In the web form in particular, there is a distinct difference between a datetime object and a time object; the decimal-time() function is needed to translate the time value (which is stored as a string) to a numeric value suitable for calculations.

Re: Calculations using Survey123 form in browser

JamesWilson2 — Tue, 23 Oct 2018 00:24:20 GMT

I don't think I understand coalasce. Doesn't it return the first non-empty value of two fields? I have eight fields, and want the running average of the ones that have been answered, as not all eight questions will be answered all the time. Both Survey123 Connect and Survey123 Mobile give me the running total, however the webform does not.

Re: Calculations using Survey123 form in browser

JamesTedrick — Tue, 23 Oct 2018 17:17:28 GMT

Hi James,

Coalesce returns the first non-empty value of the two inputs - an input can either be a question or a value. You can use it within your summing formula. I would not expect the calculations to run on the field app and connect; that would technically be a bug based on how calculations have been defined.

Re: Calculations using Survey123 form in browser

JamesWilson2 — Mon, 29 Oct 2018 03:42:24 GMT

Please don't fix that bug!

at least, not until functions exists that allow a running total. Looks like coalasce() wouldn't help as I have more than two inputs and never know how many would be populated (I had hopes for sum() and count() but they only work for repeats). In the mean time, I will push users to the mobile app.

Re: Calculations using Survey123 form in browser

JamesTedrick — Mon, 29 Oct 2018 06:19:21 GMT

Hi James,

To address the multiple values - coalesce(), like if(), can be nested to accommodate multiple conditions. In your form, it looked like you could have implemented it in the calculate questions to accomplish without nesting.

Re: Calculations using Survey123 form in browser

MichaelTorbett — Wed, 26 Jun 2019 22:53:26 GMT

Hey Guys,

I'm Having the same issue with certain fields not calculating in the web form of Survey 123. Everything is working fine when submitting a survey from my IOS Device. However on the web form the following fields are not calculating: 'PointsRxBurnManager', 'PointsCounty', 'Total_Points', and 'TieBreakerPoints.' I've attached my spreadsheet. If you see something that I'm doing wrong, please help!

Thanks,

Michael

Re: Calculations using Survey123 form in browser

Alber_Verster — Thu, 12 Sep 2019 03:15:49 GMT

Hi James,

I am getting the same problem. Survey form is concatenating two fields into a single field (all text) but getting the NaN in the browser. S123 Connect and app do not give the same issue. Any recommendations on how to fix/work around?

Thanks,

Albert