Syntax error in a Rich Text Formula
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&ri...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry 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
[email protected]
------------------------------
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
[email protected]
------------------------------
Hi Mark,
Thanks for the reply!
It comes back saying expecting text (highlighting the & before the Rurl() in the var)
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"
& $refresh
& "'><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"
& $refresh & "'><img src=\"https://images.quickbase.com/si/16/016-email_1.png\"></a>")
------------------------------
George Bramhall
------------------------------
Thanks for the reply!
It comes back saying expecting text (highlighting the & before the Rurl() in the var)
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"
& $refresh
& "'><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"
& $refresh & "'><img src=\"https://images.quickbase.com/si/16/016-email_1.png\"></a>")
------------------------------
George Bramhall
------------------------------