I recently created a 140+ Q training quiz with lots of complex logic for one of our clients. I am using Document Studio as an extension for Google Sheets and Google Slides to automate PDF creation and email submissions/responses. I used Google slides to create a PDF, which pulls data fields and values from Google Sheets, and creates a nice PDF that shows the question, the correct answer and user’s answer as well as a certificate of completion. This was accomplished by creating an additional worksheet/tab within the main worksheet that maps all the fields and values using the ARRAYFORMULA in Google Sheets.
HERE’S MY PROBLEM: Document Studio references the mapped fields and values but doesn’t automatically update when the main worksheet updates, resulting in users completing the training quiz and not getting their certificate and results unless I run an manual workflow every time. This is painful as I have a ton of quizzes and corresponding workflows created in Document Studio. Some of the quizzes work fine. others don’t.
