Help - Does Restoring a Deleted Field Restore Data?

Need help Database
1

Made a stupid mistake and am trying to determine best course of action.

As I was making some updates to my database in Development I deleted a critical date field from a Thing. This field currently has important data in the Live version of the database.

Not realizing what I did, I noticed that I had a bunch of errors in my app and created a similar field and proceeded to fix all of the errors using the new field. After a few days I realized what did and restored the field in Development, but there is no data. I haven’t published my changes Live yet, so I’m wondering what the best thing to do is.

  1. Should I keep the restored date field in Development and put all of my conditions and workflow references back to the original field and then release to Live? If I do this, will my data in the Live database be maintained the date field, or will it be deleted?

  2. Should I just copy the data from the Live database and paste it into the new field, delete the original field, and leave all of my conditions and workflows they way they are?

#2 seems to be less work (just a copying of data from one field to another). But, just want to make sure I’m thinking this through before I make any further changes.

Thanks everyone!

1 Like
2

Hi

Go to DATA tab and select the Data Types section. And select the your table and right will show all the columns of your table. top of the table name have grey out text (“show deleted fields”), just click it, your removed items will show dashed under buttom of the columns. Just Restore it and deploy to live version. Your data on the deleted column will not be removed until you get optimize your application.

For your reference :

image
image760Ă—322 9.93 KB

3 Likes
3

Thanks. Everything came back as expected.

4

Thankyou very much…