Create graphical report from Google spreadsheet, separate methods to access report, and send reminder
$30-250 USD
Paid on delivery
Overview:
---------------
1 - Report Generation
---------------
- I have an online Google survey that users fill in.
- The survey reports result to google spreadsheet.
- The results for each answer set (row) need to be parsed into a report.
This report should open in a new browser tab, possibly as a Google doc, or perhaps in HTML form that will scale to any size screen. (Developer's choice as to format - more discussion needed.)
- The report will repeat back questions and answers and a graphical representation of accumulated answers will also be created.
- The numerical answers (1-10) of each question will determine the font of question in report.
- The numerical answers will also format a bar graph, with for each group of answers. The color, shading, height, and transparency of each bar graph will be determined by the set of answers, using very simple math.
- An additional Threshold control, which will allow users to filter out all answers below X (a digit 3-9) should be available on the report.
- A comparison report, using the same formulas will create a combined chart with bar graph from a previous taking by the same user.
-------------------------------------------------------------------------------------------------
2- Save and remind Module
----------------
- Report will have a 'save and remind' module which will allow user to save the report to their device and to receive an email reminder at future date to re-take the Quiz.
- This module will require the addition of a date field to the spreadsheet, and a auto-running scan that will scan the entered dates and send the pre-formatted email.
-------------------------------------------------------------------------------------------------
3- Separate method to access reports (Superuser Module)
--------------
- A superuser module is needed to choose and create, using the same formulas and methods already created, single date and comparison reports on any already saved user.
--------------------------------------------------------------------------------
Open questions:
- Security and ID: How to identify users while keeping their data personally unidentifiable.
- What is the best format in which to present report. I will need the ability access to change non-programmed features - (pictures, descriptions etc) in the future. (Wordpress a possibility?)
Full design doc attached.
More detail on SuperUser Module.
The SU module will
1- search through all names (rows) to select a name
2- show all dates that the corresponding name filled out the form
3 - choose 1 or 2 of those dates
4 - create a single or comparison report based on the dates.
The report will output using previously programmed methods, so no new criteria need to be added to the reports.
Project ID: #10192130
About the project
Awarded to:
Hi drRobert, thanks for letting me know that you have re-opened your project. So, here's my bid. As far as I could understand you want to generate the report from each google forms answer, and also create that e-mail r More
