When you’re syncing tables, you can only create/edit/delete records from the source table, not the destination table.
When you’re syncing tables, you can only create/edit/delete records from the source table, not the destination table.
@ScottWorld , isn’t that a bit of an issue? You could never get rid of those records in the synced table when that record has been deleted from the source table?
@ScottWorld , isn’t that a bit of an issue? You could never get rid of those records in the synced table when that record has been deleted from the source table?
Airtable gives 2 options on what you’d like to do with the records in the destination table when they are deleted from the source table — you can either keep the records or delete the records:
Airtable gives 2 options on what you’d like to do with the records in the destination table when they are deleted from the source table — you can either keep the records or delete the records:
Understood, but if you keep them in the destination table and remove them from the source table, you can never delete them later in the destination table because those are synced records?
Understood, but if you keep them in the destination table and remove them from the source table, you can never delete them later in the destination table because those are synced records?
You can go into the sync settings (in the destination table) after-the-fact, and delete individual records or delete all records.
@Databaser Oh, I see that that’s what @Alan_Mclaverty was asking.
He wanted to delete records AFTER they were already deleted from the source table.
Yes, that is possible from the sync settings/configuration.
@Databaser Oh, I see that that’s what @Alan_Mclaverty was asking.
He wanted to delete records AFTER they were already deleted from the source table.
Yes, that is possible from the sync settings/configuration.
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 
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
Yes, that’s exactly what I just said in my 2 posts above. :man_shrugging:t2:
But yes, very cool that these options are available.
Yes, that’s exactly what I just said in my 2 posts above. :man_shrugging:t2:
But yes, very cool that these options are available.
LOL, my bad @ScottWorld, apologies! :smiling_face_with_halo:
LOL, my bad @ScottWorld, apologies! :smiling_face_with_halo:
@Databaser Lol, no worries! You actually did a much better job of explaining it than I did, because you included screenshots and a step-by-step walkthrough! My excuse is that I’m typing these replies from my iPhone. 
