Updating Calculation

[George_H_Thomas]

Within my app prototype, I just updated the value in one of the cells of the spreadsheet. I am calculating the user input in Column C x Column D. The old value in Column D was 665.75 and the new value is 651.199 , when the app runs through the calculation, the old value continues to be used. I have deleted all the previous rows of calculations, leaving just one row. I am using Google Sheets. Any ideas ( I am not a programmer ! ) thanks in advance!

[Steve]

The app will not see changes made directly to the spreadsheet until a sync from the app occurs.

[George_H_Thomas]

In which part of the app would I sync that spreadsheet? I have not used this for awhile and there used to be a “reload” or some similar command?

[Steve]

There is a Sync button on the app screen in either the top or bottom bars.

[George_H_Thomas]

I have tried the app sync buttons and still no change.

Under data / columns in the web based interface,

What is the “regenerate structure” that is the area where there was a “refresh” or sync like feature previously.

[Steve]

Regenerate:

help.appsheet.com

How to add, remove, or rearrange columns

Regenerating your columns is a necessary step in making sure changes in your spreadsheet are reflected in your app's structure.

[George_H_Thomas]

Thanks for the help! What threw me off was the “are you sure” and dialogue on the regenerate. Additionally the (wrong) values that I had calculated before the regenerate may have effected the calculation. It is working now!