Select Case and URL Button Not working/disppears

Question

URL button disappears in Forms and Table with Select Case statement. It work perfectly when using this alone (URLRoot() & "db/bm2icyt3r?a=API_GenAddRecordForm&_fid_29=" & [Record ID#] & "&_fid_3=" & "&z=" & Rurl() & "&dfid=10",) in the Formula box.

Any ideas?

Formula below

Case([Inspection Type],
"FSV",URLRoot() & "db/bm2icyt3r?a=API_GenAddRecordForm&_fid_29=" & [Record ID#] & "&_fid_3=" & "&z=" & Rurl() & "&dfid=10",
"Interim Inspection",URLRoot() & "db/bm2icyt3r?a=API_GenAddRecordForm&_fid_29=" & [Record ID#] & "&_fid_3=" & "&z=" & Rurl() & "&dfid=11",
"FSV Pre-Check",URLRoot() & "db/bm2icyt3r?a=API_GenAddRecordForm&_fid_29=" & [Record ID#] & "&_fid_3=" & "&z=" & Rurl() & "&dfid=2")

mcfneil · Answer

I'm not 100% sure why its not working, but an easier way to structure things is to use variables.

for example.

var text URL1="google.com"
var text URL2="facebook.com"

Case([Status Field],
"Option 1", $URL1,
"Option 2", $URL2,
null)

balaaboki · Answer

Thanks Matthew,

Tried this will variable and I am getting an syntax error (Declaration must end with a semi-Colon). Formula below.

var text URL1= URLRoot() & "db/bm2icyt3r?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([Record ID#]) & "&_fid_3=" & "&z=" & Rurl() & "&dfid=10;
var text URL2= URLRoot() & "db/bm2icyt3r?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([Record ID#]) & "&_fid_3=" & "&z=" & Rurl() & "&dfid=11;
var text URL3= URLRoot() & "db/bm2icyt3r?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([Record ID#]) & "&_fid_3=" & "&z=" & Rurl() & "&dfid=2;

Case([Inspection Type], "FSV",$URL1,"Interim Inspection",$URL2,
"FSV Pre-Check",$URL3, Null)

quickbasecoachd · Answer

Each of these three lines can't be like thismissing closing quote&nbsp;&amp; "&amp;dfid=10;needs to be this&nbsp;&amp; "&amp;dfid=10";

balaaboki · Answer

Thanks - that worked but the button still doesn't show up on the form or table.

quickbasecoachd · Answer

The most likely cause is that the Inspection Type is not one of those three choices. &nbsp;Are you super sure about that?

Forum Discussion

Select Case and URL Button Not working/disppears

9 Replies

Related Content

Same reference field, different selections within the form

Bulk create child records from selection list

Button: save the new record and edit the new record

An API(?) button to copy fields from the form, to other fields

Specific permissions needed to run a copy master and detail button?

Recent Discussions

Can I use quickbase actions within the same table?

Question about relationships

Reports & Charts - Managing Client-Specific Name Visibility

Summary Table Question

Google Search is back