Navigating Sign-up Options (FE Groups, Mixology, Roll Call, Meet and Greets, etc)
AKA How to Make a Google Form
When handling sign-ups for anything within your DCL sailing group, staying organized is key. There are a number of ways to do this including pen and paper, word processing document, or spreadsheet.
One easy way to stay organized is to create a google form. This allows participants to submit their own information based on prompts and parameters set by you and then the magic of google organizes the information into a spreadsheet for you. This spreadsheet can be shared with the group (in whole or part) and submitted if needed to DCL. Making a sign-up form for FE Groups, Mixology (or other private tasting events), Roll Call, Meet and Greet, etc is a great way to gather and organize the information you need.
How to create a google form:
1. You must have a google acct to create a google form.
2. I use Chrome for my web browser, so these instructions are from this point of view.
3. Log into Google
4. At the top right next to the word "Images" and a circle with a bell in it, is a box with 9 small boxes. If you hover over it, it reads apps. Click on the box, and another box opens, these are your google app options. You need to click on the "Drive" option.
5. You will be on the welcome screen for google drives, and there might be a tutorial.
6. On the left, there is a button "New", click on that.
7. Scroll down to the word, "More".
8. Click Google Forms
9. This opens up a blank google form.
10. Click on the words "Untitled Form" to add the name to the form.
11. Click on the "Untitled Question" to add your first question.
12. Text Help, can be a statement to help the respondent answer the question.
13. Question Type, click on the arrow down for the text option. You can use the other options for other question.
14. Advance Setting, I don't use this option, but you can research it further.
15. Next to the word, "Done", there is Required Question, I click that box because it is needed information. IF the information is optional, don't click the box.
16. Click Done
17. For the next question, click "Add Item", then a new question opens up.
18. At the top of the form screen, on the third line down, next to "Edit Question", is "Change Theme", click this button.
19. On the right side you can scroll through the different themes, and change them when needed.
20. Next button is "View Responses" Here will take you to the excel file with your responses.21. Next button is "View Live Form", this is where you will copy and paste the form URL address.
See below is a form I create for you to view and edit to see all these steps. If you edit, please don't save it. https://docs.google.com/forms/d/1IJTeHWJEQUI8l96XGqugsrrwqNoT2zv2b2SvbAtShfA/viewform22.
Here is the responses and the link to the excel file. https://docs.google.com/spreadsheets/d/1Az-EkDoZXn5cR559gnioXFhf7D71wX7IQvA4Ejj6PhM/edit#gid=20277664823.
PLEASE DO NOT USE THIS GOOGLE FORM, THIS IS ONLY AN EXAMPLE. Please contact me if you have any questions.
How to change the privacy on your google response file:
1. On the top right side of the response excel file is a Share Button, click on the word advanced at the bottom right, click on the Privacy line “Change”, Click the circle, Anyone with a link, then save.
2. Click on the URL address, this is where the HTTP/ is, once highlighted, write click, copy, go to the body of your document, and right click and paste.
How to Save and Pin in the group:
1. To create a new file, click on the files tab, Click Create Doc, Click on the title to change the name of the document. Ex: FE GROUP List
2. In the body of the document, you are going to write a brief description, and add the link to the google form.
3. Click on the URL address, this is where the HTTP/ is, once highlighted, write click, copy, go to the body of your document, and right click and paste.
4. Scroll down to the Save button, and click to save the document.
5. In the group, on this document post in the top right hand corner is a down arrow, click, you will get four options, click Pin Post. You have pinned the FE group list in your group.
You can also, create a post, copy and paste many different links for different google forms, and then pin that post.
Google Reference Links:
This link is to the help page for creating a google form. I will also write up a step by step too. https://support.google.com/docs/answer/87809?hl=en
How to add or edit your questions:
https://support.google.com/docs/answer/2839737?hl=en
How to add a theme to your Google form:
https://support.google.com/docs/answer/145737?hl=en
How to choose a form response destination:
https://support.google.com/docs/answer/2917686?hl=en
How to send your form to respondents:
https://support.google.com/docs/answer/2839588?hl=en
How to add other people to view or edit:
https://support.google.com/docs/answer/2917111?hl=en
How to delete a form or responses: