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.
Смотрите видео Restrict Google Form To Approved Users онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Kulfi Software Services 11 Март 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4,12 раз и оно понравилось 2 людям.