I have a specific use case currently using Google Forms, Google Sheets, Google Docs and Appscript to tie it all together.
Most of what I want to do can be done using Appsheet except for one thing.
I have a Google Doc template that gets information added to it from the form using tags. However, instead of sending that Document as a PDF, other things have to happen to it after it has been created.
My Apps script creates the Google Doc and populates it. Then, it adds the User who filled out the form as an editor, adds another specific user and then gives that specific user Ownership of that document. Giving Ownership triggers Google’s own email system to say you have been given ownership of the doc, so that specific user knows that another behaviour event has happened and can begin their own workflow with regards to that specific document. Also, my script then emails the user who filled in the Google Form and attaches (just a share really, not a physical document) the newly created document with some boilerplate text informing that user to share the document with all staff involved in the incident. And, finally, my script removes myself as an editor of the document so I don’t have access to it anymore.
Appsheet could possibly add these workflow actions? Specifically, options for Sharing templated documents in original format, adding users with specific access (edit, comment, view), giving Ownership of created documents away and so on. Is it possible?
The document by the way is part of a pupil behaviour system that gets generated when physical interventions happen. The document has input from multiple staff involved with the incident and document collaboration is amazing for this task. PDF will not be suitable in this case.