I have a table that I am using as a form for interviewing. At the end of the interview, I click an action button that sends the candidate an E-mail with a link to a Google Form that asks them their name, e-mail address, and 2 questions. When they hit submit, the answers go into a table in my sheet.
I would like to take the answers to the 2 questions and have them autofill 2 fields in the original form based on a match with the e-mail address from the candidate.
I have tried various expressions and references and have not had any luck.
Google Forms Response
Top part of form for interviewing
Fields to fill in form for interviewing
I have been working on this for over 2 weeks and would appreciate any help. Thank you in advance.