Forum Discussion
ArchiveUser
7 years agoQrew Captain
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.
Hope this helps.