I am new to AppSheet, and have recently started to present data from the Google Sheets.
All is going well, except one of the Google Sheets contains QUERY function, that AppSheet does not show the data of the QUERY function results (attached screenshot).
Is the Google Sheets QUERY supported in AppSheet? And if yes, any settings that I may have missed?
Thank you in advance.
Cheers,
Matthew.
It neither supports, or does not support, QUERY(), that’s just the wrong question to ask. Appsheet allows the backend spreadsheet to calculate its own formulas however it wants, and will display the outputted data. Though certain spreadsheet formula, like a query, will often take a second to display within the app after a change is made. Does the missing data exist in the spreadsheet? have to tried to force another manual sync to see if it picks it up?
Thanks Marc.
The data (result) exists in the spreadsheet, but not from data preview in AppSheet. From AppSheets only the static values are showing up.
I have tried to refresh / regenerate data source in AppSheet but got no luck. May I know how to “force manual sync” as mentioned?
From AppSheets only the static values are showing up.
What else are you expecting?
how to “force manual sync”
Just means to click the sync button in upper-right.
Sorry for the confusion.
I am attaching the screenshot from the Google Sheets, which I am having the Query function to aggregate the data to like Net and NetIn for each row of months. There is data showing there.
But in the first screenshot in this post, the same is not showing up in AppSheet, nor any parts (slices, views, any part of the app) after that.
Thanks for the sync button, just tried again but still got no luck seeing the QUERY data.
The app should show the data that is displayed in the sheet, regardless of if it is static data or formula results. Try temporarily removing the query() and typing some random data in those cells, then sync the app and see if that shows up. Do you have any show_if expressions?
Got it.
I tried removing the query function, and leaving the static values and some simple function (e.g. =123+456). All these are showing up with no issue in AppSheet.
Seems the issue happens only when having QUERY() in Google Sheets.
There is no any show_if expression in AppSheet.
