A while ago we did an experiment with AI to see how it could help Grist users with formulas. We’re excited to announce the experiment is now a feature in an integrated AI Formula Assistant!
TLDR:
Using plain language, chat with an AI assistant to help create Grist formulas.
Grist sends the necessary context, so there is no need to describe your data’s structure.
Because the AI Assistant makes use of Grist’s structure, we strongly recommend reading this quick list of best practices.
All Grist accounts get 100 credits for free – so you can test out the assistant right now! Pro plans include 100 AI Assistant credits per month. The credits automatically top up to 100 every billing cycle.
Interesting. I have used quite a lot ChatGPT4 with Grist to create some formulas.
Many times it struggled with Grist syntax, etc. Many times it wanted to use different libraries, etc, because it was not aware of Grist as a web “no code” app.
Does the formula assistant provides “context” of Grist, Grist formulas (when different from Python) etc?
How long until formula assistant is available to Grist Docker Omnibus?
Yes, the assistant provide context to help avoid the exact issues you describe - mostly in the form of the data’s schema (visible in Code View). More info here.
The assistant should be available to Omnibus users this Thursday, and you can connect by setting the OPENAI_API_KEY env variable (more info here).
Independently of an AI Assistant existing, I insist that allowing users to COPY the error messages to paste them to ChatGPT (I am a plus user, but I don´t have an API key to use with Grist) would be awesome
Like here… I want to paste that error to ChatGPT instead of writing everything (ps, no need to help me with this formula… I used = instead of == on purpose to generate the error… the point was showing how counterproductive is to TYPE the error message to ChatGPT when you could just allow us copying it.
Separately, you could get an API key at OpenAI Platform if you wanted, it is pretty easy to do. It wouldn’t be covered by your ChatGPT plus subscription I believe, but (1) you’d be charged only for usage, (2) the charges are low, and (3) you can monitor them.
Ok, what we have now is Grist AI Assistant to formulas, so only EDITORS or OWNERS, people with permissions to change structure can use it.
I wonder if in the future we will be able to also use AI to analyze the data, help fill fields, etc.
But in THAT case, if that ever happens, there should be a way to MODERATE the use, like what users can use it and where, so you won´t have users spending all credits in anything.
Free grist user here, but planning on the pro account. im just about out of my 100 free AI calls. I love the ability to use AI for formula creation. However i end up modifying my question over and over to see what it comes up with so i knew i was going to run out fast. Now i’m realizing that the pro account only has 100 per month as well. i know that while i’m creating and learning i’m going to use it up fast. I really wish this was unlimited or there was a way to get that, i can see in the beginning i would use more that later in the project. This makes your product so appealing to us who dont know python. and a big advantage over other platforms. How can i get more?
Happy chatting!
