Pulling information from multiple sheets / check boxes in form to docs

[Karrie Anne Vitti]

I hope I explain this right.  I have the following set up:

A google form with several questions (one is a name field that has a drop down with all student names)

A google doc set up with the fields correct

A google sheet set up with TWO sheets - one with the questions from the form and one with a column  for student name, student ID, student advisor

I would like when the form is filled out and you select a student that the document gets populated with thee student's id and advisor attached to them in sheet two in addition to the other information included in the form I only seem to see a way to map to one sheet and since the first sheet collects the data and the second has the information I'm not sure if I can do this

my second issue is I have a set off statements that need to be completed:

• Admission of misinterpretation

• Admission of poor judgment, feelings, or actions

• Agreement to compromise

• Follow up

• Move on to a Problem Resolution Form

they HAVE to have check boxes in front of them and the ones selected have to be checked does anyone know if I can do this in google forms or do I have to have that on the template and manually go in after the form is created and check the boxes??

Please email me if you can help kar...@ise-ny.org

THANK YOU

[Terry Smolka]

Hi Karrie,

I can help with getting the student name, ID, and advisor onto the sheet where for populating your form.  Both Sheets must have a common unique key for each row - I usually use student ID or school email addresses, but name could work if you are sure that the names match exactly in each sheet and there are no duplicates.  

Once you have that information on both Sheets, you can use the combination of Index and Match functions to pull the student name, ID, and advisor into the first sheet.  That information then becomes available to you, though in the Sheet, not in the form.  This document explains how to do this very well.  I usually build from the inside out - get Match to work, then add Index.  

This is really useful.  I find I often have information from two sources where I require information from both sources.

Let me know if you have any questions!

----------------

Terry Smolka

Instructional Technology Specialist

Concord-Carlisle Regional High School

email:  tsm...@concordcarlisle.org

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/981e66fd-e285-44db-9744-3905eed42f7d%40googlegroups.com.

Note: All email correspondence to and from this address is subject to public review under the MA Public Records Law. 
As a result all messages may be monitored by and disclosed to third parties.