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

Survey123 Automation

MariusVerdes25

Hello. I need to make an automation inside the Survey123 form that will autocomplete some of the answers based on the answer from a question. I'm not so advanced in working with Survey123 and I need some help to make this happen.

Attached you can find the xls form from the survey.

What I am trying to achieve is: when I select "no" to question 7.1, the automation to select "no" to a couple more questions (1.1; 5.2; 6.4; 6.5.a; 6.5.b; 6.5.c; 6.5.d; 6.5.e; 6.5.f; 6.5.i; 7.16, 7.18). With the knowledge I have right now, I need to make a calculation for this.

Can someone please explain to me what exactly needs to be done to achieve this automation?

Thanks and regards.

ROToE.xlsx

cle444_7-1725249622198.png

Encuentra más publicaciones etiquetadas con

Accepted answers

Richard_Purkis

Hi @MariusVerdes25

If I understand your query correctly, you need to apply an IF statement in the calculation field to any respective question that follows 7.1.Use the following format:

if(selected(${Q7_1},'no'),'no',0)

Hope this helps

JA7

You need to match the capitalization of your no in the choice list, since the response would be 'No', your statement looking for 'no' would never evaluate to true. if(${Q7_1} = 'No', 'No', '')

All comments

Richard_Purkis

Hi @MariusVerdes25

If I understand your query correctly, you need to apply an IF statement in the calculation field to any respective question that follows 7.1.Use the following format:

if(selected(${Q7_1},'no'),'no',0)

Hope this helps

MariusVerdes25

Hi @Richard_Purkis,

Thank you for replying. I tried to use your suggested "if statement", but for some reason, I can't make it work.

To see if I understood correctly, after each question that I wanted to autocomplete with "no" based on the answer for question 7.1, I should insert the statement that you provided.

Here it's a screenshot from my xls form.

Many thanks

Richard_Purkis

Hi @MariusVerdes25

I've been unable to use the xlsx you provided. I can't find the choices tab.

Instead I have attached an extremely simple example where the second question will populate the answer of 'no' because the first question had an answer of 'no'

Hope this helps

Select_no.xlsx

MariusVerdes25

Hello @Richard_Purkis,

I tried your suggestion in my survey and it did not work. Here is a copy of my xls form, but I removed the sensitive information. I hope this is useful and that you can help me 🙂

Thanks.

ROToE.xlsx

JA7

You need to match the capitalization of your no in the choice list, since the response would be 'No', your statement looking for 'no' would never evaluate to true. if(${Q7_1} = 'No', 'No', '')

MariusVerdes25

Thank you @JenniferAcunto. It works perfectly now.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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