I needed user be able to switch roles without admin access.

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
Use Case -
We have an end user changing jobs but for a 4 to 6 month (hopefully) period this user is working in both roles. They are a project manager and moving to a role as a manager of project managers. The manager can see all projects but a PM is limited to their projects only and this is due to the volume of projects that we have. It becomes a nightmare of data to look at if you are trying to focus on only a handful of projects, otherwise I would put them in new role. I wanted to have them toggle back and forth at their convenience without testing or admin rights.

Resolution -

I made a table with 2 fields, a checkbox and a rich text formula field for a dynamic button that would be labeled 'Change to PM Role' and 'Change to Management Role' and check or uncheck the box. I then made to webhooks that depending on the checkbox would change their role. I made a report with only the button and placed it on the management dashboard and on the PM dashboard for usage.
It works great and was simple to setup for me outside of one syntax issue that still makes no sense. Has anyone else had this type of scenario and how did you design a solution?
Photo of Jason

Jason

  • 1,406 Points 1k badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
If you give them permission to share the app, that also gives them permission to "Test as Role".  So they could change to any Role.  But that may be more power than you are comfortable with.
Photo of Jason

Jason

  • 1,406 Points 1k badge 2x thumb
It is not an ability they are going to be permitted and we have struggled with users on that feature. Most don't like the way that feature works and find it annoying which is why we are taking it away. Thankfully it is only one person for a few months.