Forum Discussion

EricEvansVargas's avatar
EricEvansVargas
Qrew Cadet
7 years ago

Is there a way to consolidate multiple URL buttons into one button, but use the link text/color of each individual button

I currently have 4 different buttons that do 4 different things (and am about to add more). To avoid having users click the wrong button inadvertently, they only show on certain records depending on ...
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
The format for a Rich text field is

var text Words = "My words including any HTML";
var text URL = a formula for the URL with a IF;

"<a href=" & $URL & ">" & $Words & "/>"

EricEvansVargas's avatar
EricEvansVargas
Qrew Cadet
7 years ago
Here's what I've done so far ... trying to add on two of the buttons first:

If([Leave Type]="Transitional Duty" and [Leave Report Date]=Today(),
var text Words = "OT on Trans Duty";
var text url= 
"<a href=" & $URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
"&apptoken=####"&
        "&_fid_70=True" &
        "&_fid_67=OT on Transitional Duty" &
        "&_fid_58="& URLEncode(User()); & ">" & $Words & "/>"
[Leave Description]="Continuous" and [Leave Report Date]=Today(),
var text Words = "RTW"
var text url= 
"<a href=" &$URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
"&apptoken=####"&
        "&_fid_63=True" &
        "&_fid_67=Return to Work" &
        "&_fid_58="& URLEncode(User());
   
"javascript:" & "$.get('" & $url & "', function(){" & "location.reload();" &
    "});" & "void(0);"
,"")