Google Sheets Integration: Name file and folders

We use this form for a daily report across multiple jobs. I would like to integrate the form with google sheets as some of the information is used for our project analysis calculations. I would need the sheet that each form information is logged on to be based on the job name selected. Currently as the daily submissions are sent to google drive I can base the folder name on the job selected can this also be done with sheets?

I am not quite clear on your concern.

Are you saying that you would like the folder your Google Spreadsheet file is saved in to have the same name as the Form? When setting up the Google Spreadsheet integration, you have the option to specify the name the folder the spreadsheet is saved in. You can also specify the name you would like the sheet to be saved as.



Is this what you are referring to? If not, please provide additional information so that we are better able to assist. We will await your response.


Cheers!