Forum Discussion

ChrisSipes's avatar
ChrisSipes
Qrew Cadet
2 years ago

copyMasterDetail but not all fields in sub records

Hi Quickbase community, I have a parent table and child table, where I want to duplicate the child records.  I would like to duplicate all of the child record fields, but change the value in one of...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

Unlike the More ... Copy this record button, the copymasterdetail wizard and URL API equivalent is documented to copy all fields, regardless of the field setting us set to copy.

Hence you will need to use a Pipeline to trigger once the children are created to reset some child fields.  The challenge will be how to identify the children to update as in your case you are adding children to an existing parent..



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------