Rename files in Google Drive that have been collected through Google Forms

Question

I am collecting Friends photos through a Google Form. The Form has only two fields Name (text) and Photo (upload).

The uploaded photo is stored in a folder in Google Drive and a hyperlink appears in the Google sheet to the name.

The issue I am facing is that the photo stored in Google Drive usually has a name generated while taking the photo and is not the name of the person whose photo it is. I want the photo file name to be the same as the person's name.

I don't know much of Google Scripts and would like help in using a script to rename the files in the Google Drive with the name of the uploader which is in the Google Sheet.

question from:https://stackoverflow.com/questions/66057425/rename-files-in-google-drive-that-have-been-collected-through-google-forms

Answer 1

Waitting for answers