SumoAMGQ: Hi, These "pythonized tables" look like a fresh approach...
1. Can python scripts be "scheduled" to run at certain times/intervals, or on new data within a column? Or are they executed like excel formulas?
I will study Grist more, but any hints would be helpful.
2. Looking at the invoice template.
https://public.getgrist.com/fGBhgyJbcFbr/Billing/m/fork
I can see the "print" button, but can Grist produce bulk *downloadable* word docs or pdf's from a set of data and a template?
I'm thinking similar with merge mail list, but obviously much more powerful due to the fields selection, pre-conditioning etc - whether multiple files, or single file with multiple updated pages - would be great if doable.
3. Can Grist tables /views etc be embedded as iframes in my website?
If so, perhaps a domain whitelisting system would be needed as well...
4. Can a Grist cell interpret html/css/js code?
5. (related) Can I embed an iframe inside a Grist cell?
6. The 100,000 rows per table is impressive in itself, but can Grist formulas/python scripts work (refer to) multiple tables?
There are situations when less rows per table, but multiple connected tables are needed.
7. Sorry to bother again about CNAME, but to exclude any future misunderstanding - will CNAME be included for all tiers, for free? Or will I have to pay extra to use my domain?
Thanks
Anais-Grist
May 15, 2024A: Thank you for your questions!
1. In Grist, Python is mainly used for evaluating formulas. You may also trigger formulas to a run when a new record is created, or when a record is updated (either when any field is updated, or specific fields). Learn more about trigger formulas in our help center. https://support.getgrist.com/formulas/#trigger-formulas.
We are also considering adding workflow/automation features. You may join the discussion in our forum: https://community.getgrist.com/t/grist-workflows-researching-use-cases/44
To some extent this is already possible using Custom Widgets (using Javascript). Learn more in our help center: https://support.getgrist.com/widget-custom/#page-widget-custom
2. Yes, you could do this with custom widgets! It would require some web development. If you need more help, reach out in our community forum. It might be fun to create a thread for this there that others could also learn from. https://community.getgrist.com/
3. Not yet, but we do have embedding support on our roadmap. You may track our progress here: https://github.com/gristlabs/grist-core/issues/66
It would be very helpful if you could describe your use case for embed + domain whitelisting. If you're inclined, please share those details either as a comment in the link above (if you have a GitHub account), or in our community forum in the Feedback section.
4. The cell cannot, but you can use custom widgets to interpret data in cells with code.
5. You can embed an iframe inside a custom widget.
6. For clarity, the ~100k rows limit is per document, not per table, though that limit depends vastly on the type of data in the document. You may learn more about limits here: https://support.getgrist.com/limits/#limits And yes, formulas can refer to multiple tables within the same document, but not to other documents.
7. We haven't made any decisions yet about pricing, but there will likely be a small additional price.