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, department, and then formula URL buttons to "add new PTO (paid time off)" and "add new Overtime".

I would like for those two formula URL buttons to not be present for any records in which the employee is INACTIVE.

Is this possible? If so, where would I find the controls that would allow me to set this up?

Thanks!
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()

    )