Select to view content in your preferred language

Show result if all answers are 'no'

539
5
Jump to solution
11-13-2023 01:39 PM
Jennifer_Parmeley
Occasional Contributor

I have a survey that we are using as an interactive document, it will not collect or store data. (I'm not sure if this is relevant, I'm just hiding the submit button.)

There are 3 options for each question; yes, no, maybe
If every answer is 'no' I want to display a message
If there is one 'yes' or one 'maybe' answer to any of the questions I need to display a different message

I would like all of the questions to show at one time. 

I have this working exactly how I want it to in our testing portal, using a feature service from our SQL database, and Survey123 Connect.
I cannot get it working in our preferred production portal; which is an AGOL account and a hosted feature service/Survey123 web.

In AGOL I've got it working one question at a time, but it stops progressing as soon as a yes or maybe is chosen, I can make it progress on 'no' through all the questions.
> if yes show "true note" and if maybe show "true note"; If no show next question
 
OR I can get all the questions to show by removing the show next question option, but if there are 'yes/maybe' and 'no' answers it shows both messages (which are contrary and will only be confusing to the public user).


The document this is based on is not public yet, so I cannot share a live link to the survey here. 

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Esteemed Contributor

If you publish the web form from connect it should work.

View solution in original post

5 Replies
DougBrowning
MVP Esteemed Contributor

You should be able to just make a note field with a relevant of  q1 = 'no' and q2 = 'no', etc.

For the others same deal just some of them are yes q1 = 'no' and q2 = 'yes' etc

I think that is what you are asking.  In the 123 sheet it just has a yes drop down for relevant but you can put any true/false statement in there and it will work.  My guess is that is what is tripping you up.

Hope that helps

Jennifer_Parmeley
Occasional Contributor

I have it working in Survey123 Connect. 

I need it to work in the web-based Survey123, if possible.

 

0 Kudos
DougBrowning
MVP Esteemed Contributor

If you publish the web form from connect it should work.

Jennifer_Parmeley
Occasional Contributor

I had tried publishing my xls form to AGOL when I originally made this post, but it didn't work. I tried again yesterday and I had it up in a few minutes. I have no idea what the original issue was, but pushing my correct xls form to our AGOL resolved the issue. 

JenniferAcunto
Esri Regular Contributor

The web form is much less forgiving than Connect. If something works in Connect, but not the web form it usually means you have a syntax issue. I would recommend double checking your syntax or attaching your XLS to this post. 

- Jen