# Choose the data in a googlesheet to use

**URL:** <https://community.glideapps.com/t/choose-the-data-in-a-googlesheet-to-use/65330>\
**Category:** Ask for Help\
**Created:** [August 24, 2023, 7:01am UTC](https://community.glideapps.com/t/choose-the-data-in-a-googlesheet-to-use/65330 "2023-08-24T07:01:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![blam](https://avatars.discourse-cdn.com/v4/letter/b/ac91a4/32.png) [@blam](https://community.glideapps.com/u/blam)\
**Post date:** [August 24, 2023, 7:01am UTC](https://community.glideapps.com/t/choose-the-data-in-a-googlesheet-to-use/65330/1 "2023-08-24T07:01:47Z")

</div>

Hi there,  
I am creating an app for my burger shop and set up a google sheet with a list of items along with their current stock levels.  
I want to create a way to update the stock for each item using buttons, as shown below.

However, when i create text to display the item, i am only able to display the first item in the row. Same goes with the button, it only changes the stock in first row. In this case it is the burger buns and their stock.

I cant seem to find a way to choose which row in the google sheet I want to display in the text and change stock levels with the buttons.  
Is it possible to achieve this? or is there another way to do this?

Thank you much appreciated !!!

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb9a4bf93edb0a0b8225f4b2bd29296931841b71.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/35234f2ce7eb1ce91af1962b70948cf528eab162.png)

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [August 24, 2023, 7:52am UTC](https://community.glideapps.com/t/choose-the-data-in-a-googlesheet-to-use/65330/2 "2023-08-24T07:52:02Z")

</div>

Hi @blam,

Welcome to the community 🥳

You only see the first row because it’s not a list and just a text and buttons that shows only the first row!

For achieve this you need a custom list!

Check this out! : [Burgers add and remove.mp4 - Google Drive](https://drive.google.com/file/d/1BuSIXeVGbo1sVOML3dIB_J-EnXH2whML/view?usp=sharing)

Thank you

---

<div class="post-metadata">

**Author:** ![blam](https://avatars.discourse-cdn.com/v4/letter/b/ac91a4/32.png) [@blam](https://community.glideapps.com/u/blam)\
**Post date:** [August 24, 2023, 8:09am UTC](https://community.glideapps.com/t/choose-the-data-in-a-googlesheet-to-use/65330/3 "2023-08-24T08:09:08Z")

</div>

wow thank you so much! i really appreciate that 😁

---

<div class="post-metadata">

**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:** [August 31, 2023, 8:09am UTC](https://community.glideapps.com/t/choose-the-data-in-a-googlesheet-to-use/65330/4 "2023-08-31T08:09:41Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.