Skip to main content
Question

Field-level visibility control per record in reports

  • July 26, 2019
  • 0 replies
  • 24 views
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!
    This topic has been closed for replies.

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

    )


    • JasonBowen
    • Author
    • Quickbase Alumni
    • July 26, 2019
    Perfect. Thanks!
    Terms & ConditionsAccessibility statement