Forum Discussion

PaulStreit's avatar
PaulStreit
Qrew Member
5 years ago

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 ch...
Relationships
Tables and fields
Wizards and add-ons
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
You should be able to accomplish this with Pipelines, you'll just need a button that toggles some trigger field to start the process. Alternatively, you could have the button start the process by copying the Parent and give the user another button to import the child records, using the Table to Table import process. Neither is 100% ideal, but they're both reliable.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
  • PaulStreit's avatar
    PaulStreit
    Qrew Member
    5 years ago
    Thank you! After thinking about this some more, I solved the problem a different way by slightly restructuring my app. I was able to bring the offending tables up one level in the hierarchy, which allowed me to exclude them from the copy operation through the Quick Base built-in routine. But your suggestions are good, and I will keep them in mind for the future.

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      I figured my suggestions of high costs would motivate you to find Plan B.  Good for you for finding one.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------