Forum Discussion
Caitlin Wagner
Oct 03, 2018Copper Contributor
Combining Forms Responses/Results
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 c...
CYappert
Jan 19, 2020Copper Contributor
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.