Forum Discussion

GeorgeBramhall1's avatar
GeorgeBramhall1
Qrew Member
3 years ago

Access to Fields

Is it true that if I hide (no view) a field from certain roles, e.g. pay rate for employees, that anywhere that the field is used (e.g. a formula field) is also not viewable to those roles or viewable to those roles minus the amount of the hidden field?

------------------------------
George Bramhall
------------------------------
Formulas and functions
roles and permissions

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    If a formula refers to a restricted field, then the formula will calculate to null /blank.  It's like with Excel where if you have a field which calculates to @err or @n/a then all the subsequent formula fields also calculate to @err or @n/a.​

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • GeorgeBramhall1's avatar
      GeorgeBramhall1
      Qrew Member
      3 years ago
      So it sounds like I need to create a new field (snap shot or pipeline filled field) sourced from the restricted field that then is used in the formula field.

      ------------------------------
      George Bramhall
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        Sorry, I should've also mentioned that if the restricted field is in the same table and the restriction is that the field is restricted (and not records in another other table being restricted), then you can click the checkbox on field properties for the formula field called "Ignore subfield permissions". In that event the formula will in fact work even though the user does not have access to the individual field used in the formula.  

        So no pipeline or mirror fields required.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------