Grist | The Evolution of Spreadsheets

[walski]

Ok turns out, that Grist releases after Sept. 11th come with a broken pyodide sandboxing layer (see https://github.com/gristlabs/grist-core/issues/734).

I got everything running using an earlier Grist release (1.1.4 from Sept 8th or so). Before this can be considered for the app store I need to polish the metadata, etc. But you should be able (we do) to install it to your Cloudron using the CLI.

Repo is here: https://git.cloudron.io/walski/grist-app

How little?

16GB RAM, 6 core AMD whatever virtual server. Currently running 13 apps through Cloudron.

[jdaviescoates]

@walski said in Grist | The Evolution of Spreadsheets:

16GB RAM

Yeah, that's not much RAM really (especially if you're running some RAM heavy apps), so possibly not surprising it's running slow. I wonder how it'd be if you had more resources... I guess once that issues is resolves and we get it into the Cloudron App Store we'll find out!

Thank you for your efforts, much appreciated

[walski]

Side-note: Looks like direct OIDC support just landed on Grist's main https://github.com/gristlabs/grist-core/pull/717

[plusone-nick]

@walski if its not DNS its RAM

[kymj8]

Grist is now available for YunoHost. It was announced in the Grist Community November 2023 Newsletter.

Looking for a simpler way to self-host Grist? Florent has also packaged Grist on YunoHost, a Debian-based OS designed to help democratize self-hosting. Check out Florent’s post in our forum for more information.

The post:
Self-hosting Grist made easy with Yunohost
https://community.getgrist.com/t/self-hosting-grist-made-easy-with-yunohost/3692

In the YunoHost Application Catalog:
https://apps.yunohost.org/app/grist

And on GitHub.
https://github.com/YunoHost-Apps/grist_ynh

This seems like a good sign for us here.

[walski]

Yip, they released v1.1.9 on Dec 2nd. That release includes the pyodide fix to run Grist sandboxed within Cloudron, as well as their direct OIDC support (see docs: https://support.getgrist.com/install/oidc/#openid-connect).

I'm more than happy to incorporate these onto my branch and that should then give us a decent to maybe get it into the app store? I just can't promise a timeline right now

[seeker]

New release highlights below.
I like that there is a desktop app. Has anyone been able to play with it. I assume it integrates with the cloud app? Sometimes it is nice to be able to take things offline.

Released: Grist v1.1.11
Highlights from recent releases:

Forms - design forms and surveys right within Grist and watch the data roll in live. Each field is automatically tied to a spreadsheet column so analysis is super simple. https://www.getgrist.com/forms/

New calendar widget for displaying dates. https://support.getgrist.com/widget-calendar/

Advanced Chart and JupyterLite Notebook custom widgets - very powerful for advanced dataviz and Python work.

https://support.getgrist.com/widget-custom/#advanced-charts
https://support.getgrist.com/widget-custom/#jupyterlite-notebook

Formula lookups and shortcuts for adding common formulas and lookups. https://support.getgrist.com/newsletters/2023-10/#formula-shortcuts

Record cards that make it much easier to navigate and edit referenced data (a huge part of what makes Grist useful). https://support.getgrist.com/record-cards/

GitHub repo: https://github.com/gristlabs/grist-core
Grist overview: https://www.reddit.com/r/selfhosted/comments/su6tv3/grist_free_open_source_alternative_to_airtable/ Interactive demo (no login required):
https://docs.getgrist.com/

[robi]

@walski said in Grist | The Evolution of Spreadsheets:

Repo is here: https://git.cloudron.io/walski/grist-app

How's it running these days?

Have you added the easy-install.sh script yet?

[seeker]

Just discovered grist has two pages of webinars that could be helpful for onboarding. Getting people to use tools... videos are helpful.
https://www.getgrist.com/webinars/

[jc147]

Hello, is there any progress on the integration of Grist with Cloudron? I can't wait for this to happen!

[jagan]

The addition of AI to grist to query data in natural language is a game changer - creates the python code needed and no-code developers can create all sorts of reports, graphs and charts.

Others will catch up ultimately, but for now, Grist is ahead.

[jdaviescoates]

@jc147 said in Grist | The Evolution of Spreadsheets:

I can't wait for this to happen!

Yeah, it'll be great to have Grist and to be able to integrate it with Outline!

[avatar1024]

Hello, I wonder, is anyone is working on this? Seems like grist is ahead of the others regarding what it offers in the self hosted version.

[umnz]

+1 also take my upvote for Grist. A solid alternative to Nocodb.

[SamGreenwood]

+1 also think this would be great

[jdaviescoates]

@SamGreenwood upvote the original post

[marylou]

OMG, Grist looks amazing!! It looks like it shows referenced (aka linked) data values rather than just "2 linked values" as Nocodb does. And it comes with granular access rules. And it supports most Excel functions?? I would like to hereby add ten votes.

[cstork]

Yes, definitely interesting. Maybe finally a feasible replacement for some google sheets of mine...

[firmansi]

Hopefully this will soon running on Cloudron

[marylou]

I took a closer look at and tested the free version of Getgrist today, and I found it to be significantly more advanced than BaseRow and NoboDB. It offers features such as duplicate detection, complex formulas, access rules, and conditional formatting, all within the free version. It is also noticeably faster. I can't wait to make the switch and hope to see it on Cloudron soon.