Students take a weekly survey on Google Forms, and it is transferred to a Google Sheet. I want the Google Sheet to automatically generate a new tab based on the date (timestamp) so that each week has its own tab. Even better if we can make the timestamp simpler; I don't need the time, just the date.
For form responses received in a spreadsheet, you want to automatically generate a new tab based on the timestamp so that each week has its own tab.
To do this, it is first necessary to identify the week number. You haven't declared a preference for this, so we'll use the ISO week date where January 4 is always in week 1. We'll combine this with the methodology described in Copy submitted form data to new automatically generated Google sheet to append a copy of each response to the relevant sheet.
Create a "on Form Submit" trigger for the function. From the Scrip editor menu: "Edit" -> "current project's triggers".
- Function to run:
- Select event source:
- Select event type:
On form submit