Assuming that you’ll be using a Pro App, we now have the Glide API available. So it’s relatively easy to push data directly to Glide, or update existing data using something like Integromat.
Also, we can now add a Google Sheet to a project that was started with Glide tables only. So that’s no longer a concern.
You mean computed columns vs sheet formulas?
Speaking for myself, I almost never use sheet formulas. It’s very rare that I find that I can’t do something with computed columns that I would have previously done with sheet formulas.
In terms of pages vs apps… I’ve only recently started working with pages. In general I like them, but they are missing some features/components that we kind of take for granted with apps. Although I expect that these (or similar) features will be added over time.
Personally, I think the main decision driver in pages vs apps should be the end user demographics. If most of your users will be on desktop, then use pages. But if most of your users will be on mobile, then use apps.
Just FYI we recently built a pretty functional CRM using Pages and Glide Tables. It works really well and I think you’ll be happy with what you can produce. I would say that the only things causing us a minor issue were:
Inability to “group” lists of data (so you have to work around with multiple collections)
Information density is a bit too low (we used collections in table view but still struggled)
We also use the Glide API to add data from an external source and that works perfectly. Overall it’s a snappy and pretty impressive combo.