Creating a Table from queries of other sheets

[Brent Eldridge]

I'm trying to create a table that compiles queried info from other sheets. Each column is from a different sheet. 

I mocked it up in sheets below. The key is the Student ID. From there it queries the sheet to get the class list and then different sheets for the different grading periods, matching the grades to the class title (and Student ID). 

Student ID	37126
Student Name
	P1	Q1	P2	S1
Biology A	F	F
AVID 9A	B+	C
Algebra 1A	B+	C+
Mdrn Wrld Histry A	D	F
Phys Ed 9	A	B
Eng 9A	F	F

You can see the formulas here: https://docs.google.com/spreadsheets/d/1-xoIYqsP0DrKSwD0eAUbiDYduk0vCeT0Be2He5CFpHc/edit?usp=sharing

So in the Ultradoc I tried by loading each of the sheets using the ID to identify queried data and then making this table in the template. (I didn't include the S1 column yet). 

Class	P1	Q1	P2
$[p1grades[].coursename]	$[p1grades[].officialgrade]	$[q1grades[].officialgrade]	$[p2grades[].officialgrade]

But error messages abound. I know this is incomplete, because it doesn't match the grades to the class name; it just pulls the list that matches the id number. 

The file is here: https://docs.google.com/document/d/1ToBoJ-n91KdauR3VOxkqgvTaouvX-5SG9eOUFOpVmCI/edit?usp=sharing

Ideas?

[Daniel Florey]

You cannot display data from various tables in a single table in your template.

You'll have to create a single table containing the compiled data first.

You can either create a worksheet with the compiled data in Google Sheets or use the "Merge tables" script in Ultradox.

--
You received this message because you are subscribed to the Google Groups "floreysoft" group.
To unsubscribe from this group and stop receiving emails from it, send an email to floreysoft+unsubscribe@googlegroups.com.
To post to this group, send email to flore...@googlegroups.com.
Visit this group at https://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.