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

[Terance_Tso]

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]

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]

@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]

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]

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

[Aleksi_Alkio]

You’re welcome

[Aleksi_Alkio]

Are they both OFF?

[Terance_Tso]

@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]

Try to change the table as “Read_Only”.

[Terance_Tso]

@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]

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

[Terance_Tso]

@Aleksi_Alkio I just tried. The problem still exists.

[Aleksi_Alkio]

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]

@Aleksi_Alkio Then, any solution for this problem?

[misahar]

Congrats on building your own investment portfolio app, that's awesome!

[uytrewq]

I see that you've built an investment portfolio app, which is impressive! Regarding the syncing issue with Google Sheets, the problem might have been resolved by now, as the thread is quite old.