Hi,
I have over 40 tables in my app and a google script to make a back up copy ever so often. The script stopped working yesterday morning. I canโt make a copy manually when in the googlesheet or from the sourde file in the google drive.
I get this error:
Google Docs encountered an error. Please try reloading this page, or coming back to it in a few minutes.
To learn more about the Google Docs editors, please visit our help center.
Weโre sorry for the inconvenience.
- The Google Docs Team
I have identified the sheet and column responsible. If I delete the Order Id Column form the โorder detailsโ table then the sheet will copy otherwise it wonโt. There is no formula or anything - just the order id written to the spreadsheet.
I had to create a new column and copy and paste the data and change a few formulas to get it working.
It seems as though there was somthing in the column that it didnโt like.
I found the offending sheet by downloading the googlesheet as excel. When is opened it up it showed errors on certain sheets. One of which was my order details. Then I delete various columns and tried copying to find the column stopping it.
I still donโt lnow why thos happened.
Any thoughts?
Phil
I donโt have a clue but great detective work finding out the cause.
What were the errors?
Perhaps contact the author of the script for help debugging?
I have attached a screen shot of the error mesaage in excel.
The same problem has come up again having fixed it. It is the Order Id column in my Order Details sheet.
I have noticed some Order Ids have this '72424394 as the order id rather than something like this as expected a86d1a4be.
Iโm assuming this is something to do with the formatting but I have it set to โtextโ.
Deleting all IDs that appear like this does allow me to copy the sheet either though.
Many thanks
Phil
In the worksheet, change the format for that entire column to Plain text:
Ideally, the entire worksheet should be configured to use the Plain text format. At the very least, though, any worksheet column with values generated using UNIQUEID() in the app should be Plain text.
Hi Steve,
Changing every column to Plain Text stopped calculations in google sheet from working. For example the formula below stopped working. Order details G:G is the Order ID in the order details table, A444 is the Order ID being matched in the Orders table and p:p is the monetary value of each order detail.
Result was 0 when everything changed to Plain Text.
=SUMIF(โOrder Detailsโ!G:G,A444,โOrder Detailsโ!P:P)
The google sheet wonโt copy even when I go to File then Make A Copy
Sounds like you need to engage Google Sheets support. The problems youโre having are not AppSheet-related
Hi,
Eventually I found that deleting a tab on the sheet that had about 10K rows but wasnโt in use by the app sorted the problem.
Not sure why as np formulas or other rows referenced it.
Phil
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |