Application Name: Grist
Application Site: https://getgrist.com
Docker Hub: https://hub.docker.com/r/gristlabs/grist
Github: https://github.com/gristlabs/grist-core
Discord: https://discord.gg/MYKpYQ3fbP

 

Grist is a modern relational spreadsheet. It combines the flexibility of a spreadsheet with the robustness of a database to organize your data and boost your productivity.

Please post any questions/issues related to this Docker config in this thread.
For questions/issues about the Grist product, please visit the Grist support forum: https://community.getgrist.com

 

Update History:
- Feb 21, 2023: Updated XML Template to include a /persist directory
- Jul 10, 2024: Updated instructions for using a port other than the default 8484
- Aug 5, 2024: Added link for Grist's Discord community
- Mar 2, 2025: Added instructions for using ollama for Grist's AI Assistant

 

Custom Port Configuration (example uses port 9251):

1. Change WebUI URL: Update from http://[IP]:8484/ to your desired port, e.g., http://[IP]:9251/

2. Add Custom Port Variable:
     - Toggle Advanced View (upper right-hand corner).
     - Click "Add another Path, Port, Variable, Label or Device" at the bottom.
     - Add a Variable with the following details:
           Name: Custom Port
           Key: PORT
           Value: 9251
     - Click Add.

3. Update Container Port:
     - Click the Remove button for the existing Container Port.
     - Click "Add another Path, Port, Variable, Label or Device" and add a Port with:
           Name: Container Port
           Container Port: 9251
           Host Port: 9251
     - Click Add.

4. Save Changes:
     - Click Apply.

Local AI Assistant Setup on Unraid:
This guide shows you how to integrate a local AI assistant using two containers: ollama and Grist.

1. ollama Container:
     - Installation:
           * Install ollama from the Community Apps store in Unraid (using joly0's Repository).

     - Configure for Nvidia GPU:
           * In Advanced View, add:
                 Extra Parameters: --runtime=nvidia
           * Variables:
                 NVIDIA_VISIBLE_DEVICES: all
                 NVIDIA_DRIVER_CAPABILITIES: all

     - Install a Model:
           * Open the ollama container console.
           * Install a suitable qwen2.5-coder model for your hardware (e.g., the 7b model: https://ollama.com/library/qwen2.5-coder:7b).

     - Connection Info:
           * Note the container's IP address and port (e.g., 10.10.10.100:11434).

2. Grist Container:
     - Set Up AI Assistant Variables:
           * Model Variable:
                 Key: ASSISTANT_MODEL
                 Value: qwen2.5-coder:7b-instruct-q8_0
                 Tip: If you're unsure which model to use, open the ollama console, type "ollama list", and copy the desired model name.
           
           * Endpoint Variable:
                 Key: ASSISTANT_CHAT_COMPLETION_ENDPOINT
                 Value: http://YOUR-UNRAID-IP-ADDRESS:11434/v1/chat/completions

 

 

 

Edited March 2, 20251 yr by bonedrums

Should a share folder on a data drive be set up for persistent storage of working documents & to drop source data for using Grist self-hosted on an Unraid server? I would pefer to not use the appdata folder on my cache drive for document storage, and maybe there should be a preset option in the setup template for this. (I haven't really played with Grist yet, but it looks like a really  interesting app if you're a serious spreadsheet user.)

 

On 12/17/2021 at 9:42 PM, Shazster said:

Should a share folder on a data drive be set up for persistent storage of working documents & to drop source data for using Grist self-hosted on an Unraid server? I would pefer to not use the appdata folder on my cache drive for document storage, and maybe there should be a preset option in the setup template for this. (I haven't really played with Grist yet, but it looks like a really  interesting app if you're a serious spreadsheet user.)

 

It is a really cool app! For the most part, unless you have a document that has hundreds of thousands of rows with embedded media, the file sizes should only be a few Mb. I'll post on the Grist community forum though and see if there's something within Grist that will tell it to use a /data store for storing documents. I'll post back here and let you know what I find out.

On 12/17/2021 at 9:42 PM, Shazster said:

Should a share folder on a data drive be set up for persistent storage of working documents & to drop source data for using Grist self-hosted on an Unraid server? I would pefer to not use the appdata folder on my cache drive for document storage, and maybe there should be a preset option in the setup template for this. (I haven't really played with Grist yet, but it looks like a really  interesting app if you're a serious spreadsheet user.)

 

 

When running Grist using docker, you can tell Grist to store data files in another folder using a flag like -v <host-dir>:/persist, i.e. mapping some directory to be visible as /persist in the container.

I am not sure what Unraid’s method would be for creating such a mapping. I think it might only be a matter of changing /config to /persist in the Appdata line of unraid-templates/grist.xml at main · bonedrums/unraid-templates · GitHub.

You can see how /persist is actually used in grist-core/Dockerfile at main · gristlabs/grist-core · GitHub – in particular, you could override GRIST_DATA_DIR environment variable instead of remapping /persist.

The data files Grist actually stores are essentially SQLite files, both for documents and for the database with document metadata (/persist/home.sqlite3 in the docker setup). SQLite is totally happy to use spinning disks, and I don’t anticipate any issues with keeping data on those.

The only kind of data share NOT to try is a network folder shared by multiple independent Grist instances (not that I see any reason for anyone to do that). That pattern will not work: a Grist instance assumes that all changes to its data files go through that instance.

 

Seems like the right place?

Have any of you got Grist Omnibus setup/to work that includes some basic account management and login options? I have played with it; but some reason can't get it to load/boot. I think it's default Traffik thing built in.

https://github.com/gristlabs/grist-omnibus

2 hours ago, blaine07 said:

Seems like the right place?

Have any of you got Grist Omnibus setup/to work that includes some basic account management and login options? I have played with it; but some reason can't get it to load/boot. I think it's default Traffik thing built in.

https://github.com/gristlabs/grist-omnibus

Hey Blaine - I need to look into creating a second Docker installer in the App Store using this setup. I'll let you know once I get it finished up and provide some instruction.

2 hours ago, bonedrums said:

Hey Blaine - I need to look into creating a second Docker installer in the App Store using this setup. I'll let you know once I get it finished up and provide some instruction.

Oh, awesome! Thank you so much! Keep me posted - some basic login would be very nice. I don't need Traffik or any of that though; would rather use cloudflare or NPM. Thank you!

20 hours ago, blaine07 said:

Oh, awesome! Thank you so much! Keep me posted - some basic login would be very nice. I don't need Traffik or any of that though; would rather use cloudflare or NPM. Thank you!

I also use Cloudflare and NPM... working on a simple email login to share with the community. Thanks for reaching out! More updates to follow...

On 3/9/2024 at 8:11 AM, bonedrums said:

I also use Cloudflare and NPM... working on a simple email login to share with the community. Thanks for reaching out! More updates to follow...

Thats what I have here; Cloudflare Proxy and some stuff straight to service; some stuff through Cloudflare>NPM>Service. Quite literally can't wait! 🙂

 

On 3/11/2024 at 7:11 AM, blaine07 said:

Thats what I have here; Cloudflare Proxy and some stuff straight to service; some stuff through Cloudflare>NPM>Service. Quite literally can't wait! 🙂

 

No solution yet unfortunately Blaine. I've been working with the folks at Grist to try to resolve some issues. Will keep you posted and provide a new container in the appstore. It is working without Cloudflare/NPM just fine on its own. But I'm struggling to get it setup to get it going through NPM.

I recently installed the CA of Grist, v1.1.14, and can't get it to load the Admin Panel. I get this error:

09:31:43 window.crypto.randomUUID is not a function. (In 'window.crypto.randomUUID()', 'window.crypto.randomUUID' is undefined)

HTTPS is enabled on Unraid, however I"m not sure if that's the issue or not. I've tried setting APP_DOC_URL. and other suggestions but nothing works.

Any ideas how to fix? Thanks.

 

On 6/3/2024 at 1:00 PM, rubicon said:

I recently installed the CA of Grist, v1.1.14, and can't get it to load the Admin Panel. I get this error:

09:31:43 window.crypto.randomUUID is not a function. (In 'window.crypto.randomUUID()', 'window.crypto.randomUUID' is undefined)

HTTPS is enabled on Unraid, however I"m not sure if that's the issue or not. I've tried setting APP_DOC_URL. and other suggestions but nothing works.

Any ideas how to fix? Thanks.

 

Apologies for the late response. This one is over my head. Would ask that you take this to https://community.getgrist.com/

On 6/3/2024 at 1:00 PM, rubicon said:

I recently installed the CA of Grist, v1.1.14, and can't get it to load the Admin Panel. I get this error:

09:31:43 window.crypto.randomUUID is not a function. (In 'window.crypto.randomUUID()', 'window.crypto.randomUUID' is undefined)

HTTPS is enabled on Unraid, however I"m not sure if that's the issue or not. I've tried setting APP_DOC_URL. and other suggestions but nothing works.

Any ideas how to fix? Thanks.

 

FYI - A fix has landed in grist-omnibus and the latest version of grist-core. It’ll also be included in versioned release of grist-core (1.1.15). The latest current version is 1.1.16 so you should be covered if you updated. I found this information here: https://community.getgrist.com/t/forms-not-working-on-self-hosted-grist/5212/16

Has anybody been able to get Grist working with Keycloak oidc?

On 3/15/2024 at 8:26 AM, bonedrums said:

No solution yet unfortunately Blaine. I've been working with the folks at Grist to try to resolve some issues. Will keep you posted and provide a new container in the appstore. It is working without Cloudflare/NPM just fine on its own. But I'm struggling to get it setup to get it going through NPM.

Any update on this mate?

11 hours ago, blaine07 said:

Any update on this mate?

Hey Blaine, sorry for not getting back with you. I was not able to find a solution for this yet unfortunately. I setup a workaround for now using cloudflare's "Access" 2FA method just using my email address with a code that sits in front of the site.

 

Most of the Grist employees and a ton of other users are in their discord though and are pretty responsive. If you wouldn't mind taking a look in the self hosted channel https://discord.com/channels/1176642613022044301/1176643552864895127

 

There could be an answer in here, or if not start the thread! If I get some more time and find a solution I'll update and post a guide on this container thread in the unraid forum and in discord.

On 7/25/2024 at 3:29 PM, RSd108 said:

Has anybody been able to get Grist working with Keycloak oidc?

If you wouldn't mind elaborating on Grist's discord the good folks over there may be able to assist you with this! https://discord.gg/rEfwdHDk