Referencing data from multiple tables to create Google doc

Topic Labels: Automations
729 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator


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?

Thanks in advance,


1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

Can you do a lookup? Or trigger when the linked field is updated?