Forum Discussion

JasonBowen's avatar
JasonBowen
Qrew Trainee
6 years ago

Field-level visibility control per record in reports

I'd like to control which fields are visible, on a per-record basis, in reports. Use case: I have an Employee report, which lists employees' (active and inactive personnel) names, position, depa...
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
np,
Just put an IF around your code in the button.  If a URL formula calculates to null, then the button will be invisible.

for example

your code probably looks like this

URLRoot() & "db/" & [_DBID_CHECKIN] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Patient ID#])& "&z=" & Rurl()


so make it look like this


IF([Status] = "Inactive, "",

URLRoot() & "db/" & [_DBID_CHECKIN] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Patient ID#])& "&z=" & Rurl()

)