Grist | The Evolution of Spreadsheets

[Aizat]

Hi, I think some of you may have heard of this app before: Grist [https://www.getgrist.com/](link url)

. It's like Airtable + spreadsheet alternative. I have used the cloud version for a while now for serious work, and I like it so far.
They adopt an open-core model: [https://github.com/gristlabs/grist-core](link url)

There is a functional docker image available. For making it public it needs a sign in services which I think Cloudron already has established? Perhaps abit more work than I would imagine for Cloudron team, but it might be totally worth it.
Would be lovely to see such app coming over to Cloudron in addition to Typebot. These two are quite polished as it is.

Thanks!

[timconsidine]

@Aizat apologies for not doing my own research, but just wondering whether this offers more than NocoDB or Baserow which are already here in Cloudron AppStore ?

[Aizat]

@timconsidine pretty much yes, full python and excel formulas are supported, and you can have graphs and charts inside it without any difficulties or external app like metabase. Also REST API support makes it easy to integrates with other apps. Its designed a little bit different than the usual Airtable alternatives. You have to try it to know what I mean.

[timconsidine]

@Aizat ok, thank you, that's good motivation !

[Aizat]

@timconsidine Thanks for the enthusiasm! Happy to share.

[marcusquinn]

Just seen this - looks very nice!

• https://templates.getgrist.com/doc/afterschool-program
• https://templates.getgrist.com/doc/lightweight-crm
• https://templates.getgrist.com/doc/investment-research

[Aizat]

@girish hey! What do you think about this app? Not sure how it will be packaged or the amount of work required in order to have it here, yet how feasible is it for packaging this app for Cloudron in your opinion?

[ApplegateR]

@Aizat +1 this is amazing and clean on webgui!

[robi]

This looks pretty straight forward to package as a TS node app with a Python 3.9 component.

There is a nice list of files to copy for each in the Dockerfile as well as a set of configurable paths and environment variables for tuning to Cloudron app needs.

If you care to give it a stab, it will help @staff get a head start to get a package to the app store for testing.

[timka]

So is this like baserrow alternative with additional diagrams?

[kymj8]

This week I noticed this new feature in Outline which has been here in the App Wishist category:

• Added support self hosted Grist

I have been running Outline for 3 months (on a service similar to, but not as refined as Cloudron). I did do a quick test of embedding a Grist table -- not selfhosted -- into an Outline wiki post.

I am not capable of testing the selfhosted version not sure if either of these apps is the way I want to go long term. (If it is not on Cloudron, under a domain I have, getting safely backed up in a way I can recover or extract my data, it might as well not exist.)

I see above where @Aizat said in Grist | The Evolution of Spreadsheets:

Also REST API support makes it easy to integrates with other apps.

This part does sound promising. My goal for years has been to embed some simple table data with sorting/filtering in a blog post, web page, wiki/PKM tool, etc., and update that data elsewhere.

Baserow and NocoDB are already here on Cloudron. This is an exciting category.
As seen with the OIDC supported apps here, integration can bring a lot of value.

[timconsidine]

Thank you to @kymj8 for 'reviving' this topic.
Definitely would be a good addition to Cloudron.

And for those who can't wait or want to try it, I notice there is an Electron desktop app : https://github.com/gristlabs/grist-electron

[Sam_uk]

I gave up on Baserow when I realised any user could delete all the data (by design) https://community.baserow.io/t/protect-users-from-deleting-table-and-or-database/1282/10?u=sam_uk

Been playing with Nocodb which is OK, but I don't love it.

Someone mentioned this too me today, so here I am bumping it.

[jdaviescoates]

@Sam_uk said in Grist | The Evolution of Spreadsheets:

I gave up on Baserow when I realised any user could delete all the data (by design) https://community.baserow.io/t/protect-users-from-deleting-table-and-or-database/1282/10?u=sam_uk

Until, of course, you're on their Advanced plan which is $20/user/mo https://baserow.io/pricing (that's more for one user than the cost of Cloudron when paying annually!)

[ianhyzy]

I've been using their cloud version and it's great - much nicer than baserow or nocodb.

[jdaviescoates]

Now we've got Outline which integrates with Grist, I really want Grist too!

Screenshot from Outline:

[jdaviescoates]

This post is deleted!

[avatar1024]

I agree, I also think this is looking much more user friendly than both Baserow and NocoDB so it could be really useful to have (+ as @jdaviescoates pointed the Outline integration which would be fantastic to have). Looks like the future to me

[walski]

I've a version of Grist running on our Cloudron as well. It's using OIDC through oauth2-proxy (https://oauth2-proxy.github.io/oauth2-proxy/) but needs a bit more polishing. E.g. I've disabled Grist's sandboxing, which I want to fix.

Word of warning: The performance so far is not mega great in my preliminary testing. Feels quite sluggish on our little box.

[jdaviescoates]

@walski said in Grist | The Evolution of Spreadsheets:

I've a version of Grist running on our Cloudron as well.

Great stuff!

Add it to a repo to the Cloudron GitLab?

@walski said in Grist | The Evolution of Spreadsheets:

our little box.

How little?