Learn new Google Workspace Skills
I have used FormMule and some HTML tags <b></b> to make this look nice. FormMule pulls in the data from the sheet, including the data that is merged using the VLOOKUP formulas to enable the system to work and email parents on form submission.
=QUERY(assignments!A:D, "select A,C,B,D order by C")
={"Parent Email"; ArrayFormula(IF(LEN(B2:B)>0,(VLOOKUP(B2:B,contacts!B:G,5,0)),))}
={"Description"; ArrayFormula(IF(LEN(B2:B)>0,(VLOOKUP(C2:C,assignmentlist!B:D,3,0)),))}
={"Due Date"; ArrayFormula(IF(LEN(B2:B)>0, TEXT((VLOOKUP(C2:C,assignmentlist!B2:C,2,0)),"MM/DD/YYYY"),))}