Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
Joey,
I have been in this situation before. One solution is to create a formula field to calculate the related parent, and if the checkbox was not checked then you will create the child, but deliberately make it an orphan. ie se Related Parent to zero.
Then from time to time say each month subscribe to a report of orphans and delete then.
or you can even fire a webhook to delete all orphans.
So always create the full set of children, but to the user, they will only see the ones which are properly connected to the Parent record.
I have been in this situation before. One solution is to create a formula field to calculate the related parent, and if the checkbox was not checked then you will create the child, but deliberately make it an orphan. ie se Related Parent to zero.
Then from time to time say each month subscribe to a report of orphans and delete then.
or you can even fire a webhook to delete all orphans.
So always create the full set of children, but to the user, they will only see the ones which are properly connected to the Parent record.