Security and other questions

I am still confused in regards to this application and how to make it useful across our business. I am pretty good with relational databases, but creating the tables across many different business functions and creating forms seems daunting. I don’t want to be a dev or a programmer.

Where do any documents created live? In an individual’s Google Drive instance? I want a central repository, not documents spread across many different user accounts.

If using a Google Sheet as a data source I want the same kind of transparency as above. Unless I use something like a cloud database I don’t see this being possible. I am just trying to keep from having one person be the keeper of the data in case the individual leaves the company.

Is all security handled within AppSheet and views/filtering?

You might want to consider for SharedDrive (Team Drive) folder. See here:

1 Like