Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
25 days ago
Solved

Deleting Orphaned Children (records)

Hellos,

I have a scenario where I have a table where orphaned children exists , they can be recognised visually from hyperlink (See Screenshot).

The question is how to filter for them so they can be deleted in QuickBase . I can do this easily outside of QuickBase but how to do this natively ? 

 

  • The way I do this is I go to the parent record and make a checkbox formula field with the formula of TRUE and I name the field [Parent exists?]

    I then do a look up of that field down to the child records. If that look up field is false that means there is in fact, no parent.

2 Replies

  • The way I do this is I go to the parent record and make a checkbox formula field with the formula of TRUE and I name the field [Parent exists?]

    I then do a look up of that field down to the child records. If that look up field is false that means there is in fact, no parent.