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

Question

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------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community