MS forms responses from different users merged

%3CLINGO-SUB%20id%3D%22lingo-sub-1634023%22%20slang%3D%22en-US%22%3EMS%20forms%20responses%20from%20different%20users%20merged%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634023%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI'm%20new%20to%20MS%20Forms.%3C%2FP%3E%3CP%3EI've%20created%20a%20few%20forms%20with%20many%20questions%2C%20mainly%20Ratings.%20Since%20the%20reports%20can't%20give%20me%20the%20email%20address%20of%20the%20respondents%20(they%20show%20as%20anonymous)%2C%20I've%20added%20a%20mandatory%20question%20asking%20for%20the%20person's%20name.%20I've%20tested%20with%20a%20friend%20that%20sent%203%20times%20the%20same%20form%20with%203%20different%20question%2Fnames.%20When%20I%20downloaded%20the%20results%20in%20Excel%2C%20I%20got%203%20lines%2C%20clearly%20identified%2C%20with%20all%20questions%20and%20their%20answers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20went%20on%20and%20released%20the%20different%20forms.%20I%20sent%20an%20email%20with%20all%20the%20links%20to%20all%20responders.%3C%2FP%3E%3CP%3EI%20got%20the%20results%20from%203%20different%20persons%20and%20their%20answers%20were%20all%20merged%20into%20the%20same%20Excel%20line.%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20form's%20response%20screen%20%2C%20I%20see%203%20responses%20for%20the%20question%20name%20and%20only%201%20response%20for%20some%20other%20questions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20difference%20between%20the%20forms%20are%20the%20number%20of%20questions.%20It%20tested%20with%20a%20prototype%20form%20and%20it%20worked%20fine.%20Now%20that%20I've%20created%20all%20my%20forms%20(%207%20forms%20with%20%26gt%3B50%20questions)%20the%20solution%20of%20using%20a%20question%20to%20get%20the%20name%20doesn't%20seem%20to%20work%20at%20all.%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%20%3F%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20check%20from%20your%20side%20what's%20going%20on%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1634023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1636073%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20forms%20responses%20from%20different%20users%20merged%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1636073%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F781712%22%20target%3D%22_blank%22%3E%40jbourg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EToday%20the%20responses%20are%20working.%20When%20I%20open%20the%20responses%20in%20Excel%20the%20file%20name%20as%20a%20number%20between%20()%20that%20shows%20the%20number%20of%20respondents.%20ex%3A%20filename(1-4).xlsx%3C%2FP%3E%3CP%3EYesterday%20the%20same%20download%20gave%20a%20file%20%3A%20filename.xlsx%20which%20contained%20merged%20data%20from%20the%20different%20responders.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20exactly%20what%20I%20have%20done%20wrong%2C%20but%20as%20long%20as%20I%20can%20have%20good%20result%20files%20I'm%20OK.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I'm new to MS Forms.

I've created a few forms with many questions, mainly Ratings. Since the reports can't give me the email address of the respondents (they show as anonymous), I've added a mandatory question asking for the person's name. I've tested with a friend that sent 3 times the same form with 3 different question/names. When I downloaded the results in Excel, I got 3 lines, clearly identified, with all questions and their answers.

 

So I went on and released the different forms. I sent an email with all the links to all responders.

I got the results from 3 different persons and their answers were all merged into the same Excel line. 

On the form's response screen , I see 3 responses for the question name and only 1 response for some other questions.

 

The only difference between the forms are the number of questions. It tested with a prototype form and it worked fine. Now that I've created all my forms ( 7 forms with >50 questions) the solution of using a question to get the name doesn't seem to work at all.

What am I doing wrong ?

Is there a way to check from your side what's going on?

 

Thanks

1 Reply

@jbourg 

Hello,

Today the responses are working. When I open the responses in Excel the file name as a number between () that shows the number of respondents. ex: filename(1-4).xlsx

Yesterday the same download gave a file : filename.xlsx which contained merged data from the different responders.

 

I don't know exactly what I have done wrong, but as long as I can have good result files I'm OK.

 

thanks