Need google sheets to restore back to original each day?
So, I am trying to create an hourly shift report for my employees to update as they work. I have created the template. I plan to have them update with the sheets app on their phones so as to save time on our side. What I need this sheet to do is to send me a copy with the report data and then at the end of the day, restore everything to the original template that I have created, but with a new date. If there is any way to pick a specific time that it could restore that would be great, as we often work until about 1am.
- MarvinatorLv 77 months ago
The simple answer is to make the form 'read only.' This means it cannot be saved over. They open the file, input data, save under a new name (example: user name+date, like DAVE07012019) and then they send it to you. Each time they open the original form, it is blank.
- Anonymous7 months ago
go to the history and yu can get it back