Looping Issue

sssheoran · 01-11-2022 11:13 PM

We have a main sheet where data is captured from customers.
To avoid multiple submission based on document number, we accept multiple document number is single column with space separator.

We have developed a loop to create multiple records in details sheet based on the number of documents.

For last one month it was working fine and now data is not into details sheet and received error (number of records has crossed 8000).

Kindly assist.

WillowMobileSys

Based on the error message, there are too many “entities” trying to access that single sheet to make updates. This includes people as well as processes - this also includes parallel processes which is based on your paid plan. You can see the number of parallel process by looking at the Performance Analyzer. I am not certain if this number fluctuates.

Example shows there are 3 parallel processes

How many “entities” were trying to access the sheet at the time of the error?

sssheoran

Approximate 500 Plus entities are submitting the requests during a day.

WillowMobileSys

We don’t have all the details to understand your app and properly provide guidance.

My guess is that you have a Google sheet and a Public App?

Google has limitations on their free plan on the number of “accesses” allowed to a sheet within a certain period of time. If you have 500 plus users, who are submitting requests each with multi-number of details rows, it sound like you are hitting that threshold.

Your option are:

Re-design app to somehow prevent the number of requests being made.
Pay for a Google plan that allows greater access bandwidth.
Use a different tool - maybe AppSheet can’t serve your needs right now.

Steve

If you’re using an Excel spreadsheet, EVERYONE must close the spreadsheet while AppSheet is using it.