I have built an app for my investment portfol...

(Terance Tso) #1

I have built an app for my investment portfolio. I just found that the data in Google Sheets are not synced to my app after pressing the sync button.

The data won’t be updated unless I add a new row or delete an existing row by the app.

Anyone can help?

(Aleksi Alkio) #2

Have you updated the data directly from the gSheet or are you updating it without the app? Do you have the Offline/Sync option “Delta sync” or “Server caching” as ON?

(Terance Tso) #3

@Aleksi_Alkio It is actually the stock price by google finance function. The price is updated on gSheet but not reflected in app.

I am just using the prototype version for personal use. I think both options of Offline/Sync are for PRO plan only, right?

(Aleksi Alkio) #4

One option is if you read the data with scripting for example every hour and then update the sheet with that data. Then you values are “real” and the app can read them.

(Terance Tso) #5

@Aleksi_Alkio Okay, let me think of this. Thank you.

(Aleksi Alkio) #6

You’re welcome

(Aleksi Alkio) #7

Are they both OFF?

(Terance Tso) #8

@Aleksi_Alkio

Yes, both are OFF.

For the Offline/Sync settings, I only have “Sync on start”, “Delayed sync” and “Automatic updates” are ON

(Aleksi Alkio) #9

Try to change the table as “Read_Only”.

(Terance Tso) #10

@Aleksi_Alkio I have two tabs in gSheet; one for google finance data and another one using query function to select google finance data to compile a watchlist.

In AppSheet, I created two tables for these. The google finance data one is editable while the watchlist is already read-only. Do you mean I have to change both tables to read-only?

(Aleksi Alkio) #11

Yes, please test this. I have a feeling what the reason could be but please test first.

(Terance Tso) #12

@Aleksi_Alkio I just tried. The problem still exists.

(Aleksi Alkio) #13

Okay… the problem is this. When you are using finance data, it’s updating your sheet but it’s not actually doing that in the backend. It’s just rendering the display, not the backend where the app reads it throught the API. It’s the same if you set the option “Recalcuation” to “On change and every minute” and you use an expression =NOW(). It renders the sheet, but not the backend.

(Terance Tso) #14

@Aleksi_Alkio Then, any solution for this problem?