Centralized Table view and control

[NDBrowder]

I have many tables which are utilized across multiple Apps (user lists, customer / contact lists, etc.). I repeatedly encounter situations where I need to change the structure of one of these tables. Currently, I have to make the change, and then go through each app which utilizes that table and “regenerate structure”.

This brings to light two issues in my opinion:

1. I cannot see a list of all Apps which utilize the table data.
2. I need to separately regenerate each instance of the table, one at a time.

I believe both issues could be solved by creating an account-wide Table View module. This module would show all of your Data tables and the apps which are connected to them. It would also allow a bulk “regenerate structure” command which would regenerate the column structure across all apps.

[Marc_Dillon]

Yes, this is definitely a pain point when managing development across multiple apps using the same data source.

I think your first request may be possible and handy, having Appsheet somehow output a list of apps connected to each Table. Though I highly doubt the viability of a bulk regeneration.

Thanks for bringing this up. Hopefully someone from Appsheet will see it and put it on some to-do list somewhere.

[NDBrowder]

Hello Marc, thanks for your feedback!

I really like the implementation of the new “AppSheet Monitoring” dashboard, perhaps something similar would work for a “Tables” dashboard as well.

[NDBrowder]

Update: I have discovered a potential work-around which addresses part of my issue. If you open a spreadsheet in Google Sheets and open the sidebar menu, you can add AppSheet as an ‘add-on’.

Once this is added, clicking the add-on will show you which Apps the current sheet is linked to in a section titled “Apps Using this Sheet” (See Screenshot)

[Marc_Dillon]

Nice tip. I’m not 100% sure about the accuracy of the list of apps though. Mine shows one spreadsheet being used by 4 apps, but it’s actually just the same app listed 4 times.

[NDBrowder]

Now that I look closer at it, I believe it is based on the entire Spreadsheet rather than the specific sheet which is active. Still, could be useful.