How to Make a Signup Sheet on Google Form [Custom Signup]

how to make a sign up sheet on google forms 10

There are many ways to utilize Google Forms in daily life tasks. In this article, we will learn how to make a signup Sheet on Google Form. There is a need of signup for various occasions and events that we have in our daily life, we will use Google Forms to demonstrate how to make Signup sheet for any event registration.

What is Signup Sheet?

Signup Sheet is activity that we use to gather our relevant audience, it can be a digital activity or any physical event that we have in our schedule. Signup sheet allows people to offer their participation in a specific event or activity. Whether you need to recruit volunteers, gather teams, schedule conferences for any type of event to discuss anything, you can simply make a sign up sheet on Google Form and utilize it for registration purpose.

Why do we make Signup Sheet in Google Forms?

We make signup sheet to allow people to offer us their valuable ideas and insights on our event or activity. Signups eliminates the extra traffic of audience from our events because only interested individuals or groups will signup (there may be few who may signup for trouble making). We may also need to provide various validations in Google Forms since we do not want to receive false data for sign up details. This way, registration process can be made easy and authentic.

See also   How to Make Quiz in Google Form [Guide 2023]

How to make a Signup Sheet in Google Form?

Let us consider a simple scenario where we are going to organize a signup form to collect personal information for sending notifications and updates of our upcoming events. Using this scenario, we will collect personal information for events that will be held in the future.

Let us start demonstration on how to make a Signup Form Sheet in Google Form below.

How to create a signup form in Google Form?

In this article, we will demonstrate how to make a Sign Up sheet on Google Form. Follow the step by step procedure below to make sign up sheet on Google Form.

Make a Google Form

Step 1: Go to Google Forms website to make a new form for sign up.

how to make a sign up sheet on google forms 1

We need to make sure that we are signed in to Google account otherwise we will not be able to utilize services of Google Forms.

Step 2: Choose a template for new Google Form.

We will make a new form to make a custom made sign up sheet. Since we want to make a custom sign up sheet. We will choose “Blank” template so that we can add things as per our requirements.

how to make a sign up sheet on google forms 2

This way, new form is created and later we can add questions and other required fields to make sign up form. Our blank form is created like this:

how to make a sign up sheet on google forms 3

Step 3: Fill-in Form Name, Title and Description.

We can fill in Form Name, Form Title and Form Description as per our requirements. Form Name is visible only to the Owner, Editors or Collaborators while Form Title and Description will be visible to everyone.

We have set up form name, title and description as:

how to make a sign up sheet on google forms 3-B

Add relevant questions to the Sign Up form

As our form is ready for making relevant questions for Signup. Now, we will set up Questions according to our requirements for sign up form.

After we started with a blank form, we will setup all the questions and other related fields ourselves.

how to make a sign up sheet on google forms 4

 

First Question is a simple Multiple Choice question, 2nd and 3rd ones are Short Answer questions. To learn more about how to add questions to Google Form, read our article on How to make a google form.

Validate Email (for Google Account) in Google Forms

After setting up some basic questions, it’s time to validate email field. We only want users having a gmail account to fill our form. So we will apply validation of “@gmail.com” on the Email Address field. Let us follow the steps below for validation of email in Google Forms.

Click on the “more” icon on bottom right side of the Email Field as:

how to make a sign up sheet on google forms 5

In order to validate email, we need to setup response validation for email address field. Choose Response Validation from the dropdown shown as:

how to make a sign up sheet on google forms 6

Here, we can setup how to validate each response for this question/field.

By default, it is showing number validation. As we want to validate the text, so we will click on the caret icon beside Number.

how to make a sign up sheet on google forms 7

We can use either “Text” or “Regular Expression” for email validation. We will choose Text to setup email validation for now.

how to make a sign up sheet on google forms 8

Once we have chosen Text, now we need to setup the validation format.

how to make a sign up sheet on google forms 9

We can use both Contains or Email for email validation. “Email” will validate if the entered response is an email. And Contains will check for a specific entry in the entered response. For our scenario, we only want gmail users to submit the form. So we will use contains as shown below:

