Skip to main content
Question

Copy Master Detail records and then go to a PAGE and not to record?

  • December 7, 2016
  • 0 replies
  • 67 views
I have a button which creates tasks but when clicked I don't want it to go to the related project (which is standard) but instead to redirect to a Home Page.

Currently the button is thus:

"javascript:void(copyMasterDetailButtonHandler('&relfids=510&recurse=false&sourceRID=463&destrid=" & [Record ID#] & "', 'bjtdaeume'))"


How can I get it to redirect to MYPAGE

??
This topic has been closed for replies.

Mick,

There is help in the API guide but basically you need to convert this to an a formula URL using an the CopyMasterDetail API, and then you can do successive actions.  ie do the copy and then redirect to show the dashboard.

So it would be like 

var text URLONE = urlroot() & "db/" & [_DBID_of the Parent table] & "?act=API_CopyMasterDetail&recurse=false&sourceRID=463&relfids=510";

var text URLTwo = and here you need to hard code the main URL of the app.

var text URLTWO = "https://mycompany.quickbase.com/db/abcdefg;

$URLONE

& "&rdr=" & URLEncode($URLTWO)
  • MichaelGraham2
  • Author
  • Quickbase Alumni
  • December 7, 2016
Im getting the following when trying to save the formula url field?

The argument list of the function rdr must begin with a left parenthesis.

var text URLONE = urlroot() & "db/" & [_DBID_PROPERTIES] & "?act=API_CopyMasterDetail&recurse=false&sourceRID=463&relfids=510";

var text URLTWO = "https://xxxxx.quickbase.com/db/xxxxxxxxx?a=showpage&pageid=30;

$URLONE

& "&rdr=" & URLEncode($URLTWO)
  • MichaelGraham2
  • Author
  • Quickbase Alumni
  • December 7, 2016
ah, it needed a " after the 30

But now its asking for apptoken.  Ive created one but I dont think I have it in the right place...

var text URLONE = URLRoot() & "db/" & [_DBID_PROPERTIES] & "?act=API_CopyMasterDetail&recurse=false&sourceRID=463&relfids=510"&apptoken=apptoken;
var text URLONE = URLRoot() & "db/" & [_DBID_PROPERTIES] & "?act=API_CopyMasterDetail&recurse=false&sourceRID=463&relfids=510&apptoken=apptoken";
  • MichaelGraham2
  • Author
  • Quickbase Alumni
  • December 7, 2016
I had tried that as well but get this:

<qdbapi>
<action>API_CopyMasterDetail</action>
<errcode>2</errcode>
<errtext>Invalid input</errtext>
<errdetail>CopyFID required</errdetail>
</qdbapi
try this change

var text URLONE = URLRoot() & "db/" & [_DBID_PROPERTIES] & "?act=API_CopyMasterDetail&recurse=false&sourceRID=463&destrid=" & [Record ID#] & "&relfids=510&apptoken=apptoken";
  • MichaelGraham2
  • Author
  • Quickbase Alumni
  • December 14, 2016
Sorry Mark, I have been away...  just tested that and it works a real treat...  THANKS!
Great. Thx for letting me know.
  • GauravSharma3
  • Quickbase Alumni
  • March 27, 2017
Hi Mark,

While creating child records, I also want to set some defaults value with this API call. I tried but could not succeed.

Here is my formula:

URLRoot() & "db/" & Dbid() & "?a=API_CopyMasterDetail&sourceRID=1&destrid=" & [Record ID#] & "&relfids=684"
& "&_fid_76=" & "Not Required" 
& "&_fid_77=" & "Not Required" 
& "&_fid_78=" & "Not Required" 
& "&_fid_79=" & "Not Required" 
& "&_fid_80=" & "Not Required" 
& "&_fid_81=" & "Not Required" 
& "&_fid_82=" & "Not Required" 

& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])

Thanks,
Gaurav Sharma
You cannot change field values with the CopyMasterDetail  API.    Its also not obvious to get at the rid for the newly created record. 

What I do is to land the user on a report of recently created Parent records by the current user.  ie the records you just created.  I do that with an rdr after the copymasterdetail.

I then detect that the name field for the record now begins with "copy of", and show a button and a big red message asking the user to put the button.  The button then makes any field changes required.
Terms & ConditionsAccessibility statement