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.
QuickBaseCoachD
8 years agoQrew Captain
My suggestion is to leave out the fancy vibrant button stuff and focus on getting a plain vanilla URL formula button working first.