Concerns about Using an AppSheet Application for 400 Users

AppSheet AppSheet Q&A
21

Things of this nature are sorely lacking at the moment.

  • You can see usage, but not necessarily how that usage is stacking up against the limits.

Information like this would be extremely helpful when you’re in the process of adapting your app for scale.

2 Likes
22

I created an app that 100 users all log into roughly in the same half hour period, though not all exactly at the same time. It is comprised of 20 tables, mostly Google Sheets, but two BigQuery tables also. A couple of the Google Sheets are around 20,000 rows with 10-15 columns. One table is a Google Calendar data source. I made use of many virtual columns to relate everything, checking in on sync times after creating each one to make sure it would still move smoothly. Average sync time is about 3 seconds.

It’s been great so far and we’ve been using it as an organization for close to a year now.

I would say it can be a totally viable idea.

1 Like
23

Hi @Rich_E
I just received the following response regarding this Quata issue.

This is to notify you that we have got an update from our specialists and they mentioned that “the documentation you are looking at there is for the Sheets API: https://developers.google.com/sheets/api/limits#quota not AppSheet itself. This is the default quota for a new GCP project that uses the Sheets API – AppSheet has a GCP project that manages its Sheets API usage which has quota increased far beyond the default limits listed in the docs.”

This means that the GCP project that AppSheet has in their name to handle API calls to Sheet has far more quota than the general quota listed. Currently there is no specific limitation from AppSheet that could hinder this quota.

I feel that this is clearly at variance with the help and your explanation.

https://support.google.com/appsheet/answer/10105761?hl=en&sjid=18377445913784691487-AP#data-sources:~:text=The%20Sheets%20API%20quota%C2%A0calculation%20is%20based%20on%20a%20per%20minute%2C%20per%20project%2C%20per%20user%20request%20basis.%20%C2%A0

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Concerns-about-Using-an-AppSheet-Application-for-400-Users/m-p/789150/highlight/true#M249957

Could you please provide me with the correct information?
My case ID is 8-1735000036536.

1 Like
24

This is truly a great question, and the discussions in this topic have been very helpful to me. I’ve been using AppSheet since 2020, but only now have I learned about these API limits. It would be fantastic if there were a way to track the number of API calls used in ‘Usage Statistics’ or ‘Performance Profile’ so that we could easily monitor and adjust our application

Thanks!

1 Like