Embedded Files
This live demo is a simple, sample workflow automation, as a "moderated forum" for public submission of feedback -- featuring public approvals too, via triggered Google Apps Script. All this is based on just a few free Google Apps Tools -- 2 spreadsheets, one of which is for "limited-access workflow", via a "Google Form" for public input, and automated via a "Google Apps Script" to sort the submitted feedback as top-down -- and, most important, to immediately copy each approved feedback onto a 2nd spreadsheet (for public display within "all approved feedback"). Here are the stages, with steps below (and screenshots of vital settings, further below)...
Step #1 - Via this Google Form, submit your "new feedback", in the role of any "Public User".
Step #2 - Via your browser, reload/refresh this webpage, to see your newly submitted feedback appear here, in above workflow spreadsheet (which is public here, for this demo -- but would normally be a private hidden spreadsheet, available to only those users set for the "Approver" role. ).
Step #3 - Just open this public spreadsheet, to adopt the role of "Approver", via the next step -- namely, to take action to approve or not approve each submitted feedback, for public display...
Step #4 - In the opened public spreadsheet, in the "Approved?" column -- to approve, just replace the "pending" with "ok" (or, with any other value, which will mean "not approved"). Note: each of your edits will trigger an automated script to scan all submitted feedback -- and for every "ok" in the "Approved?" colomn, to copy that feedback into a separate "All Approved" spreadsheet (and also reset your "ok" to "public", to avoid duplicated processing)
Step #5 - Via your browser, reload/refresh this webpage, to see the results of your actions as an Approver -- specifically, you will see appear here all the feedbacks you set as "ok", in the previous step.
Note: since this demo is a minimal implementation, duplicated feedbacks are possible in this public display -- this will happen whenever an approver resets a PUBLIC feedback back to "ok", again -- re-triggering a new PUBLIC and duplicated "feedback".
Note: here are my "Shared Settings", to allow public users to edit the submitted feedback, and also immediately fire the "On edit" trigger and assigned "google apps script" function (see details below) -- to process approvals for public display of feedback...
My trigger settings - to allow edits (by public users) to fire my "On edit" script function:
And, here are my notification rules -- to monitor this public spreadsheet:
Similar applications, with helpful details...
Page updated
Report abuse