@JPP_DATABASE The scenario that I described above was purely theoretical. I never built such a setup myself. The concept would probably still work using Zapier or Make (formerly Integromat), but if I were to do something similar today, I would probably build it directly in Airtable using synced tables.
In the primary base, create a view in the desired table that can be synced to another base. I’ll refer to this as the source sync. Make sure that this view has every field visible. It’s also vital that the view has no filters on it, or the setup won’t work.
In another base—I’ll call this the “tracker” base because it’ll be used to track when records are deleted from the primary base—add a table that syncs from the desired table and view in the primary base. I’ll call this the destination sync. When setting up the sync configuration, the default option for dealing with deleted or hidden records from the source is to delete them from the synced table. Change this to leave these records in the table.
In the destination sync table, add a button field, and choose “Open source record” as the action. Next add a {Source URL} formula field, with the name of the button field as the only contents in the formula. This will display the URL pointing to the original record for each of the synced records. However, when a record is deleted from the source table, this URL will disappear.
With this in mind, create a “Deleted records” view in this destination sync table, with a filter that only shows records with an empty {Source URL} field. You can now use this view in an automation using the “When record enters a view” trigger, sending an email or doing any other action that you wish when a record is deleted from the source table.
Because all of the original data is still in the synced record you’ll know exactly which record was deleted, and you’ll have a copy of the original data if you need to restore it. Unfortunately there’s no way to track who deleted the record, but you’ll know the approximate time that the record was deleted (depending on your sync frequency).
