Revising the Process...
We'll take the inside-RT queries and merge them into just one query.
- the register of names needs to use only the latest date if there are multiple lines; how to do that? try a pivot table that filters the maximum value only, and do the inquiry against that.
- have the spreadsheet understand which survey invitation string to use; make a long set of upload commands that work from a single directory and not subdirectories...
- receive the survey transactions into a spreadsheet and divide it up by queue and autogeneate the reports across muliple worksheets. Simpler is better. (Process of letting go)
...
The inside-RT queries...
These queries are how the queues are queried now. The fields returned are Tickt Number, Requestor, Created date. Some queues also do Queue, and all of them should...
...