Restrict Google Form To Approved Users
I want to be able to control who enters data on a google form. What I need is to avoid that everybody is able to send data, but only users I approve
= Option 1: Google Workspace Permissions
If you have a domain account with Google, or if your organization is using Google Workspace, you can restrict form access to only users within your domain. Here's how:
Go to Google Forms.
Open your form.
Click on Settings:
Click on the gear icon in the upper-right corner.
Under the "General" tab, find the "Restrict to [Your Organization]" option.
This ensures that only users within your Google Workspace domain can access and submit the form.
= Option 2: Collect Email Addresses and Validate
Add a question to the form to collect the user's email address.
In your Google Sheet linked to the form, create a validation script using Google Apps Script.
The script can check the submitted email against a predefined list of approved users. This script checks the submitted email against the list of approved users. If the email is not in the list, it deletes the response.
The script for option 2 is here: https://docs.google.com/spreadsheets/...
If you still need help with this, you can book a 30 minute consultation and I can help you install it on your form here: https://www.fiverr.com/s/2K6vodV
= Option 3: Ask for Email Address and only show the form, if email is in your list.
Even before showing the Google Form, my script can ask for user email.
The script can check the submitted email against a predefined list of approved users. This script checks the submitted email against the list of approved users. If the email is not in the list, it shows a custom message, "You are not authorized to access this form". If the user is a valid user, s/he is shown the form and can submit it.
Watch video Restrict Google Form To Approved Users online without registration, duration hours minute second in high quality. This video was added by user Kulfi Software Services 11 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,12 once and liked it 2 people.