Google Form Advanced

Customize Look & Branding in Google Form ?

🔹 Step 1: Open Your Google Form

• Go to https://forms.google.com
• Open an existing form or create a new one

---

🔹 Step 2: Click the “Customize Theme” Icon 🎨

• On the top-right corner, click the paint palette icon
• This will open the Theme customization panel on the right

---

🔹 Step 3: Change the Header Image

1. Under Header, click "Choose Image"

2. You can:

• Upload your own logo or banner
• Choose from Google’s default themes (education, party, work, etc.)

3. Click Insert

📝 Your header image will affect the theme colors automatically.

---

🔹 Step 4: Change Theme Colors

• Under Theme Color, pick your brand color or preferred style
• You can also select a background color

---

🔹 Step 5: Change Font Style

• Under Font Style, choose from:

  • Basic
  • Decorative
  • Formal
  • Playful

📝 There are no custom font uploads, but you can choose a style that fits your tone.

---

🔹 Step 6: Preview Your Form

• Click the eye icon (top-right) to see how your form looks to respondents

---

🔹 Step 7: Save and Share

• Changes are saved automatically
• Share your form via link, email, or embed it on your site

What is Conditional Logic (Go to Section Based on Answer) in Google Forms?

Conditional Logic in Google Forms allows you to send respondents to different sections based on their answers. This is especially useful for:

• Creating interactive forms
• Skipping irrelevant questions
• Creating quiz paths, feedback branches, or surveys with different flows

---

🧠 Example Use Case:

Question: What are you interested in?

• Web Design → goes to Section 2
• Marketing → goes to Section 3
• Something else → goes to Section 4

---

✅ How to Use “Go to Section Based on Answer” (Step-by-Step)

🔹 Step 1: Open Your Google Form

• Go to https://forms.google.com

• Open an existing form or create a new one

---

🔹 Step 2: Create Multiple Sections

1. Click the “Add section” icon (looks like two horizontal lines)

2. Add Section 2, Section 3, Section 4 as needed

3. Give each section a name and content (questions or text)

---

🔹 Step 3: Add a Multiple Choice Question

1. Add a question before the sections

2. Set the question type to “Multiple Choice”

---

🔹 Step 4: Enable Conditional Logic

1. Click the three dots (⋮) in the bottom-right of the question
2. Select “Go to section based on answer”

---

🔹 Step 5: Assign Each Answer to a Section

For each answer option, choose which section it should go to:

• Answer A → Go to Section 2
• Answer B → Go to Section 3
• Answer C → Go to Section 4

---

🔹 Step 6: Finalize and Preview

• Use the eye icon to preview and test the flow
• Make sure each answer goes to the correct section

What is the File Upload Feature in Google Forms?

The File Upload feature in Google Forms allows respondents to submit documents, images, videos, or other files directly through the form. These files are automatically stored in the form owner’s Google Drive.

---

🛠️ When to Use File Upload:

• Collecting resumes or job applications
• Uploading assignment submissions
• Gathering images, designs, or documents from users
• Collecting project files from clients/students

---

✅ How to Use the File Upload Feature (Step-by-Step)

🔹 Step 1: Open or Create a Google Form

• Go to https://forms.google.com
• Create a new form or open an existing one

---

🔹 Step 2: Add a New Question

1. Click the “+” (Add question) button

2. Change the question type to “File upload”

---

🔹 Step 3: Confirm Upload Permission

• Google Forms will ask:
  “Respondents will be required to sign in to Google to upload files.”

• Click Continue to allow

📝 Note: Respondents must have a Google account to upload.

---

🔹 Step 4: Customize File Upload Settings

You can set:

• ✅ File types allowed (e.g., PDF, images, video, etc.)
• ✅ Maximum number of files (1 to 10)
• ✅ Maximum file size (up to 10 GB per file)
• ✅ Folder in Drive where files will be saved (automatically created)

---

🔹 Step 5: Share Your Form

• Click Send, share the link, or embed it on your website
• All uploaded files will appear in the associated Google Drive folder and in Google Sheets (if linked)

---

📁 Where are uploaded files stored?

How to Create Quizzes with Auto-Grading in Google Forms

