I’m evaluating Grist as a potential backend/CMS for several organizations, who naturally use spreadsheets for organizing their content.
The main challenge I’m encountering is lack of an editor — a place where users can enter blog post-like content (e.g. plain text, markdown, some HTML support for embeds), and see that nicely formatted and previewed.
Has anybody figured out a way to do this — enable less-technical users to create blog like content, and save it in Grist? This workflow could potentially incorporate other tools besides Grist as well (e.g. standalone editors, where you could type and preview the content, and then paste it into a Grist cell.)
Could a widget support something like this?
As a potential feature for Grist, one potential approach — you could have a “content preview” type for a column. When a column is set to that option, clicking inside a cell could open an editor pane and a preview pane (which shows a rendering of the content in editor). Perhaps you could select how the editor should render previews of the content (e.g. Markdown, HTML, Plain Text). So the flow would be:
- On a column with type “content preview”
- You click into a cell to edit
- That opens a modal or a new page with an editor and a preview pane (and perhaps the ability to select between Markdown, HTML or Plain Text preview)
- You can draft your content in the editor pane, and see the rendered preview in the preview pane
- When you are satisfied with the rendered preview of the content, you can hit “Save” and that enters the content from the editor into the cell that you were editing.
As a bonus, imagine if you could also configure a css stylesheet
setting for a column like that (maybe at the table level?). And then the preview pane in the editor would render the drafted content with the configured styling, to give an accurate representation of how you can expect the content to appear on your site.