Record Owner Form Rule or Formula?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress

I am currently trying to setup the following as a form rule:
If Record Owner is equal to "x" role, and another field contains "x", then show this checkbox.

The issue I'm running into is that Record Owner is not allowing me to select from a specific user role.  I am thinking this may need to be converted into a formula in order for it to work in the rule?  So far, my efforts have been unsuccessful.

If anyone has any suggestions as to how I can make this work, it would be greatly appreciated.

Thank you!
Photo of bintu85


  • 90 Points 75 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
I don't think that is supported.  You may have a form rule when 
The user  is in the role xxxx

But I do not believe you can key a form rule off the Role of a user in a field.
Photo of Michael Barrow

Michael Barrow

  • 2,216 Points 2k badge 2x thumb
What we've done is set up an Employees table, and each record has a User field. We also have another field for their business role (not necessarily the same as their QB access role). I also have a single-record table called Parameters that holds all of my system variables. The current logged-in user can be related to this through a Related Current Employee formula text field where the formula is simply User(). So I have the email address and the business role of the current user and can incorporate in formula fields and dynamic form rules.