Files are saved in a Google Drive folder named after your form, under a subfolder called "File responses"

How to Create Quizzes with Auto-Grading in Google Forms?

Google Forms lets you turn any form into a self-grading quiz — perfect for teachers, trainers, or anyone who wants to test knowledge and get results instantly.

---

🎯 Main Features of Auto-Graded Quizzes

• Assign points to questions
• Set correct answers
• Automatically grade multiple-choice, checkboxes, and dropdowns
• Show scores instantly or later
• Add feedback for right/wrong answers

---

✅ Step-by-Step Guide: Create Auto-Grading Quiz

🔹 Step 1: Open Google Form

• Go to https://forms.google.com
• Click Blank Form or choose a Quiz Template

---

🔹 Step 2: Turn On Quiz Mode

1. Click the Gear icon (⚙️ top-right)

2. Go to the “Quizzes” tab

3. Turn on “Make this a quiz”

4. Choose grading options:

• Release grade: Immediately or Later
• Let respondents see: Missed questions, Correct answers, Point values

5. Click Save

---

🔹 Step 3: Add Questions

• Click the “+” button to add a question
• Use Multiple Choice, Checkboxes, or Dropdown for auto-grading

---

🔹 Step 4: Set Correct Answers & Points

1. At the bottom of each question, click “Answer Key”

2. Select the correct answer(s)

3. Set the points (e.g., 1, 5, 10)
4. (Optional) Click “Add answer feedback” to give messages for right/wrong answers

---

🔹 Step 5: Add All Questions & Customize

• Repeat for each question
• Add images/videos, shuffle question order, or make questions required

---

🔹 Step 6: Preview & Test

• Click the eye icon (top-right) to preview
• Submit a sample response to check scoring

---

🔹 Step 7: Share the Quiz

• Click Send and share via email, link, or embed code
• View scores in Google Forms or export to Google Sheets

How to Limit Responses or Set Deadlines in Google Forms?

Google Forms doesn’t offer native response limits or deadlines, but with some built-in settings and simple add-ons, you can still control both!

---

🔹 Part 1: Set a Deadline (Close Form After a Certain Time)

🛠️ Method 1: Manually Turn Off Accepting Responses

1. Open your form

2. At the top, click the “Responses” tab

3. Toggle off “Accepting responses”

4. You can also write a custom message like:
“This form is no longer accepting responses.”

👉 Ideal for manual deadlines like “close on June 15, 11:59 PM”

---

🛠️ Method 2: Use FormLimiter Add-on (Auto-Close)

1. Click the three dots (⋮) in the top-right of your form

2. Select “Add-ons”

3. Search for FormLimiter
4. Click Install
5. Open it from the puzzle icon 🧩 > FormLimiter > Set Limit

Then you can:

• ⏰ Close the form on a specific date/time
• 🔢 Or limit the number of total responses

---

🔹 Part 2: Limit the Number of Responses per User

Google Forms doesn't natively limit 1 response per user unless:

1. You go to Settings (⚙️)

2. Enable: ✅ Limit to 1 response

• Respondents must sign in with a Google account

📝 Note: You cannot set a “number limit” per question (like max 5 people choosing Option A) without using Google Apps Script or a 3rd-party tool.

How to Use Add-ons in Google Forms?

Add-ons are extra tools you can install to enhance the features of Google Forms — like setting limits, automating emails, adding timers, etc.

---

🔧 What Add-ons Can Do in Google Forms:

• ⏳ Set deadlines automatically
• 📩 Send confirmation emails
• 📊 Export responses to Google Docs/Sheets automatically
• 🎯 Limit responses per option
• 🔐 Add password protection
• 🧭 Shuffle sections/questions dynamically

---

✅ Step-by-Step: How to Use Add-ons in Google Forms

🔹 Step 1: Open Your Google Form

• Go to https://forms.google.com
• Create or open any form

---

🔹 Step 2: Click the “More” Menu (⋮)

• Top-right corner → click the three vertical dots
• Select “Add-ons”

---

🔹 Step 3: Browse and Install Add-ons

1. This will open the Google Workspace Marketplace

2. Search for popular add-ons like:

