Hi all, looking to get help with this concern.
So I have a survey I need to create that has 5 survey blocks (10 items each). Beat 1-5. They need to be randomized based on a strata or several stratas.

I first created this randomizer so the population can get 1 of any.
The engagement team wants those 5 survey blocks to be randomized to the most granular level of our hierarchy which is the Team Lead, which is in our Qualtrics global directory.
Because of the setup right now, when we got our responses and checked the lowest hierarchy, there were gaps and not all were taken because there was no strata implemented. We can stratify using client, location, organization, because of the number of responses, but when we go to the most granular level, it has data gaps.
For example: I have one Team Lead with 27 associate responses, but none of them got the Beat 5.
Ideally, I want those 27 to randomly get Beat 1-5, and no gaps happen.
If it's less than 5, that's understandable if one Beat doesn't get answered.
----
I'm looked for the element that will randomize base on a participant data.
I'm trying embedded data, but no avail because we are using the Qualtrics Global Directory.
I was trying for a Branch If element, but it's asking for specific names, but I just want to use that designation as a reference for the randomizer, and I have 4k names for the Supervisor/Team Lead
----
I got this response and most of the research I did on the community forums, is I need to create a web service script and an external database.
"With 4K, I would do least filled with an external database and two web services - one to do assignment and one to update complete counts. You need a webserver with a database (e.g., mySQL). Upload a list of all the teams to a database table, write web service scripts, add web service calls to survey flow, and use returned embedded data in branch logic."
I am a very basic Qualtrics user, extensive usage but mostly on the features that are readily available, some jscript and custom CSS but when I was reading around, webservice scripts and external databases, even googling some code it became more complex for me. I was looking to see if I can get help on building this or at least start to build this here.