PaulStreit
5 years agoQrew Member
Copying parent and children down multiple levels
I have a complex application where I was using the Quickbase Copy Master and Detail Records routine to generate a "Copy Record" button that recursively copies a parent record and multiple levels of children. It worked great until I added a table with a custom primary key instead of Record ID#. This broke the copy function because it only works with table primary keys that are the built-in Record ID# (I verified this in the help file). I tried recreating the button and selecting different settings to exclude the offending relationship, but it's multiple levels down from the parent table and there's no option to exclude relationships except at the first level below the parent.
What I need is a copy button just like the Quickbase Copy Master and Detail Records routine generates, but I need to exclude a one relationship two child levels down. I don't think this will work with the Quickbase routine, so is there another way, perhaps with automations or pipelines?
I have a parent table that connects to two child tables. One of the child tables then connects to six grandchild tables. It's one of the grandchild tables that I want to exclude.
Thank you,
Paul Streit
------------------------------
Paul Streit
------------------------------
What I need is a copy button just like the Quickbase Copy Master and Detail Records routine generates, but I need to exclude a one relationship two child levels down. I don't think this will work with the Quickbase routine, so is there another way, perhaps with automations or pipelines?
I have a parent table that connects to two child tables. One of the child tables then connects to six grandchild tables. It's one of the grandchild tables that I want to exclude.
Thank you,
Paul Streit
------------------------------
Paul Streit
------------------------------