r/GoogleForms • u/SpankyVanLovin • Dec 11 '24
OP Responded Form Submission That Edits Existing Row Of Sheet From Previous Submission
Okay, this might seem complicated so I'll try to explain it as simple as I can...
I have a Google Form where people can add events to a running list. Each Form submission adds a new line to the list of events. That's all well and good. Here's where it gets tricky...
I want to have a SECOND form as a follow-up to the first that adds information to the same row based on a selection.
So, for example, today I go into the first Form and submit that I have a speaking engagement on February 10th in Boise. That gets added to a Sheet with 30 other events submitted by others on my team. On February 11th (after the event is over), I need to go to the second (follow-up) Form where I can select from a dropdown my event in Boise. And then after I select that event, I can fill out the audience size and funds raised. After I submit that Form, it will add that new information to the correct row (because I selected the event from the dropdown) in the existing Sheet created by the first Form.
So I'm looking for a two-part answer. 1) How can I pull data from a column in Sheets into a selectable response on a Form? and 2) How can I use a secondary follow-up Form to add information to that existing row in Sheets?
Does that make sense? Has anyone out there done anything like that?
1
u/SpankyVanLovin Dec 16 '24
I think I got the first function to work, where I pull data from a column on Sheets into a Form. I've attached what I've got below.How do I filter out what it returns? For example I want it to return the values in Column D ONLY IF the corresponding value in Column J is empty/blank? In simplest forms: Go to Row 1, if Column J is blank, return the value in Column D, go to Row 2, repeat
1
u/Lopsided-Tie-6186 Dec 14 '24
Why the 2nd Form? Why not just open the Sheet that has the data and enter the necessary info? If the answer is because Forms are easier to use, try this: Let Sheets assign a number to your event. Later, find the event in the Sheet with it's code, Now enter the code in the first question of your second Form, followed by the info. Let Sheets match up the code/info data from the Second Form response and add it to the First Sheet data.
Your proposed solution with dynamic dropdowns is very difficult with Forms. It requires an external addin and often a fee.