Forum Discussion

BalaAboki's avatar
BalaAboki
Qrew Trainee
7 years ago

Select Case and URL Button Not working/disppears

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="  ...
Forms
Formulas and functions
Tables and fields
BalaAboki's avatar
BalaAboki
Qrew Trainee
7 years ago

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)