Wow! These tools are getting closer and closer to the sweet spot. Here is my use case. I need to send a royalty report to authors and artists each month. The data is in Excel. I would like to be able to either send them a PDF REPORT, or make their exclusive data available in HTML behind a login.\u000a\u000aIs this some thing that can be done via your App?\u000aHow many users would this require. Let’s say that I have to produce 300 reports.\u000a\u000aThanks

Question

Anais-Grist · Answer

You can do this with as few as one paid seat and Grist\u0027s access rules built around link keys.\u000a\u000aAccess rules make it possible to determine who can see which parts of your data down to each column and row. Link keys are special URL parameters that tell Grist which parts of the data to show when opening a URL using that link key. So you would have a unique link key for each artist. The links would be generated and stored within Grist, too.\u000a\u000aYou can see a simple example that makes use of link keys, here: https://support.getgrist.com/examples/2021\u002D04\u002Dlink\u002Dkeys/\u000a\u000aA printable report is also possible with custom widgets. A custom widget can read your data then organize it in a templated PDF which you can export using Print \u003E Save As PDF, or print!\u000a\u000aWe have an example of a similar use case. Our invoicing template has a custom widget which builds an invoice in Grist.\u000a\u000aYou may view the template here: https://templates.getgrist.com/9NH6D58FmxwP/Invoicing\u000aAnd learn how to modify the custom widget here: https://support.getgrist.com/examples/2020\u002D08\u002Dinvoices/\u000a\u000aWe\u0027d be happy to work with you on getting it just right. 🙂

Grist

Share Grist

Related questions