Skip to main content
Question

Syntax error in a Rich Text Formula

  • May 23, 2021
  • 0 replies
  • 48 views
GeorgeBramhall2
Forum|alt.badge.img+11
Can someone spot my syntax error in this formula? When I try to save it says rdr needs to preceded with a (, but that does not work. 

If([Sent Checkbox],"<a href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=dwh245kc9bvrzfcqkqfwmd876gjx&_fid_35=0& ("&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z"= & Rurl())& "'><img src=\"https://images.quickbase.com/si/16/018-email_unread.png\"></a>","<a href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=dwh245kc9bvrzfcqkqfwmd876gjx&_fid_35=1& "&rdr="&URLEncode(URLRoot() & )"db/" & Dbid() & "?a=doredirect&z"= & Rurl()& "'><img src=\"https://images.quickbase.com/si/16/016-email_1.png\"></a>")

------------------------------
George Bramhall
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • May 23, 2021
try this ... but what I recommend is to use formula variables for each part of the IF result and then put them together in the IF

I also recommend putting this into a formula variable


like var text Refresh = URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z"= & Rurl();

If([Sent Checkbox],
"<a href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=dwh245kc9bvrzfcqkqfwmd876gjx&_fid_35=0"

&

"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z"= & Rurl()

& "'><img src=\"https://images.quickbase.com/si/16/018-email_unread.png\"></a>","


<a href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=dwh245kc9bvrzfcqkqfwmd876gjx&_fid_35=1"
& "&rdr="&URLEncode(URLRoot() & )"db/" & Dbid() & "?a=doredirect&z"= & Rurl()& "'><img src=\"https://images.quickbase.com/si/16/016-email_1.png\"></a>")


if that does not work and you want to post back please copy and paste your error message.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement