only view fields if use is in given field

Question

So I work for a real estate company and there are multiple agents listed on a transaction record. Each agent can't see the other's information which is listed in the transaction. I want to be able to hide fields if the user is in the role "agent 1" or hide different fields if the user is in the role "agent 2"

The solution is NOT to have a different record per agent per transaction, it won't work for a bunch of reasons I won't bore you with.
Thank you!!

------------------------------
Karah Weber
------------------------------

markshnier__you · Answer

No problem, you can do this easily using form rules.Set up a formula that starts with win the user is in the role.&nbsp;
you can also start a rule when multiple conditions are true. That will allow you to list multiple roles.&nbsp;
For example when the users in the role of agent one or the user is in the role administrator and show certain fields.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

karahweber · Answer

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.&nbsp;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-------------------------------Karah Weber------------------------------

markshnier__you · Answer

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.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

miketamoush · Answer

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.------------------------------Mike Tamoush------------------------------

karahweber · Answer

Good idea Mike, I will do that when I'm editing the formatting.Mark, here is a picture of what I'm seeing on the dynamic form rules. I don't see where I can make the rule for "Agent 1 is current user".&nbsp;Is the rule supposed to be made somewhere else?Thank you!
------------------------------Karah Weber------------------------------

Forum Discussion

only view fields if use is in given field