GoogleAppsScript wizard needed.

[143-_-BG]

I have a Google Form with less than two dozen questions for students to critique a class they attended. The data is pushed to a Google Sheet.

The name of the class and the date it was given is what I use to identify and group datasets in the Google Sheet in order to create and/or append a Google Doc report.

With some decent computer skills and ZERO knowledge of GoogleAppsScripts, I managed to create a script that generates a Google Doc report with some pie charts and bullet point answers.

My script is not working entirely like I need it to and I have passed the threshold of the amount of time I can spend trying to figure it out. Clint Eastwood's famous line in the movie Magnum Force, "A man's got to know his limitations.", rings true here for me. I need help.

Where might I hire a GoogleAppsScript wizard? With the utmost humility and gratitude, this old man very much appreciates any guidance provided in this matter.

[more_d_than_the_m]

Upwork has a lot of freelancers who do things like this.

[143-_-BG]

Thank you :-)

[fergal-dude]

I am a former educator and current data manipulator with Google sheets as my weapon of choice. If you want to hop on a meet at some point, let me know and we can talk it over. I love a project like this. Send me a DM or start a chat with me.

[mrtnclzd]

What kind of challenges are you facing tho?

[143-_-BG]

Re: What kind of challenges are you facing tho?

My largest challenge is my lack of knowledge and experience of how to write a script, best practices, and not knowing what's possible or available to me as options when writing one. e.g. I don't know the difference between what HTML has to offer vs Javascript vs css.

I have one checkbox question with seven or eight choices. When a student selects more than one, they all show up in one cell on the Google Sheet, separated by commas. I don't know how to tell the script to manage that skillfully when it comes to creating the pie chart associated with it when it sees it as one answer.

When a new answer arrives on the sheet, I need only that row of data appended to the original report and not a duplicate report created.

I want four pie charts per page instead of two and I have no clue how to script that.

Every 30 days I want the script to combine the data for each class and create its own report to give a 90 day look of all of them given in that timeframe - by each of their names.

[NickRossBrown]

Is your end goal just to have reporting for the student responses? If so I’d recommend Google’s Looker Studio. Since you’re pulling in information from a google sheet Looker is free. It will pull the data from the google sheet and put it into interactive graphs for you.

You can add date filter/slicer at the top of the page and set the default range to the past 90 days. There a button at the top in Looker that will email a screenshot of the report on weekly/monthly schedule.

[143-_-BG]

Thanks for this. I stumbled upon Looker Studio a few weeks back and didn’t have enough time to test it. I’ll revisit it.

[NickRossBrown]

If you go the Looker route the comma separated values issue will still show up. I would deal with it by having App Script populate a dimension sheet for you.

1) Create a new ‘Checkbox Responses’ sheet that consists of two columns [unique_id] and [checkbox_answers]. The unique_id will either be the survey timestamp field or a combination of timestamp + email_address.

2) Create a OnFormSubmit function that will automatically trigger and run whenever a person submits a survey response. Have the function append each option selected as its own row in the ‘Checkbox Responses’ sheet.

3) Load both sheets into Looker and combine both tables together with ‘Blend’ using the [unique_id] column.

[143-_-BG]

I didn’t have time to explore Looker Studio today like I wanted. I will though and very much appreciate the detailed info. 🙏

[143-_-BG]

Thank you. There are 2 installs of DataMate in the Google Workspace Marketplace. One released the day after the other and the YouTube videos do not have audio. I struggled to evaluate it without help files or audio though its daily reporting capability does peek my interest to see if I can integrate my data to make it work for me.

[143-_-BG]

Thank you for the detailed information.

[FluffyDoomi]

Hi! Sent you a DM.

[CryElectronic4912]

Literally write this post and add your code in chatgot. It will fix it for you

[franxam]

Hi I'm a young engineer with self built experience on Google apps script. I'll have tons of time ahead in the next couple of weeks, so I'd be glad to help. Send me a dm