Forum Discussion

ChristieAnderso's avatar
ChristieAnderso
Qrew Member
3 years ago

Override Record ID

A new supervisor deleted an employee from our roster, this is a parent table to multiple child tables for things like PTO requests, coaching reports, and employee self-evaluations.  Is there a way to create a formula that will override her new Record ID and replace it with her old one so that she can be reconnected to her existing child records?

Thanks!  
Christie Anderson, PMP

------------------------------
Christie Anderson
------------------------------

7 Replies

  • The old data still exists, it is just orphaned.  Just got to each table with Orphans and grid edit those records to link them back to the replacement employee record.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • ChristieAnderso's avatar
      ChristieAnderso
      Qrew Member
      Thanks Mark, that was my last ditch fix, we were hoping for a way to recover her old Record ID to avoid doing the grid edits.  :)

      ------------------------------
      Christie Anderson
      Proactive Care Management Associate
      Aetna
      New Albany OH
      9592307059
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        That is the only way to fix it.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------