Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Michael,
I think that this would work as a formula URL button to position to a spot on the form.
var text URLONE = URLRoot() & "db/" & [_DBID_SERVICE_CHANGES] & "?act=API_GenAddRecordForm" &
"&_fid_7=" & URLEncode("Startup") &
"&_fid_44=" & [Unique Primary Key] &
"&_fid_46=" & [Related ClientCode] &
"&_fid_47=" & [Related Service];
var text URLTWO = urlroot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#] & "#JumpTarget";
$URLONE
& "&NextURL=" & URLEncode($URLTWO)
Then you would have a formula Rich Text field on the form near where you want to jump to
"<a name=JumpTarget></a>"
But I see that Matthew also posted an answer and his method may be easier to try first.
I think that this would work as a formula URL button to position to a spot on the form.
var text URLONE = URLRoot() & "db/" & [_DBID_SERVICE_CHANGES] & "?act=API_GenAddRecordForm" &
"&_fid_7=" & URLEncode("Startup") &
"&_fid_44=" & [Unique Primary Key] &
"&_fid_46=" & [Related ClientCode] &
"&_fid_47=" & [Related Service];
var text URLTWO = urlroot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#] & "#JumpTarget";
$URLONE
& "&NextURL=" & URLEncode($URLTWO)
Then you would have a formula Rich Text field on the form near where you want to jump to
"<a name=JumpTarget></a>"
But I see that Matthew also posted an answer and his method may be easier to try first.
MichaelBarrow
8 years agoQrew Cadet
I have no need for fancy either, but I need it to look like a button and not display as the formula itself. How do I do that?
Here's what it looks like now:
https://www.screencast.com/t/Ar03o6E1El
Here's what it should look like:
https://www.screencast.com/t/WmNUsDODZVf
Here's what it looks like now:
https://www.screencast.com/t/Ar03o6E1El
Here's what it should look like:
https://www.screencast.com/t/WmNUsDODZVf