Discussions

 View Only
  • 1.  Find records that were deleted today

    Posted 04-29-2019 21:37
    Is there a way to find out what records were deleted for a given day?  In my case, today.  Thx, Mark


  • 2.  RE: Find records that were deleted today

    Posted 04-29-2019 21:44
    If not, is there a way to specifically find which records are now "not in the table" when you get an error message saying "Some record IDs specified were not found in the table" when trying to import?  My file has 400+ records and there's probably ONE that was deleted while this file was saved as a spreadsheet, modified, and then attempted to import it.  There must be a way to identify which record is missing....


  • 3.  RE: Find records that were deleted today

    Posted 04-29-2019 22:38
    Deleted records can only be restored by QuickBase support. But if you have the missing record in a spreadsheet, you can import it from there. All existing records will be updated and the missing record will be inserted. But if you specifically want to identify that single record in the XL that is missing in QuickBase application,  you can import that XL file into another table, let's call it the "backup" table. Then make the backup table the parent to the actual table, where the primary key in the original table is now the reference field in this relationship. Now introduce a new checkbox field "Present" in the backup table such that it is a formula checkbox field equal to True. Then pull that field as a lookup into the original table. Now you can find the missing record in the original table by looking for the record where "Present" is false. This is because all records that match will have say "True" for the lookup field in the original table, except for the missing one.

    Hope this helps.