how to make a sign up sheet on google forms 10  

Email option would have been easier in a sense that we would not have to provide any more details to the Google Form.

Since we chose contains, now we will check if the response contains with specific domain of gmail as:

how to make a sign up sheet on google forms 11

We can choose our required domains with “text -> contains” (which we can’t if we choose email). If we need to limit the response to only specific domains of email e.g. Gmail Account, etc. Also, we typed the Error Message above which will show up if the responder submits an invalid email or an email that does not contain “@gmail.com”.

Validate Contact Number in Google Forms

We can also do the validation for contact number. Since different countries have different country codes and we do not want to limit the registration to only 1 country so we will not validate country code.

Click on more icon and choose Response Validation.

Now, we will only validate that the entered response in this question is a Number as shown below.

how to make a sign up sheet on google forms 12

The same procedure as “Validate Email” (shown above) is used for number validation as well.

Preview the Sign Up Form in Google Forms

As our signup form is ready, we will preview it first before sharing with the required public. After the form is created, it’s a great practice to test it for any problems or inconsistencies before making it public. To test our forms, we can use preview icon as:

how to make a sign up sheet on google forms 13

With this button, we can preview our form as responders would see it.

how to make a sign up sheet on google forms 14

We can see all fields as we designed it. We are not currently signed it, so Google Forms will prompt for sign in as above.

how to make a sign up sheet on google forms 15

Let us try with different domains to ensure our email field validation and tried text with contact number and we can see that both the fields are working as required.

how to make a sign up sheet on google forms 16

We can fill up the sign up form as above and submit it when it is done.

See also  How to Get Email Notifications from Google Forms

Important Notes

  • We must have a Google Account in order to create and make a Google Form. Without having a Google Account, we will not be able to make use of Google Forms.
  • You can find the preview button on top right corner of the Google Form. It may change depending on screen resolution so if you can’t find preview button click 3 dots and choose it from there.
  • We should always limit the Google Form for signup to “1 response per email” as we want to register or sign up a person only once.

See also  How to Make a QR Code for a Google Form [Complete Guide]

Frequently Asked Questions

Can we limit Signup with Google form?

Yes, we can limit sign up to 1 from Setting but it will require Google Account sign in for every sign up registration on our form.

how to make a sign up sheet on google forms 17

Is it possible to send Signup information to respondents?

Yes, it is possible to send the information back to the responders for safe keeping. It is good way to keep a record of information stored in email address as well. To do that, do the following settings.

how to make a sign up sheet on google forms 18

We can easily send them copy of their Signup with turning on these setting and sending copy of their response to always. Like this:

how to make a sign up sheet on google forms 19

Copy of response will be sent to email address like this:

how to make a sign up sheet on google forms 20

We made “Email” and “Email address” as different fields, Email (At the start) is a field Google form created itself when we required email for form submission and to send copy of response. Email address field is the one we will use to validate email and send notifications and alerts for events and in turn, the sign up process.

Conclusion

In this article, we discussed that we may need to make sign up sheets in Google Forms if we want to make registration process online or create a signup sheet for events, etc. We need to go through the following steps to make a Sign Up Sheet on Google Forms:

  • Make a Google Form
  • Add relevant questions to the Sign Up form
  • Validate Email (for Google Account) in Google Forms
  • Validation of Contact Number in Google Forms
  • Preview the Sign Up Form in Google Forms

Thanks for reading!

Content Protection by DMCA.com

Widad Khan

Hi, I am Widad Khan. I was born and raised in Pakistan. I have always loved the field of Computer Sciences and since I was a kid, I would say I wanna grow up to be a scientist, now this term is mostly related to "Computer Scientist" and not scientist alone. I am pursuing my Bachelor Degree in Computer Sciences from GCU, Lahore. I have always loved keeping records of different types of data. Earlier, I would use MS Excel for that. But with the advancements in Google Sheets, my work has become much easier. And also it's very easy to share and coordinate data with fellows and coordinates.

We will be happy to hear your thoughts

Leave a reply

OfficeDemy.com
Logo
Enable registration in settings - general