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 ...
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
------------------------------