Grist | The Evolution of Spreadsheets

[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.

[marylou]

@timconsidine @girish @nebulon
Are there any concrete plans to package Grist for Cloudron?

[SamGreenwood]

@jdaviescoates didn't realize how to until if already posted.