Responses Based on Respondents selection and not based on choices IDs

[inboxgodwin]

Hi, please I need your help.

I designed a form but made mistake and didn’t differentiate the select one options with unique IDs. As a result, the responses only show one option for all the questions at the backend and when I download the responses into Excel.

Please, is there a way I could get the responses on the form based on what the respondents selected and not based on the choices IDs?

[Kal_Lam]

Welcome to the community, @inboxgodwin! Did you mean you wish to have your data with labels rather than values?

If I misunderstood your issue, feel free to share with us a screenshot of your issue so that we can understand your issue pictorially.

[inboxgodwin]

Hi @Kal_Lam

Thank you for the response.

Yes, I wish to have the data based on the labels of the options the respondents selected.

From the screenshot below, the responses only show one option for all the questions because of the choices IDs which was not differentiated.

[Kal_Lam]

@inboxgodwin, could you also share a screenshot of the XML value you have assigned for these responses?

Maybe this support article Exporting and Downloading Your Data should help you understand on how to download data with Label.

[inboxgodwin]

Hi @Kal_Lam , Thank you very much for your response.

I have attached the screenshot below to further explain the situation I am facing.

The second Screenshot is that of the XLM exported data.

The challenge I am having is that the data exported is showing only one response for all the questions which I think is because the choice IDs which were not differentiated in the form designed.

The since the survey is now closed, I wish I could get the data with labels based on the options the respondents selected across the different questions not based on the choice IDs of the questions which in this case were the same.

[Kal_Lam]

@inboxgodwin, checking if you made any bulk edits to your submission?

[inboxgodwin]

@Kal_Lam

No, bulk edits were made on the submissions.

[Kal_Lam]

@inboxgodwin, how many times have you updated and redeployed this project?

[inboxgodwin]

@Kal_Lam

I think around 3 times, I can’t remember exactly how many times the updates were done and redeployed.

[Kal_Lam]

@inboxgodwin, would you mind sharing with me the following information through a private message so that I could have a closer look at your case:

• Username
• Project name
• Server

Note: You could share with me a private message as outlined in the post discussed previously:

How do i send a private message to a user in the community forum?

Hi @Lavinia, You could send a private message to a user in the community forum as follows: Option 1: Sending a private message Step 1: Select the Reply button as boxed in red below. [Image 1] Step 2: Select the Reply button once again, but now from this place, as shown in the image below. [Image 2] Step 3: Now select New Message as shown in the image below. [Image 3] Option 2: Sending a private message to me Step 1: Click on my username Kal_Lam. Step 2: Then on the right, click the…

[Kal_Lam]

@inboxgodwin

I designed a form but made mistake and didn’t differentiate the select one options with unique IDs. As a result, the responses only show one option for all the questions at the backend and when I download the responses into Excel.

@inboxgodwin, could you kindly explain a bit so that we can reproduce this issue on our end (to troubleshoot your issue)?

[inboxgodwin]

Hi @Kal_Lam
Thank you so much for your attention and support so far.

Let me explain the issue to my best knowledge: We were having a test for our beneficiaries; we divided them into groups and gave them different survey forms.

I designed the first assessment form and duplicated it for the other assessment forms since they were having structure but different questions.

The screenshot of the Xlsx form is shown below: The options in the survey sheet were unique.

However, in the choices sheet shown below, the options were not unique, so I think the algorithm read the options as one for each question since they were not given unique names.

Now when I download the data, it shows just one option selected, meaning that all the respondents chose one answer for each question.

I wish to get the data based on all the labels the respondents selected for each question to enable me to know performance in test.

Please let me know if this is clear, alternatively we can jump on a call so I can explain it better.

Thank you.

[Kal_Lam]

@inboxgodwin

However, in the choices sheet shown below, the options were not unique, so I think the algorithm read the options as one for each question since they were not given unique names.

@inboxgodwin, wondering how were you able to upload the XLSForm with this choices sheet that has duplicates.

[inboxgodwin]

@Kal_Lam

I followed the same procedure in uploading Xlsx form and deployed it.
I didn’t get any error message while doing that. It was after the data collection that I noticed the issue with the duplicate choices.

[Kal_Lam]

@inboxgodwin, this post discussed previously should help you answer how a duplicate affects the project …

Choice duplicate

Hi @maggib, I found the duplicate that i have highlighted with yellow and marked the font with red within list_name lf3sx85 whose name prefer_not_to_answer is seen repeated twice within list_name lf3sx85. For your ease check row number 89 and 93 under choices tab. [Image 1] The principle behind this is that each list_name should have unique code under it’s associated name. e.g. this is not allowed … list_name name test a test a test a … but this is allowed … list_name na…

[inboxgodwin]

Hi @Kal_Lam

I have the followed the suggestion to address the duplicates as shown in the screenshot below:

But when I replace the xlsform and redeploy, the questions options come out blank. When I check individual responses, it doesn’t show that the options were selected. see the screenshot below:

Please how do I resolve this?