The app was working fine. New users would sign up and their data would populate both the Glide spreadsheet and my GoogleSheet.
Then I decided to duplicate the app (just so I would have a backup – thought that was a good idea).
But when I did that, the app is now listed as having “No User Data” – see attached image, instead of “A Few Users”, which is what it said before. And when new users sign up they are listed on the Glide spreadsheet, but not my GoogleSheet.
I have tried to reload both the Glide Sheet and Google Sheet - no resolution.
Could you help me with this. I have made no other changes to the app itself.
When you duplicate the app, it is an entirely new app that has no bond with the original app, except that it copies the full settings, data and layout etc. at the point you duplicated it.
The “user data” shows the amount of users/devices that accessed the app in the last 30 days. It’s logical that your copy has no users. This paragraph is to make sure you don’t misunderstand the “user data” here with the user profiles in your Sheet. They are not the same thing.
Do they sign up on your original app or your copy? It is the amount of the devices that accessed the real app, not the count of users on the profiles sheet.
Probably those rows are being written at the bottom of the Sheet, if you have not cleared empty rows.
It turns out the ARRAYFORMULA in the Google Sheet moves them there. I changed it to another formula.
And then was advised to delete all the blanks rows. Now Glide can’t load the Sheet. Sorry but if you have any idea around this, that would be so helpful.
I tried to replace the Sheet and reconnect under Settings>Data Sync. No success.
I have duplicated the app and the worksheet, and pointed the custom domain to the duplicate. Seems to be working but will monitor as new users join (all my five test new users - seem to be working).