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
MarkShnier__You
Qrew Legend
Qrew Legendactually that last line can be simplified to this
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
As usual, Coach, you pushed me in the right direction here - SUCCESS! However, I think there could be a couple of small errors in your code. (URL declared twice - that was an error for me although maybe that works in some other way and javascript outside of the anchor tag made that appear as text - when I removed the second URL declaration.) This is a fragment from a long "IF" statement in my variable (why I needed rich text in the first place) that also has a div tag around it, but I'll put in the relevant portion that I got to work in my rich text field. As ever, thank you! Now I can use this field anywhere!
var text URL = URLRoot() & "db/" & [_DBID_SHIFTS] & "?act=API_AddRecord"
& "&_fid_10=" & URLEncode ([ID])
"<a href=\"" &
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
&"\"" & ">" & "Add Shift" & "</a>"
------------------------------
Tate Forgey
------------------------------
var text URL = URLRoot() & "db/" & [_DBID_SHIFTS] & "?act=API_AddRecord"
& "&_fid_10=" & URLEncode ([ID])
"<a href=\"" &
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
&"\"" & ">" & "Add Shift" & "</a>"
------------------------------
Tate Forgey
------------------------------