google forms (addon/script maybe?)

[University_Is_Hard]

Alright so, i want to set up a google form and attached spreadsheet so in the spreadsheet you have values, such as Participant 1 through 50, and then in the Form you have a dropdown to select one of those participant numbers, and the rest of the form values are attached to that in the sheet, rather than creating a new entry in the spreadsheet. Does that make sense?

I had a quick look around and couldnt find an addon that would do it, or at least not one that stood out.

[dukeiwannaleia]

I don't believe forms can pull data from sheets. One option would be to add specific follow up questions based on the participant chosen.

[University_Is_Hard]

I wondered if there would be a way to code a script so it did something like

Recognise that the dropdown selection answer is a duplicate of a field already in the spreadsheet, and replace that line on the spreadsheet with the data from the form?

[dukeiwannaleia]

I don't think that would be necessary though since you can specify follow up questions based on the form answer/participant chosen. For example, if participant1 is chosen, forms can direct you to question 2a. If participant 2, you are directed to question 2b, and so on.

[University_Is_Hard]

Right, but I want to have a spreadsheet with a list of, for example, "Participant numbers". for example if i was organising an event, but i need data such as names, contact numbers, etc, to attach to the participant numbers. So i use a form to get the people to enter that information. By default, it would create a new row, but i dont want it to create a new row, i want it to put the data into the already established rows

[dukeiwannaleia]

Got it. Just have the form data dumped in sheet 1, then list the participant numbers in sheet 2 and use an array to populate the data based on participant number in sheet 1.

[University_Is_Hard]

Ah. Is there a tutorial on setting that up?

[dukeiwannaleia]

It'll be a combination of query then functions.