I have about 15 different apps comprised of (conservatively) 50+ tables, many of which are used in multiple apps. Because the apps grew organically over many years and I was learning appsheet as I went, my organization is frankly—abysmal. Every time I need to add a column to one of the tables, I’m basically opening every app to check if the table is included there and needs to be regenerated to avoid breakdown.
Is there an easy way to get a list of all of the tables included in each app outside of manually going through them?
Apologies if this has been covered in previous posts, but I wasn’t sure what words to search.
The short answer on this is “no”. There is not a UI within AppSheet that gives you that insight.
The long answer is that if you feel comfortable with scripting, you can export your app json manifests from the browser and write a quick script to see what tables and data sources overlap.
We have done this on a couple of occasions. Let us know if you would like to discuss further.
I created copies of all google sheets, organized the copies in drive folders, moved some sheets from one file to another etc, (appropriate to the present logic of my apps)
Then I took every table in every app, and changed it from the old file to the new file