google sheets table not refreshing after filtered dashboard updates

[jeffminder]

Created a filtered dashboard with 2 (integer & decimal) inputs. Data is saved to Google sheets data source. Another data source is a second sheet in Google sheets which performs basic arithmetic using the prior two inputs along with a few other calculations (nothing crazy).

The filter has two range-sliders to increment the numbers and that is working. The second page (table) is being updated, as I can see it through a second browser window. However the view of the second sheet does not update unless I exit app sheets or manually refresh the app. Sometimes it takes a long time for this to refresh at all. I've turned off caching in settings, but still having issues.

Is there a way to force the second view (table) to refresh after the first page initiates an update? I'm really new to app sheet, so more verbose is better. 🙂

Thanks!

[dbaum]

You may need to contrive a way to force sync the app to retrieve the latest data from the table that is updated via spreadsheet formulas.

[jeffminder]

Unclear how to attach this suggestions into whats here.   When I looked at the actions for that table, they do not appear to take effect the way the dashboard filter works with inline editing...  perhaps the form isn't actually used in that case.   I may be way off track here...

in short, not clear how to apply this.

[Steve]

When the user makes changes to the first table in the app, those changes get sent to the data source. When changes are sent to the data source, AppSheet will check the data source for updates that have occurred beyond the changes just sent (such as changes made by other app users, or changes made by spreadsheet formulas). If other changes are found, the changes are retrieved and the user's app is updated. The process of sending, finding, and retrieving is not immediate, and usually takes at least a few seconds.

If you want a faster response, consider performing the calculations currently done with spreadsheet formulas with expressions in the app itself.