Deleting Multiple records by record ID
I have a list of 5,600 records that need to be deleted. The list I have is in excel showing all the record ID numbers. What's the quickest way for me to delete this in QuickBase? ----------------...
Forum Discussion
In a similar vein to Mark's suggestion, you could:
------------------------------
Jeremy Anson
------------------------------
- Add a new field to your QB table named 'OK to delete'
- Add a column 'OK to delete' to your spreadsheet which you fill with 'Yes' in every one of the 5,600 rows
- Import the record ID# and 'OK to delete' columns back into your table, merging on record ID#
- Create a report in QB that selects records where 'OK to delete' is 'Yes'
- Delete all records selected by your report using the 'Delete these records' feature
------------------------------
Jeremy Anson
------------------------------
- MarkShnier__You
Qrew Legend
Yes, actually the solution posted by Jeremy is a bit more simple than mine.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank you!
It was very helpful!
------------------------------
Miriam Klugman
------------------------------
