Forum Discussion

JenniferMeyer's avatar
JenniferMeyer
Qrew Member
2 years ago

Copying records to another table without the restrictions

Hello fellow Quick Base Conquerers. 
I have our HR app set up in one application and I want all employees to be able to see only their file.  
I can do this with the restrictions in place only allowing then to see if they are a QB user assigned to the file. 

I WANT them to be able to see Name, Title, Company (We have a few companies but want one company directory) company phone number, company email, and tenure of time.  The only way I can see doing this is allowing full access in one app and *see above access* for the HR app. 

Outside of doing double data entry I can not seem to figure out if this is possible.  I created a pipeline to create a new record in the new app but I think the restrictions are carrying over.  I also tried it in zapier.  

Any thoughts?



------------------------------
Jennifer Meyer
------------------------------
Data import and export

4 Replies

Sort By
  • PrashantMaheshw's avatar
    PrashantMaheshw
    Qrew Captain
    2 years ago
    We had a similar problem, we resolved it by creating a report where the user had to type in their Government ID number, DOB 

    This can be done by creating a filter which says Ask the user.

    ------------------------------
    Prashant Maheshwari
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew #1 Challenger
      2 years ago

      My solution to this was to have two tables. The main table holds non confidential info.  The other table is a Parent to the main table and has confidential information,  values from the confidential table are looked up down to the main table. 


      All employees have access to the main table but the confidential table has restricted access rules..

      The effect us that the main table does not reveal the confidential fields to the restricted users.

      So no pipelines and no double entry of data. 


      Just need a button to create the missing Parent or Child depending  on how you want to do your workflow for new employees.  It's also pretty easy to initial the second table by copying the first table  



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

      • JenniferMeyer's avatar
        JenniferMeyer
        Qrew Member
        2 years ago
        Mark,
        I originally did that and the parameters from the "Employee Table" carried through to the "Employee Database Table".  

        Are you saying I should switch them around?  Make the "Employee Database Table" the main table and the "Employee Table" the confidential table?  I could see how that could work.....

        ------------------------------
        Jennifer Meyer
        ------------------------------