Forum Discussion

MikeDeMetroTEST's avatar
MikeDeMetroTEST
Qrew Member
5 years ago

Issues Accessing Field

I have a table, called Sites.  This table is restricted for users and users could only access Sites they have permission to.

I have another table, lets call it Child Sites.  A Site could have many Child Sites.  Child Sites is just a link between two different Sites, and a Child Site Name is just a Site Name.

The issue is, since users are restricted by the Site, they can't access the Child Site Name since that is just pulled from the Site table.  I would like users to have permissions to just the Site Name itself so they could see a Child Site Name, but I am having issues doing it.

I tried to create a Formula Field in Child Site that equals Site Name.  This is still not showing I'm guessing since it's pulled from the Site table directly.

Is there a way to either:

1. Make a new field that automatically populates from the Site Name in Child Site without DIRECTLY pulling from Site Name since that is restricted?

2. A way to make just one field accessible for every user on a table they do not have access to?   



------------------------------
Mike Savan
------------------------------
roles and permissions
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    I don't know how many different fields you have on the restricted table but there is some thing called field level permissions by role. You could set all of those other fields to no access and just allow access to the site name field and still allow the users to access all the site records.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MikeDeMetroTEST's avatar
      MikeDeMetroTEST
      Qrew Member
      5 years ago

      Hi, appreciate the reply.

      There's a few hundred fields so don't really think that's a viable solution unfortunately (I also didn't design the database).  If there was a way to lookup the value it would be fine, like if I had a field in Child Site that just was the copied value.  But is there a way to make a field have populate the value from another field without being a direct reference to the field?

      So if I have a field called Name in child Site, I would like another field called Public Name that just copies the value of Name (without a direct reference to bypass the permission issues).  I coudn't find a way to do this in Formula Fields (it copies the reference to the old ones).

      Also I couldn't find a way to do this within automations as well.

      I'm also open to other ideas. 



      ------------------------------
      Mike Savan
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        An Automation, Pipelines and form rules can all copy that field across to a scalar data entry type field.  That can also be safety netted with a saved table to table copy running each night by a scheduled Automation to populate the field.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------