Override Record ID

Question

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
------------------------------

markshnier__you · Answer

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 · Answer

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 · Answer

That is the only way to fix it.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

evanmartinez · Answer

Hi Christine,You may have already started doing the Grid Edit method at this point but another option is to use the Find and replace in these records option on a tables List All report search for the old related record ID to replace it with the new one. It can help speed it up a bit compared to using the Grid Edit since they are bulk changing. You just want to make sure you use a report that captures all the right records.------------------------------Evan MartinezCommunity Marketing ManagerQuickbase------------------------------

christieanderso · Answer

Mark - Just FYI, the grid edit did not work for us.&nbsp; Because the record was a lookup field, grid edit does not work.&nbsp; Unless there is some permission that we can turn on for doing this?&nbsp;&nbsp;It wasn't too terrible of an ordeal, thankfully it was a new record and had very few orphan records!------------------------------Christie AndersonProactive Care Management AssociateAetnaNew Albany OH9592307059------------------------------

Forum Discussion

Override Record ID

7 Replies

Related Content

Button: save the new record and edit the new record

How to add list of attachments on child record from parent record

Get latest child record on parent record

Filter records based on table connection

WHAT HAPPENS AFTER A RECORD IS SAVED

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.