Waffle Bytes

Previously I have shared how to reset a form.  Thanks to a local principal (who happens to be my husband), I've learned there is another way to do this - and it will use the same spreadsheet you used originally, simply creating a new sheet for the new entries so you don't have MANY spreadsheets floating around with the data if you want to track it over time.  To reset the form, and continue using the same spreadsheet: In the form, click on RESPONSES, and click on the More menu (3 stacked dots) to select Unlink form -  When the warning comes up, click UNLINK - Go again to the More Menu, and this time select Delete all responses - When the warning comes up, click OK (remember, these responses were saved in the spreadsheet; you are only deleting them from the form itself) - Click on the More menu a third time, and select Select response destination - In the prompt window, select Select existing spreadsheet and then hit SELECT - Choose the spre...

Just put together this quick little script as we needed a folder created upon a form entry. In our case, we needed a folder created with the name of the person, so we are pulling the name entry from the form and setting that as the folder name.  This also includes how to direct it where to save these folders so they are sub-folders of an existing folder and not cluttering up the root level of your Drive. Thought I would share in case someone else needs something similar! 1. Create your form. You may want to enter 1 sample entry so you can test your script later.  2. Create the form responses spreadsheet. This will house the data from the form entries - you will be connecting the script to this sheet. 3. Open up the Script editor  Go to the Tools Menu and select Script editor. 4. Replace the code . Replace the default code - with this - (all the text highlighted in gray include the final bracket) - function createStudentFolder() {   // ide...