Error Cloning App from data sheet not available

[Lucinda_Mason]

The data table/worksheet is in the google speadsheet. I’ve tried multiple times. I even regenerated that table, successfully, but it still won’t copy. Any suggestions

[LeventK]

@Lucinda_Mason
Does not sheet anyhow contains an IMPORTRANGE formula or a QUERY formula from a different spreadsheet?

[Lucinda_Mason]

Not that I know of. I created this particular sheet yesterday by copying the structure from another sheet in this notebook. Could that have created anything that is messing it up? I checked the table in AppSheet and there doesn’t seem to be anything odd there. I looked, where I knew to look, in that sheet in google sheets and didn’t see anything.

One odd thing is that the Error message seems to imply that the sheet is named TYPE. That is the name that AppSheet always gives the copied spreadsheet because the first Table in my app is named Type. Could it somehow be looking at the wrong place to copy the data? I double checked and my tables are all pointing to the correct google sheet.

I was able to copy the app, just not the data.

[Lynn]

Hi @Lucinda_Mason
I may be wrong but I dont think Appshet can do what you are trying to do.

[Lucinda_Mason]

Lynn, I think you misunderstood. I’m simply backing up my app and data. I’ve done it dozens of times. This is the first time I’ve had errors. My previous post was just telling about how that particular sheet was created in google.

I’ll try again tomorrow before the scheduled maintenance.

[Lynn]

Ok, I wasnt too sure what exactly you were doing. Hope it works out ok for you.

[Steve]

Please contact support@appsheet.com for help with this.

[Lucinda_Mason]

Done.

[Lucinda_Mason · Accepted solution]

As a follow up, Aleksi took this on and his team found the issue:
Hi Lucinda, we found the main reason for this. Your sheet name have more than 30 characters. It works when you add that table to your app as you have done. But it seems that when you copy the app, the process reduce the sheet name’s length to 30 characters and then of course the copy process won’t work. As a workaround when we are investigating from where that limit is coming from, please reduce the original sheet name to 30 or less characters and then copy the app