# WARNING: Don’t restore your google sheets to earlier time

**URL:** <https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782>\
**Category:** Ask for Help\
**Created:** [December 11, 2019, 6:53am UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782 "2019-12-11T06:53:12Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [December 11, 2019, 6:53am UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/1 "2019-12-11T06:53:12Z")

</div>

I restored my google sheets to an earlier time and it complete wiped some key elements of my app. Relations, Look Up Values etc and as well as calculated columns etc…Hours/Days effort ALL GONE - argh

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [December 11, 2019, 7:02am UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/2 "2019-12-11T07:02:29Z")

</div>

That’s probably this issue:

> [@Elements and relationships disapearing](https://community.glideapps.com/t/elements-and-relationships-disapearing/2770):
>
> Some relationships, lookups and conditionals are disappearing. I’ve redone them. But it’s something you should look at.

We’ll fix it soon. Sorry.

---

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [December 11, 2019, 9:37am UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/3 "2019-12-11T09:37:02Z")

</div>

@Mark So would everything go back to it’s previous state or would I have to rebuild all over again when it’s fixed?

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [December 11, 2019, 5:59pm UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/4 "2019-12-11T17:59:53Z")

</div>

Unfortunately it won’t go back, you’ll have to rebuild.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [December 11, 2019, 6:40pm UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/5 "2019-12-11T18:40:58Z")

</div>

Another example of the importance of periodic app backups. At least once a week I duplicate my apps. I select to use existing spreadsheet and then after the clone app is completed I change the name appending a date to the front. Then I open the spreadsheet and make a copy of that, appending the date to the copy as well. If I have a disaster with the original app before I open the backup I make sure to restore the spreadsheet to the state it was in when I backed it up, by copying the various tabs back to the original. Maintaining the original spreadsheet is critical for me as I have multiple apps pointing to the same sheet.

---

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [December 11, 2019, 8:49pm UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/6 "2019-12-11T20:49:44Z")

</div>

😕 is the issue now fixed on the backend?

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [December 11, 2019, 8:55pm UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/7 "2019-12-11T20:55:51Z")

</div>

Sorry, no, this won’t happen until a week or two from now.

---

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [December 11, 2019, 9:10pm UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/8 "2019-12-11T21:10:45Z")

</div>

So what triggers this issue? What should we or shouldn’t be doing so that it won’t happen again?

I’m just concerned that if I rebuild all over again in readiness for a customer presentation (which I’ve had to reschedule due to this) it may happen again.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 11, 2019, 9:19pm UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/9 "2019-12-11T21:19:43Z")

</div>

I’d suggest not restoring an old version of your sheet it you know that the layout had changed. I’d suggest making regular backups of the entire sheet instead and only restoring data via copy paste. I run a script on a trigger to create a backup weekly off my entire sheet. There’s just too many unknowns using Google’s restore feature.

> [@Backup My Data In My Spreadsheet](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/2):
>
> First of all, google does keep a history of any changes. You can access them by clicking the link at the top of the sheet: I also use this script to backup my sheet every week. The only thing that needs to change in the script is the destination folder. This gives me a weekly backup with a timestamp attached to the name: // Abhijeet Chopra // 26 February 2016 // Google Apps Script to make copies of Google Sheet in specified destination folder function makeCopy() { // generates…

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [December 12, 2019, 6:48am UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/10 "2019-12-12T06:48:30Z")

</div>

Don’t rename or delete columns that you’re using in the app. And don’t delete sheets you’re using in the app.

Apologies again. Like I said, Glide will soon be able to handle column renames without disturbing your app.

If you do temporarily put your spreadsheet into a bad state, don’t click “Reload sheet” in Glide until the spreadsheet is back in order.

---

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [December 12, 2019, 9:21pm UTC](https://community.glideapps.com/t/warning-don-t-restore-your-google-sheets-to-earlier-time/2782/11 "2019-12-12T21:21:25Z")

</div>

thanks this is what I wanted to know in order to avoid it from happening again.
