I am creating assessments in an 'Assessments' table and then breaking these assessments into individual questions in a 'Questions table'. I am then running a script to produce a marking guide for each question.
I'd like to make the marking guide available for download as a Google doc, so essentially I want to follow this workflow:
WHEN assessment record created
CREATE Google document containing marking guide records for each question
Each question is related to a specific assessment through a linked field, but I do not want to link each question into the assessments table because this will overfill very quickly.
Is there a way to populate my Google doc with fields from the Questions table even though the trigger is the assessment record in the Assessments table?