Create a form rule which compares current user with a value in an unrelated record

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

There are two unrelated tables in this problem: Services and Personnel. Well, they are related but not in a useful way.

First the Personnels; each Personnel is assigned one Quickbase user. That is, there's a user field in each Personnel record which is used to make this assignment.

Now, the Services. I'd like to have a form rule showing/hiding a section of a form in my Services table, based on whether a checkbox is checked in a Personnel record which is unrelated to the form (checkbox field is "Eligible for Sales Commissions"). 

So, for example, user Steve has the checkbox checked. So when user Steve goes to any Service, he sees the Sales Commission part of the form. Note that I can't solve this problem with roles because not everyone assigned a certain role is eligible for sales commissions.

Photo of Jonathan Heuer

Jonathan Heuer

  • 400 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
here is what I recommend.

Make the key field of the Personel table be the userid.
On the services table make a field called current user with a formula of

User()

That will always have he value if the userid of the current user.


Then make a relationship between the tables based on that [Current User] field, and lookup the Commisison checkbox to use in your form rules.