Copying the Children of a Parent only (Code Assistance needed)

The best approach is to scrap that code page.

There is an API for CopyMasterDetail.  https://help.quickbase.com/api-guide/understandreference.html

The User would select a Template Project which holds the correct child tasks and import them into the current record that the user is on.  There is no need to use a code page.

It's a simple URL formula field.  Give it a try and post back if you get stuck or contact me for some quick consulting help of about an hour.

The final formula will look something like this

var text Import = URLRoot() & "db/" & Dbid() & "?act=API_CopyMasterDetail"
& "&relfids=65" // relationship report link field to the correct child table
& "&destRID=" & [Record ID# of Template Project] // source of he children
& "&sourcerid=" & [Record ID#];  // destination of he copied children is the record we are sitting on.

var text DisplayProject = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID# of Template Project];


$Import
& "&rdr=" & URLEncode($DisplayProject);




------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------