I am trying to send variables from other parts of my title to a Google Drive spreadsheet along with the test results, but the Include ALL Variable Values check box is grayed out whenever Google Drive is selected.
Is there any way to send all of the variable values to a Google Drive spreadsheet? Is there another method of sending variables to a Google Drive spreadsheet without using the Results Submission from a test or survey?
What I did to get round this was to add entry fields to my form for each additional variable I wanted to include from else where in the course. I then used the onshow action at page level to set the contents of these entry fields to the variable. These additional fields were of no use to the page they were on so I set the visability to them to initially hidden. That way the data becomes part of the form being submitted but is not visible on the page.
There might be a simpler way to do this, but this method works for me.