Question on custom button Javascript
I have a custom button (Startup) on a form (Client) that gets clicked from an embedded report (Client Services). It looks like this on the form: https://www.screencast.com/t/ooRhLeJaFac The button...
Forum Discussion
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.
- Thanks Mark. I've been playing with this, but I can't seem to get it to work. The part you left off is the html to make the button display:
"<a class='Vibrant Primary' href='" &
and
& "'>Startup</a>"
, and I'm not exactly sure where in the formula those parts go. From what I have right now, the button doesn't display correctly any more, and instead I get this for a display:
<a class='Vibrant Primary' href='https://page1solutions.quickbase.com/db/bnbximvhc?act=API_GenAddRecordForm&_fid_7=Startup&_f...
Here's the code I have so far:
var text URLONE = "<a class='Vibrant Primary' href='" & 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_CLIENTCODES] & "?a=dr&rid=" & [Related ClientCode] & "#JumpTarget" & "'>Startup</a>";
If( [Client Service Status] = "Never" or [Client Service Status] = "Former",
$URLONE & "&NextURL=" & URLEncode($URLTWO),
""
) - My suggestion is to leave out the fancy vibrant button stuff and focus on getting a plain vanilla URL formula button working first.
- 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 - The field type should be formula URL (not formula Rich Text) and you may give the button any label and color you like in field properties.
