Deleting records by record id
I am updating my tables for the last time but I have noticed I have around 65 records which should not be there. What is the quickest way to delete this. I do have their record ID. There is no othe...
Forum Discussion
So not sure if this is relevant but I found this thread when wanting to delete a list of record ids.
I have table structure of opportunities -> Facilities -> Asssets.
I had a list of assets that I wanted to delete from an opportunity but not all assets associated with that opportunity (567 of them). I tried this method and it was to tedious in excel to write the formula with all the record id's to find them. What I did instead was move all the facilities that had the assets I wanted into a new opportunity. Then deleted all the assets associated with the original opportunity. Then I can move all the facilities with assets I want back into the original opportunity. I know this is not exactly what this thread is about. But think of it like figuring out a way to be able to create a filter for the records you want to delete. I did this by moving all the records to be associated with another parent table record and then deleting. So taking the list excel list of record IDs, running an update, then a report and grid edit to delete. Hope this helps.
I have table structure of opportunities -> Facilities -> Asssets.
I had a list of assets that I wanted to delete from an opportunity but not all assets associated with that opportunity (567 of them). I tried this method and it was to tedious in excel to write the formula with all the record id's to find them. What I did instead was move all the facilities that had the assets I wanted into a new opportunity. Then deleted all the assets associated with the original opportunity. Then I can move all the facilities with assets I want back into the original opportunity. I know this is not exactly what this thread is about. But think of it like figuring out a way to be able to create a filter for the records you want to delete. I did this by moving all the records to be associated with another parent table record and then deleting. So taking the list excel list of record IDs, running an update, then a report and grid edit to delete. Hope this helps.
