Formula Syntax Help

Question

I am trying to get this formula to work so that it changes the status field of a record to display a different section of a form (for reference purpose). So when the button is clicked, the status will change to whatever part of the form the person wants to see. But it has to be in view mode, not edit mode. I cant figure out where my syntax error is.

var text url = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid="&[Record ID#]&"&_fid_340="&"Initial Screening";

"<a class='Vibrant Success' href='" db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) &"'>Initial Screening</a>"

I keep getting "Extra characters after end of formula

mcfneil · Answer

So there are a few things missing and a few quotes misplaced.

So it looks like you are hoping to edit the record, then rdr to display the record. I'd recommend this:

var text URLOne=URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid="&[Record ID#]&"&_fid_340="&URLEncode("Initial Screening");
var text URLTwo=URLRoot() & "db/" & Dbid() & "?a=dr&rid="&[Record ID#];
"<a class='Vibrant Success' href='"&$URLOne&"&rdr=" & URLEncode($URLTwo)&"'>Initial Screening</a>"

That should do it for you, and make it easy to copy or modify when needed.

mannycruz · Answer

This is perfect! You the man Matt, always helping out, much appreciated!

mannycruz · Answer

Actually, while you are here Matt,another quick question&nbsp;If(&nbsp; &nbsp; &nbsp;[InitalScreenCHKBX] = trueand&nbsp; &nbsp; &nbsp;[FormOfEnt.CHKBX] = false,"&lt;a class='Vibrant Success' href='" &amp; Dbid() &amp; "?a=API_EditRecord&amp;rid=" &amp; [Record ID#] &amp; "&amp;apptoken=buawcnbd5pjszvdimycfs3jdpzd&amp;_fid_340=Initial Screening" &nbsp;&amp; "&amp;rdr=" &amp; URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=showpage&amp;pageid=87" &amp; "\" ) &amp; '&gt;Return To Dashboard&lt;/a&gt;",If(&nbsp; &nbsp; &nbsp;[FormOfEnt.CHKBX] = trueand&nbsp; &nbsp; &nbsp;[DueDiligenceCHKBX] = false,"&lt;a class='Vibrant Success' href='" &amp; Dbid() &amp; "?a=API_EditRecord&amp;rid=" &amp; [Record ID#] &amp; "&amp;apptoken=buawcnbd5pjszvdimycfs3jdpzd&amp;_fid_340=Appointment Paperwork" &nbsp;&amp; "&amp;rdr=" &amp; URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=showpage&amp;pageid=87" &amp; "\" )&amp; '&gt;Return To Dashboard&lt;/a&gt;",If(&nbsp; &nbsp; &nbsp;[DueDiligenceCHKBX] = trueand&nbsp; &nbsp; &nbsp;[ChecklistCHKBX] = false,"&lt;a class='Vibrant Success' href='" &amp; Dbid() &amp; "?a=API_EditRecord&amp;rid=" &amp; [Record ID#] &amp; "&amp;apptoken=buawcnbd5pjszvdimycfs3jdpzd&amp;_fid_340=Due Diligence" &nbsp;&amp; "&amp;rdr=" &amp; URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=showpage&amp;pageid=87" &amp; "\" )&amp; '&gt;Return To Dashboard&lt;/a&gt;",If(&nbsp; &nbsp; &nbsp;[ChecklistCHKBX] = trueand&nbsp; &nbsp; &nbsp;[Appointed?] = false,"&lt;a class='Vibrant Success' href='" &amp; Dbid() &amp; "?a=API_EditRecord&amp;rid=" &amp; [Record ID#] &amp; "&amp;apptoken=buawcnbd5pjszvdimycfs3jdpzd&amp;_fid_340=Due Diligence" &nbsp;&amp; "&amp;rdr=" &amp; URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=showpage&amp;pageid=87" &amp; "\" )&amp; '&gt;Return To Dashboard&lt;/a&gt;"))))it looks like alot,&nbsp;but its the same thing repeated a few times. Basically. This button returns the user to a specific dashboard. But before doing so, it changes the status field, depending on what checkbox is checked.&nbsp;This is more of a side issue and can be placed on the back burner. But if you have some time.&nbsp;It gives me no QuickBase errors, the button just wont show up.

mannycruz · Answer

Nevermind guys, I actually figured out what my mistake was, I was referencing the wrong fields haha. Oops.&nbsp;

mannycruz · Answer

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>"))))

Forum Discussion

Formula Syntax Help

Related Content

Jinja If else statement syntax

Delete Formula Button Error

Formula Query with custom key

Formula Assistance

Formula Url Buttons