Generating pre-filled forms links from Excel data
Hi!
I’m trying to automate some tasks at the school I work at: every year we collect some data from the new students using MS Forms and now we’d like to send a secondary form to the students that tick a certain box in that form. Is there a way to automatically generate a unique form link for each student that tick that box, send it to the e-mail they supply and have the response to that form tied to their supplied e-mail? Or have the new form have the student’s name pre-filled?
I know I can do a branching structure in the first form, but we’d really like to separate the questions to different forms if we can.
Thank you!
Hi!I’m trying to automate some tasks at the school I work at: every year we collect some data from the new students using MS Forms and now we’d like to send a secondary form to the students that tick a certain box in that form. Is there a way to automatically generate a unique form link for each student that tick that box, send it to the e-mail they supply and have the response to that form tied to their supplied e-mail? Or have the new form have the student’s name pre-filled? I know I can do a branching structure in the first form, but we’d really like to separate the questions to different forms if we can. Thank you! Read More