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?