Formula Syntax Help
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...
Forum Discussion
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:
That should do it for you, and make it easy to copy or modify when needed.
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.
Actually, while you are here Matt,
another quick question
If( [InitalScreenCHKBX] = true
and
[FormOfEnt.CHKBX] = false,"<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Initial Screening" & "&rdr=" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87" & "\" ) & '>Return To Dashboard</a>",
If(
[FormOfEnt.CHKBX] = true
and
[DueDiligenceCHKBX] = false,"<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Appointment Paperwork" & "&rdr=" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87" & "\" )& '>Return To Dashboard</a>",
If(
[DueDiligenceCHKBX] = true
and
[ChecklistCHKBX] = false,"<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Due Diligence" & "&rdr=" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87" & "\" )& '>Return To Dashboard</a>",
If(
[ChecklistCHKBX] = true
and
[Appointed?] = false,"<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Due Diligence" & "&rdr=" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87" & "\" )& '>Return To Dashboard</a>"))))
it looks like alot, 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.
This is more of a side issue and can be placed on the back burner. But if you have some time.
It gives me no QuickBase errors, the button just wont show up.
another quick question
If( [InitalScreenCHKBX] = true
and
[FormOfEnt.CHKBX] = false,"<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Initial Screening" & "&rdr=" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87" & "\" ) & '>Return To Dashboard</a>",
If(
[FormOfEnt.CHKBX] = true
and
[DueDiligenceCHKBX] = false,"<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Appointment Paperwork" & "&rdr=" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87" & "\" )& '>Return To Dashboard</a>",
If(
[DueDiligenceCHKBX] = true
and
[ChecklistCHKBX] = false,"<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Due Diligence" & "&rdr=" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87" & "\" )& '>Return To Dashboard</a>",
If(
[ChecklistCHKBX] = true
and
[Appointed?] = false,"<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=buawcnbd5pjszvdimycfs3jdpzd&_fid_340=Due Diligence" & "&rdr=" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=87" & "\" )& '>Return To Dashboard</a>"))))
it looks like alot, 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.
This is more of a side issue and can be placed on the back burner. But if you have some time.
It gives me no QuickBase errors, the button just wont show up.