I'm sending a survey to a distribution list of 100+ users.
Their time commitment at work is saved in a simple SQL table that includes columns such as username, email address, AD account, day of the week, number of hours, etc.
Ideally I would like to display the results of a basic SQL query in the text of the notification email to each user, e.g. "Dear user, your commitment last year was xxx hours". The "xxx" value would be the result of the SQL query where user = 'survey recipient'... and obviously different for each user!
Alternatively, I could display the same results in the survey itself.
I wonder if there were some code, to be included either in the notification or in the survey, where I could insert my SQL query, such as (e.g.):
--- code
Select sum (hours) from table where user = 'survey recipient'
--- code
Question: is it possible?
Please note: I heard something like "web services" and "SQL integrations"... but I have no idea how they work.
Thanks,
How to display results from a SQL query either in a survey or in the survey notification email?
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
