Formula Rich Text and Formula URL Syntax
Is there a guide available for the correct syntax for the formula URL and formula Rich Text fields? I cannot find any resources other than bits & pieces from various community posts.
Forum Discussion
I love the reload functionality and use it frequently in Formula URL fields, but I have spent longer than I would like to admit trying to get it to work when formatted as a link in a Formula Rich Text field. Is that even possible?
------------------------------
Tate Forgey
------------------------------
------------------------------
Tate Forgey
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendTry this Syntax. In this example the button is toggling a checkbox field to the opposite state.
var bool NewToggle = not [Completed?];
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_6=" & $NewToggle;
var text Words = [Account Name];
var text URL =
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);";
"<a href=\"" & $URL &"\"" & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var bool NewToggle = not [Completed?];
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_6=" & $NewToggle;
var text Words = [Account Name];
var text URL =
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);";
"<a href=\"" & $URL &"\"" & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------