A much-requested feature is now live: Grist Forms! Build forms right inside a Grist document and share with a click. Since the form fields come straight from Grist columns, all your data is piped directly into the correct structure, organized and ready for analysis.
Design forms visually within Grist
Preview, publish & share with a single click
Analyze data in real time
But we’re not done here – we’re continuing to add features to Grist Forms. We want the best data tool to have the easiest way of collecting data. We’re also collecting feedback – either by replying here or on the Grist Discord server. You can also fill out our top secret and VERY META Form Feedback Form.
Excellent. Since I was not able to join the discord server, let me post some feedback here.
1 - formulas, etc, don´t work in the forms. So if I have a field where user must give a number, another field where he gives another number, and a field that calculates the multiplication between the two, the result won´t appear. I guess that’s because the form was still not saved, but showing some results would be very important, even if the results stayed VIRTUAL until the form was saved.
2 - It seems colors, both conditional (depending on field context) and field formatting are not available.
3 - It seems you can’t use a form unless you go to it THROUGH a link? I think the good thing about FORMS is that you have to SUBMIT the answer. But that would be good independent of having it as a widget or accessing through a link
4 - putting fields side by side, just like in cards, instead of ONLY one after the other, would be nice.
5 - it would be interesting if titles, descriptions, etc, could be added, aside the standard ones
edit: oops it seems number 4 and 5 already exist if you click the + icon.
Just a little improvement here… the fields would be better arranged if they were top aligned by the field itself. They are right now aligned by the top of the field name. So different lenght field names push the fields below them out of alignment.
Re: the formulas feedback, that’s interesting. Can you explain a use case where showing the results of a formula based on inputs in two other fields is useful? Could help me in thinking about the future.
For #2 and #3, yes that’s in our roadmap! Great things to have.
Departments and process owners much access the risks under their responsability, so we have a Risk Directory / Risk Register
An important activity in the process is to analyze the risk’s PROBABILITY and IMPACT. The multiplication of one for the other gives you the Risk Rating.
(this is the initial risk analysis, depending on the controls existing and your decision on how to manage the risk, you may have to analyze that same risk again in a given time frame, or you will execute an action plan to mitigate the risk and re-analyze the risk to access if it was mitigated, etc.
Anyway, giving forms to the the users will guide them better through the process than the usual cards.
But when users select the different Probabilities and Impacts, it should automatically calculate the Risk Rating.
Anais, nobody ever answered this suggestion I over 1 year ago. I would love if someone from the Grist team replied, even if the reply was “this is a pathetic suggestion”, or “it’s interesting, we will put on our roadmap to 2030”.
I think the forms only appeared on Online Grist a few days ago, not at the start of the month. I will check it out anyway (but I think the experimental plugins flag is already on)
edit: as I said I would check it out anyway, I did turn the experimental plugins and they are really there. Thanks.
Ha, that was meant to be a continuation of “We appreciate your feedback.” to show that the confirmation message can be customized, but it doesn’t really make sense. I’ve updated it to make more sense, thanks for the heads up!
I don’t know anymore if I had seen this We appreciate your feedback message this referred to. At least it didn’t raise any attention. Glad being able to help making things more accessible for all.
The name field was consistently omitted, and multiple choises where stored as some kind of object or string. Never seen anything like it. For comparison the other dimension: