topic Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank in ArcGIS Survey123 Questions

Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

MatthewCarey — Tue, 08 May 2018 15:25:43 GMT

In Survey123 Connect (2.6.4) I'm struggling with getting the form to perform a calculation in a question only if I answer yes to an earlier question.

I have a select_one yes_no question ({samples}) which is "Did you take samples today?"

If the answer is yes, I would like it to generate a sample number (text, in the field sample_coll_no) which concatenates text that's already been entered by the user such as county code, target pest, and date. It has this in the calculation column: ${county}+"-"+${targetsci} ..... and so on.

So when, using the 'relevant' column, I make sample_coll_no relevant only when ${samples} = 'yes', or make the group that it's in relevant only when ${samples} = 'yes', it doesn't populate it in the form; there doesn't seem to be a triggering event that would make that happen.

If I make the 'relevant' column blank for the sample number question, it performs the calculation whether or not the "did you take samples" question is answered yes or no. And I don't want a sample number filled out when none was taken.

I'm not sure if it makes a difference but this survey is for filling in fields in a related table; the main point feature layer is trap locations and this related table is for the site visits; there will be multiple site visits for each site/trap.

Can anyone suggest a different approach to my problem? It seems like a somewhat standard thing that I'm trying to achieve but somehow I'm not getting there.

Thanks!

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

JamesTedrick — Tue, 08 May 2018 15:53:34 GMT

Hi Matthew,

It sounds like you are running up against a known issue with Survey123 - when a question with a calculation becomes relevant, the calculation is not being triggered. We plan to fix this; in the meantime this can be worked around by having the user click on the text box to 'visit' the question and then press the 'recalculate' button (two green arrows making a circle) once that appears to the right of the question.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

MatthewCarey — Tue, 08 May 2018 17:08:29 GMT

Hi James,

Thanks for the quick reply, much appreciated. Unfortunately in Survey123 on my iPhone I've been having trouble getting the 'recalculate' button to appear, I couldn't get it to work as you describe. The only time it would come up was when I'd added a second site visit and then erased it again, which did force the calculation in the sample_coll_no field to happen. Then when I erased a character from the end of the calculated string, the recalculate button appeared.

Other than that it's very reluctant to appear. Am I doing something non-standard, perhaps?

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

Anonymous User — Tue, 21 May 2019 21:51:32 GMT

Oh NO!! Any ETA on when this will be fixed? After struggling with this for a few days I was happy to see your answer, but very sad to see it is without a fix.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

JamesTedrick — Thu, 23 May 2019 20:10:53 GMT

Hi Pam,

This issue was addressed last summer (3.0 release). Are you still seeing this behavior? If so, can you share your form?

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

Anonymous User — Thu, 23 May 2019 20:41:06 GMT

Hi James,

I'm using Connect ver 3.1.126 and the iOS Survey123 app ver 3.3.64.

In the attached file I have a group of relevant clauses and if(selected....) statements. I found that if I removed the relevant clauses, the if-statements would calculate after I clicked each of the blue arrow circles next to the questions in the iOS app. The Status question only worked if the relevant clauses were gone as well. With the clauses present, a "D" would get entered correctly, but after uploading the survey to my online map, that point on the map simply disappears (the record exists in the database).

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

Anonymous User — Tue, 28 May 2019 20:30:07 GMT

Hi James - any news on this? Were you able to make sense of the form xls?

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

JamesTedrick — Tue, 28 May 2019 21:31:31 GMT

Hi Pam,

In your form, your questions that have a relevant statement to hide when 'Unimproved' is selected also have a calculation to set the value when 'Unimproved' is selected. When question is not relevant, it has a null value; if there is a value in the question already it is emptied out and cannot be set via calculation.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

Anonymous User — Tue, 28 May 2019 23:02:08 GMT

Thanks James - I still can't get the Status field to symbolize correctly in the online map if I leave all of those questions with a null value. The points with Status='D' and all the other questions null disappear off the map, but are visible in the table.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

Anonymous User — Wed, 29 May 2019 17:17:25 GMT

I still don't think this function really has been addressed in Survey123. If I allow a bunch of questions to remain null, the Status field doesn't work correctly, and if I leave out the calculations, I'm stuck with having to tap on all the arrow-circles to complete the survey.

So at this point I'm moving on with the clunky arrow-circle version (at least with that one the Status field works) and notifying my clients that we've run into another limitation of Survey123.

Thanks for trying to help, though.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

DougBrowning — Wed, 29 May 2019 19:06:01 GMT

I see some commas in your Label field. This can mess up your lists and may be your issue. Remove all commas.

I also would try if(string-length(${StructureType})!='','D', 'I') instead.

Why do you use !=D here but then use selected() everywhere else? Just use if(${StructureType = '3'), 1, 0)

For your calcs I have had much better luck doing this

if(${StructureType = '3'), 1, 0) and then set the bind field (NOT esri bind) to int.

Then get right of all the int() in your score calc. I have found this does not work.

It could be that the '' is breaking your Score and causing issues.

Wait I see now that all of those are list choices. Hmm does score actually work? You may need a second field for that.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

JasonJordan00 — Thu, 18 Jul 2019 03:19:04 GMT

Hi James, I'm using 3.5 and I'm still seeing this behavior. I have a hidden field and if it becomes relevant, I want it to return one of two values, otherwise leave the original data in the field (since we heavily open past surveys up in the Inbox).

I can't share my form but I'll show the relevant and calculation columns.

Relevant Calculation

${tflOnsiteStatus}!=''

if(${tflOnsiteStatus}='No Issue','No Issue','Unresolved')

No matter what, it always returns "Unresolved", even if tflOnsiteStatus is blank. I have tried several different relevant expressions to see if any worked.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

DougBrowning — Thu, 18 Jul 2019 13:46:56 GMT

Often when people have this issue they are checking the label value and not the Name value. Since you have a space in there I wonder of that is it.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

JasonJordan00 — Thu, 18 Jul 2019 14:06:32 GMT

Thanks for the suggestion but I should have clarified. The label and name values are the same. The calculation itself works. The problem is is just runs regardless if its supposed to be relevant or not.

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

JamesTedrick — Wed, 07 Aug 2019 19:34:57 GMT

Hi Jason,

Based on your description, I would expect it to return 'Unresolved' if tflOnsiteStatus is blank. The built-in if() function cannot preserve an existing value (i.e., 'replace this only if this condition').

Re: Survey123 Connect: If question A is answered "yes", populate Question B with a calculation; otherwise leave it blank

MichaelDepow — Tue, 18 Apr 2023 16:34:15 GMT

Hey James I have question for you if you have the time. I have a select_one question called select_one normalCircum and I also have that in my name column normalCircum

In my choices tab I have normalCircum and 2 options for it Yes and No. What I want to happen is when you select No a text bar appears to allow you to explain why. Do you know how I can do this? I've attached some pictures to help hopefully