Security and other questions

[Rockn]

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?

[hru]

Rockn:

I want a central repository, not documents spread across many different user accounts.

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

Data Organization for Teams Tips & Tricks 💡

I published a new article about data organization for teams. It is available in the AppSheet help docs. Check it out! The article describes how to use a Google Shared Drive or an O365 SharePoint site to store data for your team. Using a shared data location can be helpful to ensure longevity beyond a single user’s cloud account. It also makes transferring apps between owners a breeze. The article focuses on using a single shared drive for the whole team. The same process could be applied to us…