Questions on Google Drive Survey/Poll

jana
jana used Ask the Experts™
on
Hi,

I was told that Google Drive has an option to create Survey/Poll and even send to individuals so they can take it.  Some question for those expert who have worked with this tools:

  • The data that users fill out in a databases?
  • Are there reports for this database?
  • Can I export the survey/pool?
  • When creating a survey/poll, can I insert formulas if needed?
  • Any remarks on the tool?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
It is a basic poll - no database goto google docs / forms and create it once done you can download a csv of the responses
https://drive.google.com/file/d/12jka-8yIkJoVhwJzIbJD-HbKCaVqrv1Y/view?usp=drivesdk
Martin NguyenHelpDesk Technician
Distinguished Expert 2018
Commented:
Neat video David.

That shows the functionality of how to set up a Google Form and what it looks like for the end user. You can set up the Form to have its responses saved into a Google Sheet or you can save it as a CSV like David mentions.

Google doesn't do any reporting or have native reporting tools, but you can do data analysis with the Sheet or CSV.

What do you mean by export? The Form would just exist and you can send out links so users can fill it out. The data can be exported into whatever a Google Sheet can be exported as (Excel, CSV, openoffice, etc).

What kind of formulas were you thinking about? Were you going to use responses from one question in a different question? You can edit formulas in the resulting Sheet/csv.

Overall, its a provides an easy way to create basic surveys to send to users. I have not used it for more "power user" type tasks, so I'm not sure I'm totally doing it justice. If you mention what kind of functionality you're hoping to get another expert or myself might be able to answer.

Author

Commented:
Thanx David, goof vid.

Thanx Martin, as for you question,
  • What do you mean by export?
u answered it with "exist and you can send out links", thanx![/list]
  • What kind of formulas were you thinking about?
formula or condition so a pathway of questions can be done (for example, if female, then ask questions directed to females - something like that)

My questions are simple, with the info u guys provided helps a lot - just wanted to  if I can place conditions so a the next questions be dependent on that answer.

Finally, if u guys can, what other survey/poll apps (maybe free) u guys know about that can be considered?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Martin NguyenHelpDesk Technician
Distinguished Expert 2018

Commented:
off the top of my head I know of surveymonkey.

I'll look into forumlas for branching questions later today

Author

Commented:
Thank u!
Martin NguyenHelpDesk Technician
Distinguished Expert 2018
Commented:
Hiya jana,

So you create branching surveys based on responses to Multiple Choice or Dropdown selection questions.

Before I get to the screenshots etc, a little explainer. In Forms questions can be grouped into "Sections." Under each "Section" you can have multiple "Questions."

 100119-forms-1.PNGIn this screenshot I have Section 1 titled called "animals." The first question is a multiple choice question, I clicked on the 3 dots at the bottom of the question and selected "Go to section based on answer." Here you can see if they select "cats" they will be taken to the cat Section, if they select "dogs" they go to dog Section.

100119-forms-2.PNGHere is a screenshot of the very bottom of the dog Section, and the entire cat Section. You can see for both sections after they complete that they will be taken to Section 4 "do you like reptiles?"

This way you can ask Multiple Choice/Dropdown questions and then direct them to a specific section/branch of questions based on their answer. Something that might be a bit confusing is when you create a new section there are no questions that section for some reason. In David's video it highlights the Plus symbol you can click to add a question to a section.

Author

Commented:
Thank u very much! More than enough to keep me going!
Martin NguyenHelpDesk Technician
Distinguished Expert 2018

Commented:
Great! Glad to help :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial