Need guidance, I have half the solution but can’t figure out to do the other half
A public member creates a record/ticket, I get the creators email address and make it a row owner, so now public can ONLY see the tickets they create.
I have another column for assigned technician and I make that column a row owner too, now when I assign a technician to the ticket the tech can also see that row.
I have a general call center (CSRs) about 10-15 (varying number), they also need access to tickets, they should be able to see all tickets. How do I do that and make it manageable. The CSR’s change often so it needs to be easy to manage. Is there a way of saying anyone who is a CSR has access without make it a private app ?