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.
