Add button embedded report

When a URL formula field calculates to blank, then the button will be blank.  

So just put a IF statement around  your URL formula and leave the alternative condition blank and the button will end up being blank. 

Feel free to post back if you have trouble with the syntax for the IF statement.

URLRoot() & "db/" & [_DBID_BJS_YOUTH_UPDATES] & "?a=API_GenAddRecordForm&_fid_12=" & URLEncode ([Record ID#])& "&z=" & Rurl()

var text URL = URLRoot() & "db/" & [_DBID_BJS_YOUTH_UPDATES] & "?a=API_GenAddRecordForm&_fid_12=" & URLEncode ([Record ID#])& "&z=" & Rurl();

IF([Status] <> "Closed", $URL)

Of course I'm not exactly sure what your field names are for determining if the record is open or closed for editing, but you will get the idea from the formula above. You'll notice that the formula is silent as to what happens if the status is closed and that will cause the button to go blank.  

Thank you, so I add both formulas to the button field?

Ok, in the IF formula it's highlighting the $ yellow?

and I essentially have 2 status options that consider a record closed, they are closed and transitioned to another facility. How would I incorporate both of those options?

It worked when I removed the space between the $ and URL and used $URL. I'm not sure how to incorporate the other option 

That worked, many thanks!!