+11Hellos,
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 ?
Best answer by MarkShnierYou
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.
+24The 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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
