How to recover the deleted record from the table?

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
Hello,

I have deleted a record from the table with record ID 114 and now trying to restore it but couldn't able to add the record with same ID 114, i tried to restore it through import option but it ends with error message of record ID, I hope the record it still available in database. 
Photo of Sameer

Sameer

  • 110 Points 100 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
You cannot revive a deleted record. In general [Record ID#] values should not have any significance.
Photo of Sameer

Sameer

  • 110 Points 100 badge 2x thumb
Do we have any possibility to add the record in place of missing [Record ID#] i noticed that Record ID is not modifiable, if we have any chance then please suggest  
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
I suppose you could create a new table and port over all your existing data including a manually reconstructed record for the deleted one. However, you have to do extra work to rebuild the relationships to the new table and delete the old table.

I think it is better advice to not rely on the significance of the [Record ID#] value.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Sameerr, if it is important to retain the 114 as an identifier if the record, you can enter a new record and have a field called identifier override.

Then use a formula such as

If ([Identifier override] > 0 , [Idenifier override], [Record ID#])

Then show that field in view mode on Forms and on Reports.