So, I had a coworker help me set up a Google Sheet App Script (really easy) per the information I found and have responses going into the Google Sheet (using Actions). One thing I can't find how to do is pulll in the Recorded Date (or End Date or Start Date) - but I have just been using "today's date" from the response...as that is essentially the same.
But NOW, I want to take a file upload (response) and save the file uploaded to Google Drive. Any ideas? has anyone done such a thing? Can it be done?
Best answer by
mklubeck
5 February 2020, 18:28
View original
This script was a life saver for us and unfortunately...we just went live with our qualtrics survey and my users are all bent out of shape over having quadruplicates of all data. I checked out the post referenced above but unfortunately that doesnt help alot of us. anyone know of a way to either change this response back to false from google which was harmless or a new way to run these requests?
Ooops sorry - I was on panic mode yesterday - still am but ready to face the challenge!
So typically Qualtrics made some changes in webservice recently... when you create a new one action, it looks totally different than when this post was created.
The webservice action was still working until I open the action to edit (I added a variable).
It looks when you open the action, Qualtrics automatically added Headers "application/json" and in body change to json:
I tried to changed key-value pairs to URL Encoded as the documentation in this post suggested:
But it's now showing: task setup is incomplete :-(
and nothing trigger.
When I use JSON, it looks it triggers but empty value (just space).
Hi
pscanlan_sjusd
how are you? hope you had a good weekend.
So, yes, there are now help documents in qualtrics.
Sheets:
https://www.qualtrics.com/support/survey-platform/actions-page/tasks/google-sheets-task/?parent=p001174/
and Calendar:
https://www.qualtrics.com/support/survey-platform/actions-page/tasks/google-calendar-task/?parent=p001075/
Scanning file for viruses.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
This file cannot be downloaded
Sorry, our virus scanner detected that this file isn't safe to download.
