Skip to main content
Question

Deleting Multiple records by record ID

  • August 8, 2021
  • 0 replies
  • 122 views
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?

------------------------------
Miriam Klugman
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
No problem. Create a new table called records to be deleted. Set the key feel to be the record ID of the records to be deleted.
Make a field on this table called OK to delete which is a formula checkbox with a formula of true.

Make a relationship where one record to be deleted as many records based in the record I'd of the records table. 

Look up that field that will tell you whether it's OK to delete the record.



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+7
  • JeremyAnson
  • Registered
  • August 8, 2021
In a similar vein to Mark's suggestion, you could:

  • 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
------------------------------
Terms & ConditionsAccessibility statement