Google Script - Create a Folder from Form Entry Data
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...