# Values in google sheet not updating

**URL:** <https://community.thunkable.com/t/values-in-google-sheet-not-updating/2932849>\
**Category:** Questions about Thunkable X\
**Tags:** beginner, help\
**Created:** [April 6, 2024, 7:16pm UTC](https://community.thunkable.com/t/values-in-google-sheet-not-updating/2932849 "2024-04-06T19:16:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bruh22886sr](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@bruh22886sr](https://community.thunkable.com/u/bruh22886sr)\
**Post date:** [April 6, 2024, 7:16pm UTC](https://community.thunkable.com/t/values-in-google-sheet-not-updating/2932849/1 "2024-04-06T19:16:11Z")

</div>

I’m trying to implement a feature to my app that would get a user input in the form of Oz. of water drank. I am using google sheets to store the amount of water drank for each user that logs in. However, the code I am using doesn’t update the “waterdrank” value. Here is the code I have already:

 ![Screenshot 2024-04-06 150143](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/5/85ae2dbcf9fa299f0d4ac25ba33fdc609bcea5be.png)

 ![Screenshot 2024-04-06 150201](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/3/033fb2f34b684e6807201ecbab844a41bd2d135b.png)

If anyone could lead me in the right direction I would be very grateful.  
(sorry for the giant code block)

Edit: I’m mostly concerned with the “update value in CFYC datasheet” block.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [April 6, 2024, 7:21pm UTC](https://community.thunkable.com/t/values-in-google-sheet-not-updating/2932849/2 "2024-04-06T19:21:54Z")

</div>

You have a function (Get Value) and three variables inside your Update Value function. So you’ll need to troubleshoot this in steps. First, display the variable values in labels. Also display the value of the Get Value block in a label. Then post all of those values here.

That way we can know what information you are sending to the Update Value block and help you figure out why it’s not working.

---

<div class="post-metadata">

**Author:** ![bruh22886sr](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@bruh22886sr](https://community.thunkable.com/u/bruh22886sr)\
**Post date:** [April 6, 2024, 7:33pm UTC](https://community.thunkable.com/t/values-in-google-sheet-not-updating/2932849/3 "2024-04-06T19:33:14Z")

</div>

Here are the three values

 ![Screenshot 2024-04-06 153042](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c2a0e45bb1f0a2a2c6b24cfb07340e28b41a3b42.png)

I’m guessing the issue is with the USER\_ID variable, I have this variable initialized in another page. Should I initialize it again in this page?

---

<div class="post-metadata">

**Author:** ![bruh22886sr](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@bruh22886sr](https://community.thunkable.com/u/bruh22886sr)\
**Post date:** [April 6, 2024, 9:59pm UTC](https://community.thunkable.com/t/values-in-google-sheet-not-updating/2932849/4 "2024-04-06T21:59:22Z")

</div>

I’m sorry if I have wasted your time at all, but I figured out what I needed to do. Thank you for helping me realize this and teaching me how to troubleshoot my code.  
Hope you have a wonderful day!

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [April 6, 2024, 10:09pm UTC](https://community.thunkable.com/t/values-in-google-sheet-not-updating/2932849/5 "2024-04-06T22:09:51Z")

</div>

You didn’t waste my time. You’re welcome! Glad you figured it out.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [July 5, 2024, 10:10pm UTC](https://community.thunkable.com/t/values-in-google-sheet-not-updating/2932849/6 "2024-07-05T22:10:17Z")

</div>

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