Sure no worries.
I ended up finding a solution where I wrote a custom php page that I used your inbuilt redirect to, then used that page to redirect based on user role and the other meta data. Similar to the one above.
It’s not idea but it works. Would be happy to provide the code for anyone else with this issue, although I am sure @nextendweb would be able to write a better solution.