I do that for my covid testing app. One GS (Google Sheet), and several linked Glide Tables (GT) between the apps.
You can have functionality split between the apps. In my case the user might start doing a test - setting columns in a row in a sheet… and then the agent app is waiting for a condition ‘ready for call = true’ to display something.
Things to watch out for:
- computed columns are NOT shared between apps - only the basic columns
- usc-columns are obviously just for the user on that side of the app (you can handle this between apps if you use buttons with ‘set column’ actions to copy data in and out of rows and tables)
- each app can have separate User Profiles (and row owners different between the apps) — in mine I have CollectUser for the user app, Agents for the agent app, and SystemUsers for the Admin app
- try to avoid using GS for anything that might require fast access - there is a lag between reading and updating GS data. I started with GS but moved to GT to resolve time lag issues (for my special app).
The auto-generated sheets from Glide are still there - App:Login / App:Comments, etc. It is not brilliant ---- it turns out that App:Logins is the same sheet for different apps… which means that, if you have a T&C doc they ‘signed’ you cannot tell automatically which person signed in which app (if you need this).
Personally, I love having the same sheet - and the shared Glide Tables. It makes some magical apps possible!