No problem, you can do this easily using form rules.Set up a formula that starts with win the user is in the role.
you can also start a rule when multiple conditions are true. That will allow you to list multiple roles.
For example when the users in the role of agent one or the user is in the role administrator and show certain fields.
Thank you Mark!Unfortunately I misspoke. The Agent is not in the "role" of agent 1, but is listed in the Transaction record Field called Agent 1.So I can't restrict with the form rules. Also, each agent can sometimes be agent 1 or agent 2, it just depends on the transaction.Sorry for the misstep, but I'm crossing my fingers that you still have a solution for me!
Thank you again-
Ok, well still no problem."When agent 1 is the current user then show or hide"Of course this assumes that these agent fields are user fields.
To add on to Marks solution - if the fields they each see are totally different, consider making 2 sections named Agent 1 and Agent 2 and putting the relevant fields in each.
Then simply hide each section using Marks advice. I find this much easier than parsing through a dozen fields and making sure I am hiding and showing the right ones.
If I remember correctly you need to 'trick' QB a little for this one. Make a formula user field called [Current User] with the formula User()Then in your dynamic formula select is equal to 'the value in the field' [Current User].In fact, when I do this I usually say, multiple conditions:Condition 1: Agent 1 user is the value in the field, [Current Uder]ORCondition 2: The user is in the roll administrator.This way, I as the admin get to see both sections. I find it helpful not to hide things from myself, but others want it to look clean for themselves as well, so a bit subjective.