Skip to content
This repository has been archived by the owner on Jun 8, 2023. It is now read-only.

Get value from Google Sheet not updating properly #1138

Open
tatiang opened this issue Apr 4, 2022 · 8 comments
Open

Get value from Google Sheet not updating properly #1138

tatiang opened this issue Apr 4, 2022 · 8 comments
Assignees
Labels
bug Something isn't working

Comments

@tatiang
Copy link

tatiang commented Apr 4, 2022

Platform

Drag and Drop UI - web?
Drag and Drop UI - iOS?

Steps to Reproduce

  1. Click the "Get & update values" button to get and display a value from a Google Sheet cell (e.g. 4), and update the value by one (e.g. 4+1).
  2. Wait a few seconds (or more) and click the "Get new value" button.

Expected Behavior

I would expect the second time the value is displayed that it includes the added value (e.g. 5).

Actual Behavior

The second time the value is displayed, it shows the original value (e.g. 4).

Project Link

https://x.thunkable.com/copy/1feeef38c13e4150815598a95155e283

###Community Link
https://community.thunkable.com/t/cant-get-value-from-google-sheets/1816128

  STACK TRACE AND/OR SCREENSHOTS
@jaredgibb
Copy link

Thank you for reporting this. I can confirm this is occurring and have escalated this to our team!

@jaredgibb jaredgibb self-assigned this Apr 4, 2022
@jaredgibb jaredgibb added the bug Something isn't working label Apr 4, 2022
@tatiang
Copy link
Author

tatiang commented Apr 5, 2022

The get row object block seems to also have a bug getting current data from Google Sheets.

@tatiang
Copy link
Author

tatiang commented Apr 5, 2022

It looks like the issue is not limited to Google Sheets. The Get Value block is also not working with Airtable in the DnD interface.

@tatiang
Copy link
Author

tatiang commented Apr 5, 2022

I'm having a similar issue with the get row object block. It doesn't retrieve a value. But the list of values block does work.

@tatiang
Copy link
Author

tatiang commented May 3, 2022

Any news on this? I tried to teach my students how to use the Get Value block with Airtable and it wouldn’t pull any data. We ended up using the Get Row Object block which thankfully did work but it would be best to not have to use workarounds.

@jaredgibb
Copy link

please check this example. I just tested this on web and mobile both and it worked for me
https://x.thunkable.com/projectPage/623de6905794b10012455be6

this works to add and get a value from airtable for me

Screen Shot 2022-05-03 at 9 55 05 AM

@jaredgibb
Copy link

^^^ i also just tested this with google sheets successfully.

@GertjanVandenKeybus
Copy link

Experiencing this same issue still.
I update a specific cell. And in the next screen get the new value from that cell.
The value from the get function is still the old value.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants