I have set-up a sync.
In my original base, I have current customer data that I am working with.
In my synced table I want to have a historical record of the data for that customer. I have therefore set-up a sync so when the records are deleted or hidden in the source table I “leave the records in this table”.
Now everything works well. However in my synced table, I want to delete historical data after a certain period of time, but it doesn’t allow me to manually delete records I get the message “You can’t delete this record because this table is synced from an external source”
Does anyone have any suggestions/workarounds?
Ok, I did the exercise myself. @Alan_Mclaverty, if a record is deleted in the source base and you chose to keep the record in the destination base but later want to delete it, you can go to the sync config settings of the table in question, go to the “leave records when they are deleted or hidden in source” option, choose “change” and there you will see a “Delete unavailable records…” button. Click on that and it will give you a list of unavailable records, which you can select and delete.
It’s a nice solution, but i wouldn’t have known if it wasn’t for your question. A bit hidden I think :slightly_smiling_face: