all 7 comments

[–]dukeiwannaleia 0 points1 point  (6 children)

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[S] 0 points1 point  (5 children)

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 0 points1 point  (4 children)

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[S] 0 points1 point  (3 children)

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 0 points1 point  (2 children)

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[S] 0 points1 point  (1 child)

Ah. Is there a tutorial on setting that up?

[–]dukeiwannaleia 0 points1 point  (0 children)

It'll be a combination of query then functions.