Skip to main content

I used the .CSV extension to upload a file into a base, but the data didn’t populate into the cells correctly. I’d like to restore the table to its original state without creating a completely new base from a snapshot.

My idea is to make a snapshot, then copy and paste the earlier version of the table back into the base. The field types match, and I’ve already removed any groupings, sortings, or filters.

Is there anything else I should watch out for before doing this? It seems like a quick fix, but I want to be sure I’m not overlooking something.

The only major “gotchas” are that any calculated fields will need to be copied one at a time (Formulas, Last Modified time, Rollups, Lookups, Etc.), and that Last Modified Time/By and Created Time/By fields will no longer have the correct values. Beyond that, you should be fine.

If the timing fields are important, create Date fields with time enabled to copy the current values to. You can always use a formula to evaluate those along with a new timing field (Created, Modified) to return the more recent of the two.

When copying linked record fields, so long as the names of the fields you are linking to are unique, you should just be able to convert the text field that will get copied over back to a Linked record field just fine.

Good luck!

Hey ​@mjpma,

In addition to the above, you could always create 2 copies of snapshots, test it first on a V1 to V3 for instance. See how it looks, see what challenges come up, and then once you are confident you can go V1 to V2 as a final version. 

Does that make sense?

Mike, Consultant @ Automatic Nation 

Terms & Conditions