Hi Everyone,
Just thinking on this before I go too deep, I’m sure some of you experienced users will have been here.
So I have an existing app for managing jobs with a sheet for “Personnel” (most of which who are app users so this table dictates a few permissions and things as well as holding personnel data). I’ve decided to create another app for managing Health and Safety/HR to bring this in-house, and want a single data source between the two, with this information maintained in the H&S/HR App. At this stage this will be the only shared table, but I think there will be more in future and possible a third app for equipment management.
Is the correct and easiest thing to have all the data tables in a single Google Sheets file? So say ten sheets solely to the job app, five to the H&S/HR app and one sheet shared?
If so, the second question is that I have sheets and an app to start from already in a separate sheet (I made a basic version for a related business which I’d just expand for this application rather than start from scratch), is it as simple as copying the sheets into the existing file for the job app then changing each table in AppSheet to look at this location instead?
Thank you! 