Add Row to Google Sheets: Add response even when incomplete/in progress | XM Community
Skip to main content

I am looking to keep track of responses that are not finished in a Google Sheet. In the survey response, I have the “include incomplete responses” (see image below).

 

I have a workflow set up to gather finished responses and I would like to create a separate tab that collects the responses that have been started but not completed. Currently, I have it set up where the condition is the finished response is false (see image below).


I have also tried setting up the condition where the progress isn’t empty (assuming this means they started a response so they would have some type of progress).

Despite trying different approaches, my Google Sheet is not updating with responses that have been started (I can see their progress in the “results” section is at 11% but not finished).

 

Any tips on how I can create a workflow that will pull the incomplete responses into the Google Sheet? I would like to do this so I don’t have to manually go in everyday to pull the results for “in progress” responses.

Set a condition right at the start, that’s bound to be true. For example question 1 displays etc.

I know its annoying and weird, but that’s what Qualtrics support told me to do and it works.

@coryK The workflow is only executed for recorded responses. This means that the participant…

  • has either completed the survey (finished, 100% progress) or
  • the incomplete response was auto-completed (not finished, < 100% progress) 

The second case is only executed if you have enabled in your settings to automatically record incomplete responses after X days.

As far as I understood, you would like to include a response when it is still in progress and not yet closed. This is not possible with the workflow tab as the trigger options do not provide an option for it.

You could only try to work with a webservice element in your survey flow (e.g., directly at the start, 0%) which calls a JSON event that implements your logic.

If I misunderstood and you want to include incomplete recorded responses - is there a reason why you even have a condition? If it should only be executed for incomplete responses, Finished equals False should do it. If not, set some embedded data (e.g., End = 😵 after the last question block and use this to define your condition (embedded data End not equal 😵.

Best

Christian

Leave a Reply


Terms & Conditions