# Put text with a button in a Google Sheet cell **URL:** \ **Category:** Ask for Help\ **Created:** [February 26, 2024, 10:19am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168 "2024-02-26T10:19:24Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 26, 2024, 10:19am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/1 "2024-02-26T10:19:24Z")
Hello everyone, I would like to put text with a “Yes” “No” button or simple text with the “Text” button in a google sheet cell Thank you for your feedback Denis Bonjour à tous, Je voudrais mettre du texte avec un bouton “Oui” “Non” ou du Texte simple avec le bouton “Texte” dans une cellule google sheet Merci pour vos retours Denis ![Oui-Non-Texte](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/49f2f5b75e04d7723437d3f07f8acd913cc2410b.jpeg) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 26, 2024, 10:28am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/2 "2024-02-26T10:28:39Z")
> **[Set Column Value | Glide Docs](https://www.glideapps.com/docs/automation/actions/set-column-values)** > > Change column and row values. ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 26, 2024, 11:00am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/3 "2024-02-26T11:00:30Z")
Thanks, but I want to put the text in the selected box on the screen, not in a specific column In any selection in any column Merci, mais je veux mettre le texte dans la case sélectionnée à l’écran, pas dans une colonne spécifique ![Set-Column-Values](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e00d52fbe56cd564c89f6fb6956875519760b15.png) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 26, 2024, 11:32am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/4 "2024-02-26T11:32:29Z")
If you prefer users not to directly input into the ‘Data Grid’ and instead prefer using buttons, then you should filter your page to land on the selected row. Otherwise, you will fill into the first row, as by default your landing page is currently the first row. Your title mentions Google Sheets, do you mean “data Grid”? ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 26, 2024, 1:05pm UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/5 "2024-02-26T13:05:18Z")
Yes, I import a Google Sheet into a Data Grid ![FeuilleGS](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad8af96bed484be3a72a1e3fc5cb92226ea6125b.png) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 26, 2024, 1:22pm UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/6 "2024-02-26T13:22:28Z")
To help you understand what I mean, please try the following steps: 1. Try adding a list collection component to the current page. 2. Click on one of the items in the list. 3. Delete all default elements that are already there. 4. Move all your “data grid” and buttons here. > **[List | Glide Docs](https://www.glideapps.com/docs/essentials/components/collections/list)** > > Display a group of items in a list layout. ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 26, 2024, 1:36pm UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/7 "2024-02-26T13:36:32Z")
The link to a copy of my project [https://go.glideapps.com/app/uak2ba7TIM9zNK3EV8j7/layout](https://go.glideapps.com/app/uak2ba7TIM9zNK3EV8j7/layout) And the presentation of the google sheet table ![tableau](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/50e0ddd5fd2a0bb2da86473405e30be13f52df0a.png) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 26, 2024, 1:45pm UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/8 "2024-02-26T13:45:40Z")
I can’t open your application. What plan are you on? ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 26, 2024, 2:06pm UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/9 "2024-02-26T14:06:21Z")
I set the app to “public” and it should work now ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 26, 2024, 2:12pm UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/10 "2024-02-26T14:12:35Z")
The URL you provided is a builder, not a published application. I don’t have access rights to enter. Please explain your issue and what you want to achieve here. Have you tried my instructions above? Regarding your Google Sheet issue, it’s best to have headers in the first row to avoid confusion for Glide to recognize them. I assume you are on a plan that is always connected to G Sheet. ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 26, 2024, 4:02pm UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/11 "2024-02-26T16:02:01Z")
I want the “Yes” button to write the text “Yes” in the cell chosen by the user. Row=This item and Column=This item Same for the “No” button And the “Text” button edits the cell in text mode. Je souhaite que le bouton “Oui” écrive le texte “Oui” dans la cellule choisi par l’utilisateur. Row=This item and Column= This item Pareil pour le bouton “Non” Et que le bouton “Texte” édite la cellule en mode texte. Thanks for your help 😉 ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 26, 2024, 4:23pm UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/12 "2024-02-26T16:23:12Z")
> [@Denis\_MacDony](#): > > Row=This item and Column=This item Yes, first you need to create the list component, then “this item” will indicate which row is targeted. After it’s created, you can add Yes/No buttons to indicate which column to input. Using the set column value, you can fill it with yes/no for the correct row and column (please refer to the document I provided above). You cannot simply use the cursor to point to a box in the ‘data grid’ and then press a button. ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 27, 2024, 6:26am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/13 "2024-02-27T06:26:07Z")
@Himaladin , I can’t with a List My data table has information that is cross-referenced The top-left part must be fixed in the application as well as the list of members. Events must be able to move or be selected so that members can put Yes or No Je ne peux pas avec une List Mon tableau de données a des informations qui sont croisées La partie haut-gauche doit être fixe dans l’application ainsi que la liste des membre. Les évènements doivent pouvoir se déplacer ou être sélectionnés pour que les membres puissent mettre Oui ou Non ![Style-tableau](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a04a2e50348cf452741f0d928e335eeb199c9a0.png) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 27, 2024, 6:47am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/14 "2024-02-27T06:47:41Z")
Have you create a list collection? ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 27, 2024, 7:20am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/15 "2024-02-27T07:20:01Z")
Yes, and ? ![Liste](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d8b9933402b6911f1250088deca72848572dc92.png) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 27, 2024, 7:34am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/16 "2024-02-27T07:34:33Z")
Now you can filter out unwanted rows from being displayed. However, it’s advisable to separate these two different blocks of interest into different tables/column so that you don’t need to perform this filtering, while also maintaining the security of your data table. ![Screenshot 2024-02-27 at 14.34.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e28d035da2a3d575b0ddf3d0aacc9e19c8817a37.png) ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 27, 2024, 9:15am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/17 "2024-02-27T09:15:43Z")
it doesn’t work in a list with the data style in my sheet The data is crossed, see my last “style-tableau” image or you have to give me an example thank you for your help ça ne fonctionne pas en liste avec le style de datas dans ma feuille Les datas sont croisées, voir ma dernière image “style-tableau” ou alors il faut me donner un exemple Merci pour ton aide ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 27, 2024, 9:28am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/18 "2024-02-27T09:28:06Z")
What do you mean by The data is crossed? > [@Denis\_MacDony](#): > > The data is crossed Why do you limit the number of items? ![Screenshot 2024-02-27 at 16.24.56](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/64cfd58f89ed2c348ad1883d96aa385859ef83bb.png) ---
**Author:** ![Denis\_MacDony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/denis_macdony/32/71493_2.png) [@Denis\_MacDony](https://community.glideapps.com/u/Denis_MacDony)\ **Post date:** [February 27, 2024, 9:31am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/19 "2024-02-27T09:31:37Z")
Here is a copy of the Google Sheet tables to make an example, thank you > **[Sorties-2024-Dony](https://docs.google.com/spreadsheets/d/1Kl09kaH8ps5ln1QcaBdCkps78eyO-KtvcOvtmHiYFSg/edit?usp=sharing)** > > 1er Semestre ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 27, 2024, 10:18am UTC](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168/20 "2024-02-27T10:18:23Z")
I have made a copy and notes in your GS. Please follow the instructions in my notes column. Please read the documents available on Glide so that you understand how Glide works rather than how it works in a spreadsheet. [Next page](https://community.glideapps.com/t/put-text-with-a-button-in-a-google-sheet-cell/71168.md?page=2)