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?
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.
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.