# Boucler sur une liste **URL:** \ **Category:** Ask for Help\ **Created:** [April 14, 2023, 11:04pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553 "2023-04-14T23:04:53Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 14, 2023, 11:04pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/1 "2023-04-14T23:04:53Z")
Bonjour, Dans glideapp, j’aimerai ajouter une action qui s’exécute après l’appui sur un bouton. - Scruter une base de donnée et copier dans une autre base, toutes les lignes pour lesquelles la colonne “select” a la valeur “true” merci d’avance ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/83d58b1840ab0a1a0a8df129ef0a01ee3bc684cc.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/90ff0d9dd4ff3e631714c9e17ac07466c0a94f3a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a9a84d9f48535689f20c4e5ff350279b5220c8e.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 14, 2023, 11:37pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/2 "2023-04-14T23:37:39Z")
There’s currently no “loop” action to help you loop through a list and add the chosen rows. Can you describe more about your use case here? I was thinking about exporting a CSV file or using Make as a middleman, but would love to hear more about what you’re trying to do. ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 15, 2023, 5:56am UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/3 "2023-04-15T05:56:47Z")
Hi, On the compagny i work, we have a machine to seel our product. ([https://www.reussir.fr/fruits-legumes/sites/fruits-legumes/files/styles/normal\_size/public/FEL418\_TECH\_EQUIP\_DISTRIBFilbing.jpg?itok=iZ5n4N5N](https://www.reussir.fr/fruits-legumes/sites/fruits-legumes/files/styles/normal_size/public/FEL418_TECH_EQUIP_DISTRIBFilbing.jpg?itok=iZ5n4N5N)) severeal time a day, someone need to go to this machine to recharge the solded products. we know the solded product by sms, but glide is not able tu read them, so to follow-up the sales an ideas is to select them on the app and archive them on an other page or table. I’m looking for using appscript from google but i’m not sure Glide allow us to use it thanks ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 15, 2023, 6:21am UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/4 "2023-04-15T06:21:51Z")
> [@Valery\_Petit](#): > > I’m looking for using appscript from google but i’m not sure Glide allow us to use it You can do whatever you like with Apps Script. ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 16, 2023, 9:40pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/5 "2023-04-16T21:40:38Z")
that’s right, but it’s to long, so it cannot be the solution… I need to program the action inside Glideapps to have realtime reaction 🤔 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 17, 2023, 12:10am UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/6 "2023-04-17T00:10:25Z")
Then I would resort to the Make integration option. You would send a JSON of chosen rows there, then parse and iterate through that JSON to add rows to your destination table using the Glide API. ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 17, 2023, 5:39pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/7 "2023-04-17T17:39:23Z")
Thanks, I’m trying this. Last but not least, I would like to set “false” the Bolean “select” at the end of the operation… It work with my JS code on Apps Script, but it take so long… Any idea!? Thanks again! 🙃 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bf2fe446b7fb1cd36b2178e46fed97236362e6b8.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/820f8ef630a6809a8597ff5a920a228c6140c5c3.png) ---
**Author:** ![Thomas\_THEVENOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_thevenot/32/57701_2.png) [@Thomas\_THEVENOT](https://community.glideapps.com/u/Thomas_THEVENOT)\ **Post date:** [April 17, 2023, 6:06pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/8 "2023-04-17T18:06:29Z")
Bonsoir Il faut tout d’abord creer une action personnalisée qui va te permettre de faire des actions en chaîne. Dans l’action valider du bouton il faut ajouter une action qui s’appelle set column value. Tu mets la valeur à false et ta case sera décochée. ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 17, 2023, 6:18pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/9 "2023-04-17T18:18:57Z")
Salut, Oui je connais bien les actions personnalisées, mais comment savoir sur quel ligne interviens l’action? ---
**Author:** ![Thomas\_THEVENOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_thevenot/32/57701_2.png) [@Thomas\_THEVENOT](https://community.glideapps.com/u/Thomas_THEVENOT)\ **Post date:** [April 17, 2023, 6:32pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/10 "2023-04-17T18:32:50Z")
Et oui, je n’avais pas pris en compte cette notion de “boucle” ! Dans votre liste sur la photo : - s’agit t’il d’une liste Radio buttons avec l’option sélection multiple ? - si oui, ce Radio bouton est lié à un champ différent du select ? - l’idée serait de faire en sorte qu’en cliquant sur valider le remplissage ce select passe à false ? Avez vous regardez du côté des champs calculé et plus précisément du if Else Then ? Je ne sais pas exactement ce que vous voulez faire, si l’idée c’est d’inverser le true en false, il est possible de le faire avec une colonne supplémentaire (select2) qui observe “Select” est rend une réponse en fonction de celle ci. if select IS true Then select2 = false a voir en fonction de votre besoin ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 17, 2023, 7:00pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/11 "2023-04-17T19:00:40Z")
Yes, C’est une Checklist, le Radio bouton est lié au champ select Le but est de : - copier vers un nouveau tableau les lignes pour lesquels “select” est à l’état “true” - passer select à “false” une fois les valeurs copiés j’ai regardé plusieurs solution, mais je tourne un peu en rond. notamment par ce que je ne sais pas contrôler la “scrutation” du tableau… ---
**Author:** ![Thomas\_THEVENOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_thevenot/32/57701_2.png) [@Thomas\_THEVENOT](https://community.glideapps.com/u/Thomas_THEVENOT)\ **Post date:** [April 17, 2023, 7:16pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/12 "2023-04-17T19:16:44Z")
Je pense qu’en regardant du côté des if Then Else il y a moyen de faire quelque chose… Si je comprend bien, vous voulez copier les “casiers” sélectionner dans une nouvelle table et les désélectionner après. je n’ai pas trop le temps en ce moment, mais cette fonctionnalité est intéressante, je vais regarder quand j’aurais un moment. j’espère que d’autre pourront vous aider aussi ! Après, il reste la solution de Make (integromat) qui permet de faire des itérations et de modifier les feuilles Googlesheet… ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 17, 2023, 7:42pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/13 "2023-04-17T19:42:05Z")
Malheureusement le temps de réponse de googlesheet est beaucoup trop long, j’ai déjà essayer… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 18, 2023, 1:24am UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/14 "2023-04-18T01:24:36Z")
So do I understand it right that once you have copied the rows over, you want to return the “checked” values to “false”? ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 18, 2023, 10:48am UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/15 "2023-04-18T10:48:08Z")
For every for each treated rows, yes ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 19, 2023, 12:37am UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/16 "2023-04-19T00:37:15Z")
Using Make, the full process for me would look like this: - Pass a JSON structure containing the rowID and every info you need to be added to the destination table, to Make’s webhook - Parse the JSON inside Make - Iterate through the rows - Use a HTTP module to add rows to the destination table - Use a HTTP module to set the boolean column back to false, using the rowID. This assumes you are using a normal boolean column, not a user-specific one ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 19, 2023, 11:14am UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/17 "2023-04-19T11:14:43Z")
Thanks ThinhDinh I’m gonna to try and let you know at the and of the week. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/aef8a2a83cfbfa20cd0ff33ab198b7fe7b5d781f.png) ---
**Author:** ![Valery\_Petit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valery_petit/32/52561_2.png) [@Valery\_Petit](https://community.glideapps.com/u/Valery_Petit)\ **Post date:** [April 19, 2023, 9:04pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/18 "2023-04-19T21:04:09Z")
Make work well!!! tanks! i still don’t know how to return the “checked” values to “false”… that’s the last thing I need!!! help 😊 ---
**Author:** ![Thomas\_THEVENOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_thevenot/32/57701_2.png) [@Thomas\_THEVENOT](https://community.glideapps.com/u/Thomas_THEVENOT)\ **Post date:** [April 19, 2023, 10:03pm UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/19 "2023-04-19T22:03:30Z")
Content de voir que la solution avec Make fonctionne ! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 20, 2023, 12:56am UTC](https://community.glideapps.com/t/boucler-sur-une-liste/60553/20 "2023-04-20T00:56:39Z")
> [@Valery\_Petit](#): > > i still don’t know how to return the “checked” values to “false”… Can you show me what you have done with the HTTP calls? [Next page](https://community.glideapps.com/t/boucler-sur-une-liste/60553.md?page=2)