Combining Forms Responses/Results

%3CLINGO-SUB%20id%3D%22lingo-sub-266275%22%20slang%3D%22en-US%22%3ECombining%20Forms%20Responses%2FResults%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266275%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIs%20there%2C%20by%20chance%2C%20anyway%20that%20I%20can%20combine%20or%20pool%20results%20from%20different%20forms%20together%20to%20analyze%20the%20data%3F%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20example%2C%20if%20I%20were%20a%20teacher%20giving%20the%20same%20quiz%20to%20multiple%20classes%2C%20or%20one%20class%20per%20semester%2C%20but%20want%20to%20keep%20the%20forms%20separate%20for%20comparison%20sake%2C%20is%20there%20a%20way%20to%20combine%20the%20responses%20(perhaps%20in%20sharepoint)%20to%20analyze%20that%20data%3F%20Class%201%20and%20Class%202%20are%20taking%20the%20same%20form%2C%20but%20I%20want%20to%20individual%20results%20of%20both%2C%20as%20well%20as%20combined%20results%20to%20see%20how%20both%20classes%20did%2C%20as%20a%20whole.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-266275%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1113202%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20Forms%20Responses%2FResults%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1113202%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20not%20easy%20to%20find%20an%20solution%20to%20allow%20different%20people%20fill%20in%20same%20one%20Form.%20Maybe%20it's%20a%20work-around%20that%20Google%20Form%20allows%20people%20to%20edit%20the%20response%20in%20a%20submitted%20form.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116764%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20Forms%20Responses%2FResults%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F222101%22%20target%3D%22_blank%22%3E%40Caitlin%20Wagner%3C%2FA%3E%26nbsp%3Bprobably%20best%20to%20look%20to%20using%20Flow%2FPower%20Automate%20for%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edepending%20on%20if%20you%20know%20the%20identity%20of%20the%20user%20via%20login%20you%20can%20use%20the%20same%20form%20and%20then%20use%20a%20formula%20in%20the%20excel%20data%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20..%20i%20would%20just%20have%20the%20quiz%20have%20a%20select%20list%20at%20the%20top%20for%20the%20classes%20..%20let%20the%20user%20pick%20the%20class%20they%20are%20in%20..%20maybe%20even%20have%20a%20branch%20to%20have%20slightly%20different%20questions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Elastly%20..%20use%20shuffle%20questions%2Fanswers%20to%20randomize%20the%20order%20of%20questions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Is there, by chance, anyway that I can combine or pool results from different forms together to analyze the data?

For example, if I were a teacher giving the same quiz to multiple classes, or one class per semester, but want to keep the forms separate for comparison sake, is there a way to combine the responses (perhaps in sharepoint) to analyze that data? Class 1 and Class 2 are taking the same form, but I want to individual results of both, as well as combined results to see how both classes did, as a whole.

2 Replies

It's not easy to find an solution to allow different people fill in same one Form. Maybe it's a work-around that Google Form allows people to edit the response in a submitted form.

@Caitlin Wagner probably best to look to using Flow/Power Automate for this.

 

depending on if you know the identity of the user via login you can use the same form and then use a formula in the excel data file.

 

or .. i would just have the quiz have a select list at the top for the classes .. let the user pick the class they are in .. maybe even have a branch to have slightly different questions

 

lastly .. use shuffle questions/answers to randomize the order of questions.