Madi asked in Computers & InternetSoftware · 7 months ago

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.

2 Answers

  • 7 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.

    • Login to reply the answers
  • Anonymous
    7 months ago

    go to the history and yu can get it back

    • Login to reply the answers
Still have questions? Get your answers by asking now.