The good thing with private tables is the data-security and data-liability is kept with the GDrive account owner.
Question is how to allow access to sub-users of that primary GDrive account, without revealing the GDrive account credentials to the sub-users.
Seems there is no feature in AppSheet yet, to integrate a GDrive as a hidden data source, like MySQL credentials usually are stored in a non-accissible-to-users .ini.
I was thinking maybe the app to encrypt / decript GDrive contentbe of use, so sub-users may login to the GDrive, but can’t make sense of the data there. If that’s even possible.
Is there ideas for a workaround ?