# \[RandomTeams\] Pb with deleting multiple lines and question about the random fonction in Glide **URL:** \ **Category:** Ask for Help\ **Created:** [June 24, 2021, 5:46pm UTC](https://community.glideapps.com/t/randomteams-pb-with-deleting-multiple-lines-and-question-about-the-random-fonction-in-glide/28326 "2021-06-24T17:46:32Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Marc-Olivier](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Marc-Olivier](https://community.glideapps.com/u/Marc-Olivier)\ **Post date:** [June 24, 2021, 5:46pm UTC](https://community.glideapps.com/t/randomteams-pb-with-deleting-multiple-lines-and-question-about-the-random-fonction-in-glide/28326/1 "2021-06-24T17:46:32Z")
Hey gliders, So this is an app [Random Teams](https://randomteams.glideapp.io/) to let the user create an activity in which a group of members (selected from Group A, B, C or D) are split randomly either in a fix number of team (chosen by the user) or in teams with fix number of people (I set the limit of 10 people in a team). My goal was to try to figure out if without a google sheet, I would have a more clean deletion process. The results is better but there are still “residues” of the deletion made by a multiple repetitive step action and I wonder if there was a way like setting a time before the user is able to trigger another action or between 2 repetitive steps in an action. If anyone has a way to be sur that a multiple step action is finished before triggering another one or a way to make a pause between 2 steps in that action that would be very helpfull. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/4183a0db434329c26180fa906c702b3dea8459bb.jpeg "Random Teams Glide") ](https://www.youtube.com/watch?v=yk-xP6kjp18) Marco PS : the other goal was to understand better the random function in glide in a single action column type. The behaviour of the random function is strange sometimes. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [November 11, 2022, 10:31pm UTC](https://community.glideapps.com/t/randomteams-pb-with-deleting-multiple-lines-and-question-about-the-random-fonction-in-glide/28326/2 "2022-11-11T22:31:23Z")
HI @Marc-Olivier, Unfortunately I don’t know how to help you. But I am very interested in your topic, since I am also trying to leverage “randomisation” to teach _Words_ to kids. Target user story: - Kids select some criteria, ex. one topic (home, school…) and a difficulty level (1, 2, …) - and number of questions per quizz (ex. 5, 10, 20) - Then a _list_ of _random_ quizzes appears - Kids choose a quizz then run it. At this stage, in addition to [user] table, I have an [items] tab with key fields being: - words (x500) - criteria 1 - criteria 2 - (usc) criteria 1 - (usc) criteria 2 > Would you have guidances about the best approach to make the random split to create the quizzes ? Many thanks in advance ---
**Author:** ![Marc-Olivier](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Marc-Olivier](https://community.glideapps.com/u/Marc-Olivier)\ **Post date:** [November 13, 2022, 12:43pm UTC](https://community.glideapps.com/t/randomteams-pb-with-deleting-multiple-lines-and-question-about-the-random-fonction-in-glide/28326/5 "2022-11-13T12:43:21Z")
Hello @AyS_0908 I found a way since 🙂 From My Experience, you will have to create in the table of your google sheet a random column with the Arrayformula. Since there is a delay btw glide and Google sheet, you are not able to draw random choices in a too close timeframe (1 min or so which for my case was fine). You could also use the function Rand() with excel formula (code folder): 1. one column A with Rand(ColumnC) formula 2. Column B Math column with x set as now 3. Column C template column with RowId+ColumnB combined Hope it helps Marco ![screenK 2022-11-13 à 13.42.36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/4675461cd46efd7b3387a626a44b892b08892891.jpeg) ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [November 13, 2022, 3:04pm UTC](https://community.glideapps.com/t/randomteams-pb-with-deleting-multiple-lines-and-question-about-the-random-fonction-in-glide/28326/6 "2022-11-13T15:04:16Z")
Many thanks @Marc-Olivier ! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 14, 2022, 3:04pm UTC](https://community.glideapps.com/t/randomteams-pb-with-deleting-multiple-lines-and-question-about-the-random-fonction-in-glide/28326/7 "2022-11-14T15:04:41Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.