/Remove-Names-From-Google-Forms-Uploads

A script to remove the uploader names that Google Forms adds to the end of uploaded files.

Primary LanguageJavaScriptMIT LicenseMIT

Remove-Names-From-Google-Forms-Uploads

A script to remove the uploader names that Google Forms adds to the end of uploaded files.

Create a new Google Spreadsheet and click on Extensions -> Apps Script

image

Paste the contents of RemoveNamesFromGoogleFormsUploads.js into the script.

You will need to replace the folderId with the folder you'd like the script to run on. You can get the folder id in the url to your google drive folder, its the stuff after /folders/ in the url. image

Return to the spreadsheet refresh the page, you will find a Rename Files Menu tab above. Clicking on it will show the runnable functions.

image

Click on any of the functions to run them. You will need to authorize the script on your first run, there will be a google popup for this.

  • Preview Rename Functions will go through the contents of the given folder and record what it would rename the files too onto the spreadsheet.

  • Rename Functions will do the same but actually rename the files.

    • ⚠ NOTE: Whether or not it was uploaded from Google Forms, THIS WILL RENAME ANY FILES IN THE FOLDER(S) THAT HAVE THE GOOGLE SEPARATOR PREFIX ( - )IN IT. Keep this in mind and make sure to use the Preview Rename functions before runnning Rename functions.

  • Both of these have a Recursively function which means it will also search through any sub folders of the given folder.

These are the headers for what the functions will produce, you may want to add these yourself. All results will go below!

image