Forum Discussion

TrishWehrle's avatar
TrishWehrle
Qrew Cadet
7 years ago

Modify the add child record button to also change a field on the child record

I have a table of audit findings and I'm  creating a child table of workflow records. I'd like a formula url button on the audit finding for each action of the workflow process, ie, Send to Response O...
APIs and custom code
App builders
JacobLinn1's avatar
JacobLinn1
Qrew Cadet
6 years ago
This is awesome. Very helpful. One piece I am having trouble with is the redirect...

"&z=" & Rurl() // And when I save this form, redirect me back the page I'm on right now.

How would I modify this to instead save and send to a different page? Right now I have the button I would like to use on a dashboard.

------------------------------
Jacob Linn
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You can make a button like this to add a record and then land the user somewhere designated. 

var text URLONE = ..............; (the API_AddRecord)
var text URLTWO = ..............;

$URLONE
& "&NextURL=" & $URLTWO




------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • JacobLinn1's avatar
    JacobLinn1
    Qrew Cadet
    6 years ago
    Here is my formula:

    var text URLONE = URLRoot() & 
    "db/" & [_DBID_RESERVATIONS] & 
    "?a=API_GenAddRecordForm" & 
    "&_fid_6=" &
    URLEncode([Record ID#]) & 
    "&_fid_14=" & 
    URLEncode(User()) & 
    "&z=" & Rurl()

    ;

    var text URLTWO = "My URL for the dashboard";

    $URLONE
    & "&NextURL=" & $URLTWO


    ----------

    It doesnt look like anything has changed? I'm still left at the record in edit mode instead of the record saving and taking me to my URLTWO URL.

    ??

    ------------------------------
    Jacob Linn
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      They this change to URLONE

      var text URLONE = URLRoot() & 
      "db/" & [_DBID_RESERVATIONS] & 
      "?a=API_GenAddRecordForm" & 
      "&_fid_6=" &
      URLEncode([Record ID#]) & 
      "&_fid_14=" & 
      URLEncode(User());


      ie drop drop off the last part.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------
      • JacobLinn1's avatar
        JacobLinn1
        Qrew Cadet
        6 years ago
        Something isnt working properly :(

        Still no save and no redirect. Button creates the child record and fills in the fields I'm telling it to but I'm looking at the record in edit mode.

        ------------------------------
        Jacob Linn
        ------------------------------