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?