Forum Discussion

MannyCruz's avatar
MannyCruz
Qrew Assistant Captain
8 years ago

Re: Formula Syntax Help

Okay so I lied, it still isn't working. It's supposed to be a conditional button but I can't figure out where the syntax error is. It won't tell me, it says it could me mismatched parenthesis or brackets, but I counted and double counted. Help?

If(     [IScomp] = true
and
     [APcomp] = false,"<a class='Vibrant Primary' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Initial Screening"  & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87\") & '>Return To Dashboard</a>",
If(
     [APcomp] = true
and
     [DDcomp] = false,"<a class='Vibrant Primary' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Appointment Paperwork"  & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87\") & '>Return To Dashboard</a>",
If(
     [DDcomp] = true
and
     [CLcomp] = false,"<a class='Vibrant Primary' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Due Diligence"  & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87\") & '>Return To Dashboard</a>",
If(
     [CLcomp] = true
and
     [Appointed?] = false,"<a class='Vibrant Primary' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Due Diligence"  & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87\") & '>Return To Dashboard</a>"))))

2 Replies

  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    Try this:

    Yours currently:
    eturn To Dashboard</a>"))))

    My Small change:
    eturn To Dashboard</a>", "" ))))

    I'm adding an else statement and the comma
  • MannyCruz's avatar
    MannyCruz
    Qrew Assistant Captain
    Still no dice, good observation though! I'll have to dig into this one and maybe just restructure the formula if anything. Thanks Matt