I personally only use Glide table for now… but if i want to have 2 separate apps that use same tables, can Glide table do sync for both apps with the same data table? Or i need to use air table or google sheet?
I build most Apps using native Glide Tables. In the past I also built a lot of Apps using a Google Spreadsheet as a data source, but I generally avoid that these days.
Reasons why I might connect a Google Sheet:
If I need multiple Roles per user, I will use a Google Sheet as the source of the User Profiles (only because native tables do not support this)
If the data needs to be used outside the Glide App, and the plan I’m working with does not have API support.
If there is a 3rd party integration required that either can’t be done with native tables, or is easier done with Apps Script. (Sometimes I will use a Google Sheet purely as a place to host code, without actually connecting it to a Glide App).
I’ve never used Airtable as a data source (or at all).
I’ve never used Excel as a data source.
I’ve not (yet) used any SQL data sources, but I can foresee this in the future.
You can have as many Apps as you want sharing the same data source - regardless of the data source.