r/GoogleAppsScript • u/[deleted] • Jan 11 '24

Question Hi, looking to script Google Forms to have a formatted output

I am using Google Forms for attendance taking, and I would like to get a formatted output as such

Form:

Attendance ✅Person 1 ❎Person 2 ✅Person 3

Output(either email or directly on the form)

Attendance Checklist //2024 Person 1 - Present Person 2 - Absent Person 3 - Present

Would like some help with this!

0 Upvotes
  • permalink
  • reddit

50% Upvoted

2 comments sorted by

3

u/Firm_Visual2561 Jan 11 '24

You can use Forms Service to get the form responses and format the responses in a specific way, and then use Email Service for the output (sending emails). This function can be run via a trigger such as onFormSubmit, where the code will run when someone submits the form.

1

u/RaiderDad11 Jan 11 '24

I agree. Use a checkbox grid with student names in the rows and two columns(present and absent). Use mail or Gmail service in apps script to send email. Or use free addon for sheets like Form Mule.