Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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;
var text Words = "My words including any HTML";
var text URL = a formula for the URL with a IF;
"<a href=" & $URL & ">" & $Words & "/>"
- EricEvans_Varga7 years agoQrew CadetI'm afraid I don't follow ... have I mentioned I'm terrified of java ...
I've tried plugging in the formulas but don't quite think I know what I've done. - QuickBaseCoachD7 years agoQrew CaptainI would have to see your attempt in order to edit it. Paste it in the forum, but the forum tends to garble postings with hyperlinks, so you you may need to post it in and then highlight it and use the PRE button below the box.
- EricEvans_Varga7 years agoQrew CadetHere'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);"
,"") - QuickBaseCoachD7 years agoQrew CaptainI think I would have to work with you one on one to unscramble that.
QuickBaseCoach.com - EricEvans_Varga7 years agoQrew CadetYeah, I sliced it and diced it really good - i have no clue what I did. :)
I'll reach out, thanks!