This sounds like a possible bug to me as well, but unfortunately the vast majority of us here are fellow users, and can’t help to get the data back. I suggest contacting Airtable support directly to discuss this issue.
I think I am having this same issue. I have a Base with one table that is synced. I am then linking the synced table to another table within the Base. The linked field has cleared twice for no discernable reason and the record level revision history has nothing before the most recent Table Sync update.
I think I am having this same issue. I have a Base with one table that is synced. I am then linking the synced table to another table within the Base. The linked field has cleared twice for no discernable reason and the record level revision history has nothing before the most recent Table Sync update.
I figured out the source of this problem. It is only a particular view that is synced to another base. If that view changes in any way (hiding fields, adding filters, etc), that change is passed to the other base which breaks any links that are being made to that linked base.
The solution was to create a view in the source table that shows all rows and columns, and is kept locked to prevent any changes. That table is the one that is synced.