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:
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |