Forum Discussion

DenisRochat's avatar
DenisRochat
Qrew Trainee
5 years ago

How Do I Save a Form and Open a New Form From Related Table With One Button Click

I am really bad at trying to program. After searching around I tried this. It does not Save the form but it opens the related form (without the related field because it did not save.

var Text URLONE = URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?a=API_GenAddRecordForm&_fid_261=" & URLEncode ([Record ID#])& "&z=" & Rurl();


 


var Text URLTWO = "https://4perfectwater.quickbase.com/db/bnt8jzsu6?a=td";


 


$URLONE


& "&NextURL=" & URLEncode($URLTWO)


------------------------------
Denis Rochat
------------------------------
Buttons
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Can you explain the workflow that you want.  

    This code here without the z=rurl() should  save the record when you save and then land the user on a table home page.  Whay workflow are you trying to achieve?


    var Text URLONE = URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?a=API_GenAddRecordForm&_fid_261=" & URLEncode ([Record ID#])
    

     
    

    var Text URLTWO = "https://4perfectwater.quickbase.com/db/bnt8jzsu6?a=td";
    

     
    

    $URLONE
    

    & "&NextURL=" & URLEncode($URLTWO)


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