Forum Discussion

EvanFujikawa's avatar
EvanFujikawa
Qrew Cadet
8 years ago

Creating a child record from a button on the parent form and automatically return back to the parent form after the child has been saved.

Creating a child record from a button on the parent form and automatically returning back to the parent form after the child record has been saved. User is on parent form and adds a record to the ...
APIs and custom code
Forms
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
OK, now it makes sense.  The magic is using "&NextURL= ....

No problem,

var text URLONE = URLRoot() & "db/" & [_DBID_ROOT_CAUSE] & "?a=API_GenAddRecordForm&_fid_17=" & URLEncode ([Record ID#]);

var text URLTWO = URLRoot() & "db/"  & [_DBID_the table name of the parent] & "?a=dr&rid=" & [Related Parent];

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


I am using formula variables for readability and when you link the next thing for QuickBase to do, you need to URLEncode it.  Not sure why, but that's the syntax to make it work.