Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
10 months ago

Auto Deselect to show in User Pickers when user has no access or is on the Deny List.

 Typically when an employee leaves an organization the first thing the Quickbase administration team is supposed to do is to put them on the Deny List.  Those users, annoyingly, will still appear as drop down choices for any user fields where the user comes off the default user set.

Is there any way to run a pipeline say each night to look for these users on the Deny list or with no access to the app and deselect that user from the green "Show is User Pickers" checkbox? 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • With some kind of API - no, I've never seen that setting outside of the interface. Can you just removed the denied users from the app? You could have a Pipeline that queries all the users in the app and if they're denied simply remove them from the app entirely. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Elite

      If you remove them from the App, what happens to any associated records?  Will we get the infamous red text  "unknown" ?



      ------------------------------
      Don Larson
      ------------------------------
      • ChayceDuncan's avatar
        ChayceDuncan
        Qrew Captain

        They may turn red but they will not become unknown unless the user is deactivated/deleted. Record ownership and user field association is bound to that user - which is independent of any one application or realm. Therefore removing the from the app will not affect how their name displays beyond just the color so you know that user can't access anymore. 



        ------------------------------
        Chayce Duncan
        ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      Oh wow, that would be a great solution to remove the users!   Can you give me a clue for where to find the step to search for users?  What channel is that?  Or is this some kind of fancy API call?



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • ChayceDuncan's avatar
        ChayceDuncan
        Qrew Captain

        It would use the original HTTP API, with the most applicable being API_UserRoles. It returns the full list of users in their roles for that particular app. I was incorrect though, I thought it captured their status but doesn't. You could set this to target users with a role of 'none' and remove them using API_RemoveUser. 

        All of the above could be done with Pipelines using the Quickbase / Request Channel where you invoke a QB specific API call, the rationale is that they will convert their own XML into JSON format to use. If you have access to it - you could also consider syncing the QB realm information and for any denied user in the user sync table just remove their access the same way with a pipeline search and remove user api call. 



        ------------------------------
        Chayce Duncan
        ------------------------------