I am using google forms to survey the same patient each month.

Is there a way for me to create a different link to the patient's previous survey (and maintaining his/her answers) or to quickly copy and paste his/her answers into a different survey (to obtain a different link to the previous google forms survey, that I can paste and save?).

This would save me a lot of time lost filling out a new survey with the patient's past answers, every month that I have to contact the patient.


1 Answer 1


Use a prefilled link. To automatically create prefilled links, use a formula in the form response destination spreadsheet to insert the data in a patient's existing response into a link template.

To get a link template, follow the instructions in the help page. Use the text string concatenation operator & or functions like substitute() and regexreplace() to implement the formula.

  • Thanks so much Ruben! Do you know if it is possible to obtain different links instead of a single link out of a prefilled form, so I can use a different link each month? Feb 21, 2023 at 8:08
  • 1
    In the form response destination spreadsheet, use a formula to insert the data in a patient's existing response into a link template. If you cannot write a formula to do that, post a new question and show what the form response destination sheet look like. Feb 21, 2023 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.