MAX function You can use the MAX function to find the highest value in a set of give data. If you have added 3 fields Section A score, Section B score, Section C score in the form to calculate the section scores, then you can use the MAX(Section A score, Section B score, Section C score) to find the highest score of the three. TITLE function If you would like to find the field with the highest score, then you can use the TITLE and MAX function. TITLE(MAX(Section A score, Section B score, Section C score) The above formula will return the name of the field with the highest score. For example, if the calculate answer for Section A score field is 10, Section B score field is 15, Section C score field is 12, then TITLE(MAX(Section A score, Section B score, Section C score) will return Section B score as the answer. Note: You must type @ and select the fields from the list when adding the formula in the Calculate option.

Perfect. One more query, Can we send emails to all participants with the obtained results and congrats them?

Login to Formfacade > click on the form to open it > Edit page will be displayed > click Responses > click on the three dots icon next to the Submitted status > click Email respondents > setup wizard will be displayed > select the email field from the list and click Next (note: this email field must be a mandatory field in the form) > update the subject and click Next > update the message and click Next > click on the link to open the form and submit a response to test confirmation emails. When you set up the email notification using Formfacade, you can customize the subject and message as required. You can use the ${response()} formula to show a summary of all the answers (hidden fields will be excluded) or ${scoresummary()} to show the conditional thank you message setup based on score in the form. You can also click on the @ icon in the message editor and select the required field from the list to include it in the message.

How can I shuffled the questions each time?

It is solved thanks However, I want to send a specific massage through the email for specific highest score section. For example: if section B is the highest score a specific massage related to section C should be send in the email

Just to confirm, you would like to find the section with the highest score and then show a specific message for that section? Please share the possible results (different sections) and the corresponding messages.

I got it thanks, However I want to show the following massage in the email that will send to anyone will fill the form: "The College of Advertising has the followings specializations: - Advertising Communication - Advertising Management" New lines for each choice and in a bullet points.

Sorry, I want to send different massages according to their scores "the massage is different". I already have different massages and pick from them using IFS function, the issue is the what is including in the massage is just plain without using "new line" or any formatting.

In the form looks like" ""showcasing your exceptional critical thinking and reasoning abilities—skills essential for success in advertising studies. \n We invite you to explore your options at the College of Advertising as a first priority, where your talents can truly shine. \n The College of Advertising has the followings specializations: \n - Advertising Communication \n - Advertising Management \n - Advertising Creative Design. \n \n Furthermore the second priorities are: \n -Marketing program -CBA \n - Finance program - CBA" However in the email looks like" "Here are some major options for you to consider: - Software Engineering - Architectural Engineering - Electrical Engineering - Industrial Engineering - Mechanical Engineering - Civil Engineering - Safety Engineering" in one line

Form responses The text answer for short answer or paragraph question cannot be formatted, whether it is input by the user or calculated using a formula. You cannot use numbered or bulleted lists, make text bold, add hyperlinks etc. Confirmation message displayed on submit You can set up conditional messages based on the calculated score. Instructions below. Login to Formfacade > click on the form to open it > Edit page will be displayed > click on the gear icon next to the Submit button > Button settings page will be displayed > click On submit > select Show conditional message based on score and setup the messages. You can format the messages as required using the formatting options in the message editor. For detailed instructions, refer to the help article below. Conditional thank you message https://formfacade.com/calculate/add-verbal-assessment-conditional-message-based-on-calculated-score-google-forms.html When you set up the email notification using Formfacade, you can customize the subject and message as required. You can use the ${response()} formula to show a summary of all the answers or ${scoresummary()} to show the conditional thank you message setup based on score in the form. You can also click on the @ icon in the message editor and select the required field from the list to include it in the message.