I cant seem to be able to work out how to pull members of a queue.
I am building a case management system, I have a table of officers, queues and cases. The cases are linked to a queue and an officer.
The officer links to the queues in the the column Queuelookup linked in officer
I have made the following so in the UX of cases it only shows cases in queues that are a member of i.e Contains(
LOOKUP(USEREMAIL(), “Officer”, “IDEmailOfficer”, “QueuesLookup”), [Queue])
My data says email@example.com [IDemailofficer] and a field that has queue 1, Q2, Q3 [QueuesLookup].
My problem is the other way round, how can I on the queues link all the officers that are members of them.
I would like to be able to see all members of the queues so that when I create a new case I can select the Queue and then see just members of that queue
I guess something like this
Equally, I would like the ref_rows functionality so I can edit this inside the queue rather than going to the officer and editing the members per person.
Thank you in advance