Is there a way to send an email to the student with the result of his exam that is easily understood?
In fact, I saw that it is possible to send an email to the student, who can enter their email in a special field, but then the email that arrives is very difficult to understand because the data is in json format or other format. Instead.
I would like the student to receive a comprehensible e-mail with the data ordered within it or a google sheet directly, with the fields ordered.
Is it possible and in what way?
thanks for the precious collaboration.
Please choose an appropriate sub-category to post your question or topic.
I made the copy of your google sheet and the deployment (I insert my email).
I just didn’t understand how to make the user insert his email before or at the end of the quiz so that he can receive the result of the quiz in the beautiful formatting you prepared.
Can I ask you the courtesy of sending me a sample template so it is easier for me?
Can I also ask you if instead of sending the email there is a system where the user presses a button and downloads the result of the quiz in pdf?
(with your template SendReportEmail.approj), and change the email with my email, I got the test result with your nice formatting in my email and recorded in the google sheet.
However, the email did not reach the potential user who entered in your template (SendReportEmail.approj).
I have tried with your excel sheet
and the messages arrive to user, but without the nice formatting.
I noticed a difference in code between the two google sheets.
Can you please check and make sure that the first template with the beautiful formatting allows you to send the email as well as me to the user with the beautiful formatting?
Please remove the first line of the script in “Email Data Formatted” Google Sheet. Then add var TO_ADDRESS = name; // Email to receive the report data
to the line after var name = report["UserID"];