Guide
Problem: you converted a relation between databases (from one-to-many to many-to-many)
Most likely that was a misclick or misunderstanding. You wanted to test something, and there is no unconvert button, and you are not happy with the result. Sorry for that 😥
Solution:
Here are the video and text guide:
https://www.loom.com/share/48dfd4ead41447f7be5c7b3d066d84d5
1. Navigate to the Audit log
There will be a tricky part.
Convert relation in the Audit log is presented as two separate actions.
Deleted relation (one-to-many, original one) - two records, one per database
New relation created (new many-to-many appeared) - two records, one per database, marked as "changed"
(somewhere between p.1 and p.2 there was a data migration, but you can't see it in the Audit log)
Can you see it?
Great, everything goes according to the plan
2. Delete the new relation and check the Audit log
This looks like a risky point, but it has to be done. You have to delete a newly created many-to-many relation.
Here is how the Audit log looks like now
3. Restore the very first relation
The one, that was marked as "deleted" after the conversion
Choose any of them and click on the Restore button
Tadaah
We have our relation back again!
If you have tons of data, each action may take from several seconds to several minutes, please, be patient and wait a bit
If that seems suspicious - please, create a testing Space and run the process to test it
We store daily backups and if there's an emergency - we will help you.