BjornTheBlacksmith
Aug 22, 2024Copper Contributor
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!