0

I have a Google form that is collecting the Event date, event name, employee name, and his/her assistance in that event(Yes/No). After collecting those answers, we want to use the data to create another Google form using the Event date, event name, and employee name and add other questions. The key point here is to take all employees that answered Yes from the first Google form only and avoid entry of the data from the first form within the second form manually. Each form will manage by two different end users. Is there a way to accomplish it?

2
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Jun 11, 2023 at 14:33
  • Welcome to Web Applications! Please edit your question to include an example/mockup of each of the spreadsheets including some sample data. Identify in the first the columns that will be included in the second, and in the second the columns that are pulled from the first. You only need a few row of sample data, but please include the examples as markdown tables and/or images so everything needed to understand the problem is included in the question.
    – Blindspots
    Jun 11, 2023 at 14:36

1 Answer 1

0

In the destination spreadsheet of the first form, use a formula or a script to generate edit response URLs that point to the second form and contain pre-filled answers that will be automatically included when the second form is opened through that URL.

Note that edit response URLs contain IDs of form fields, and those IDs vary between forms. You will have to replace field IDs in the edit response URL with the IDs of the second form.

Use filter() to get the email addresses and edit response URLs of the users who answered Yes, and use a mail merge add-on to email those URLs to those users, asking them to open the second form through the URL they received.

See Assign Edit URL for sample code.

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.