Happy new year all!
I don't seem to have my brain switched on just yet after all the holiday fun!
I'm trying to create a workflow that will select one person from each team at random. I've been trying the Rand function and the sample tool, but so far haven't managed to achieve the correct result.
I'm sure this is quite simple, but I just can't get my head around it. I've attached some dummy data. It would be great if someone could point me in the right direction.
Thanks!
Solved! Go to Solution.
1. Create a random field rand()
2. Sort by random field
3. Sample 1 record
cheers,
mark
@MarqueeCrew beat me to it, I had created and posted it, while he had written his explanation 🙂
Thanks Mark, that's sorted it!