Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
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.
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.