• FormLimiter – for deadlines & limits
• Form Notifications – send auto emails
• Quilgo – add timer and monitoring
• Certify'em – auto certificates

3. Click on any add-on and hit Install

📝 You may be asked to grant permissions.

---

🔹 Step 4: Use the Add-on

1. After installation, click the puzzle piece icon 🧩 (top of the form)

2. Select the add-on you want to use
3. Set it up according to its instructions (e.g., schedule close time, send emails, etc.)

---

🔹 Step 5: Test Your Form

• Always preview your form and check that the add-on works as expected

---

🎯 Bonus Tip:

Some add-ons require you to be the form owner and signed into a Google account with permission to install tools.

How to Analyze Responses with Google Sheets in Google Forms

When using Google Forms, all form responses can be automatically collected and analyzed in Google Sheets — allowing you to sort, filter, graph, and extract insights easily.

---

🔍 Why Use Google Sheets for Analysis?

• 📊 Sort and filter responses
• 📈 Create charts, graphs, and pivot tables
• 🔍 Perform advanced analysis using formulas
• 📥 Export data to Excel or other tools
• 🔄 Responses update in real-time

---

✅ Step-by-Step Guide: Analyze Google Form Responses in Google Sheets

🔹 Step 1: Create or Open Your Google Form

• Go to https://forms.google.com
• Open the form whose responses you want to analyze

---

🔹 Step 2: Link Form to Google Sheets

1. Click the “Responses” tab at the top

2. Click the green Sheets icon 📄

3. Choose:

• ✅ Create a new spreadsheet

• or

• 🔄 Select an existing one

4. Click Create / Select

📌 Now, all responses will be saved and synced in Google Sheets automatically.

---

🔹 Step 3: Open the Linked Google Sheet

• Click the green Sheets icon anytime to open the response sheet
• Each question becomes a column
• Each response becomes a row

---

🔹 Step 4: Analyze the Data

You can now use standard Google Sheets tools:

• Filter responses (e.g., by date, score, answer)
• Use formulas like =COUNTIF(), =AVERAGE(), =IF(), etc.
• Sort by values (e.g., highest scores, latest responses)
• Create Pivot Tables for grouped summaries
• Insert Charts (Pie, Column, Line) to visualize answers

---

🔹 Step 5: Share or Export Your Analysis

• Share the Google Sheet with others (View or Edit access)
• Export to Excel, CSV, or PDF

(File > Download > [choose format])

How to Control Access in Google Forms?

Controlling access means deciding who can view, respond, or edit your form and how many times someone can submit it.

---

🔐 Why Control Access?

• ✅ Prevent spam or duplicate responses
• ✅ Limit access to specific users or groups
• ✅ Ensure only one response per person
• ✅ Control who can edit the form or see results

---

✅ Step-by-Step: Control Access in Google Forms

🔹 Step 1: Open Your Google Form

• Go to https://forms.google.com
• Open the form you want to restrict

---

🔹 Step 2: Open Settings (⚙️)

1. Click the Gear icon at the top-right

2. You'll see three tabs:

• General
• Presentation
• Quizzes

---

🔹 Step 3: Restrict Who Can Fill the Form

In the General tab:

• ✅ Limit to 1 response
  • Only allows users signed in to Google to respond once
• ✅ Collect email addresses
  • Tracks who filled the form
• ✅ Restrict to users in your organization (if you're using Google Workspace)
  • e.g., only people with @yourcompany.com can fill it

---

🔹 Step 4: Share with Specific People (Advanced Option)

If you don’t want the form to be public:

• Click Send > Email tab
• Enter specific email addresses to send the form privately
• OR use Google Workspace Groups to send to only select departments or teams

---

🔹 Step 5: Control Who Can Edit or View Responses

Go to the Responses tab → click three dots (⋮):

• ✅ Get email notifications for new responses
• ✅ Download responses or unlink the Sheet
• ✅ Restrict editing rights:
  • Go to the Share button on the form
  • Add collaborators only if they should edit the form

Importance

I hope that you have now clearly understood all the information I provided about Google Form Advanced. If you have any doubts or questions regarding this article, feel free to let me know in the comments below. If you liked this article, please consider sharing it on your social networks.