True" this is using Apps Script to add form response items back into the form. - So, I already have my form set up. Let's go ahead and look at the preview. That's going to be easier to see what we're doing. - Basically, I have a group activity brainstorming sheet/form. I want users to come in, put in their name, select all the activities they're interested in doing. - And, because I don't want to constrain them to just these two, I also want them to be able to add additional options here. But, I want these options to come back up here for all future users. - Basically, User A comes in, selects yeah, they want to do basketball but they're also interested in tennis. When they hit submit and User B comes in, I want User B to have tennis as one of their options here. That's what I'm trying to do. - There's no default way to do that, so we're going to use Apps Script to break that open. - I already have my sheet and it's already linked up. You can see it's linked here. So, let's open up our script editor. This is from Tools Script Editor. - Now, I'm doing an on form submit trigger. Unfortunately, there isn't something just called on form submit. We've used something like that before where we could just do on edit. But, on this, I can't do that. - Let's just see what happens. Logger.log(e.values). Okay, and if I put something in submit it then over here. Alright, it came in. But, if I come back to the project, there's no executions. - Okay, so I'm going to have to set up an installed trigger to actually run this. - Let's go ahead and start that....
Award-winning PDF software
Video instructions and help with filling out and completing Dd 1750
