Forum Discussion
katlyncowley
3 years agoQrew Assistant Captain
creating relationships between Managers -> Employees and then Employees -> Tickets is definitely what you need to do. Then you can pull in the Manager to the Tickets table from those relationships.
After that, you can set your permission for Managers to only be able to see the tickets where the current user is the manager shown on the ticket.
------------------------------
Katlyn Allen
kallen@eatatjacks.com
------------------------------
After that, you can set your permission for Managers to only be able to see the tickets where the current user is the manager shown on the ticket.
------------------------------
Katlyn Allen
kallen@eatatjacks.com
------------------------------
- MichaelKnecht3 years agoQrew TraineeI havent figured out how to make that work as that I dont relate the ticket to an employee. I assign the ticket using a dropdown and its just a user field. How can I take that dropdown and turn it into a "relation" I need to keep most of the original framework surrounding the user field because many form rules decide what employee to assign. I havent been able to get form rules to change a related record the same way they change the user field.
------------------------------
Michael Knecht
------------------------------- MarkShnier__You3 years ago
Qrew Legend
Can you tell us what the Key field is of your Employees table? Is it userid or just Record ID#?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- MichaelKnecht3 years agoQrew TraineeEmployee Table key field is the Record ID. If there is a reason to switch it, we can. If it will help in this scenario and in the future
------------------------------
Michael Knecht
------------------------------