Just wondering if it’s possible to make random groups from a list of names? The user would set their desired group size (e.g. teams of 4) and a list of 24 names would be divided into 6 random teams of 4.
Had a crack using a series of randomised inline lists, each with the ‘limit items’ set to the number of names I wanted to show. Can easily create one random group of any number, however, the limit number can only be set in the builder. Also, could not work out how to stop groups accidentally containing names that already appear in other groups.
Tried to do it with maths columns as well. Was not sure how to deal with a list containing a number that is not divisible by the requested team size and how to get the app to create some groups of 4 and a group of remainders.
Is the number of teams fixed, or is that also variable?
If variable, would there be a limit to the number of teams?
I’m thinking you might be able to start by shuffling the names, and then chain a series of Slice Array columns together to fill the teams. But as you’d need one column for each team, you’d need to know in advance the maximum number of teams.
Slice Arrays are new territory for me so will definitely investigate.
In the meantime, a nearly satisfactory solution was very simple - copy an inline list 3 times and set their visibility with a choice column (1,2,3, or 4). If ‘3’ is selected the inline list with 3 tiles per row appears. Not perfect as the max number per group has to be 4 due to the limit of tiles per row (although the user can read downwards instead of across to make groups larger), and leftovers aren’t dealt with very well but this will actually do until I play around with slice arrays.
I just did the same thing this week with a bit of Python in Integromat. I take the list of IDs, shuffle them, slide them into chunks and write rows to the Sheet, only problem is the time to sync that back to Glide.