List of Eligible Users as Dropdown Options | Experience Community
Skip to main content
Solved

List of Eligible Users as Dropdown Options

  • Feb 19, 2024 9:39 PM UTC
  • 6 replies
  • 170 views

Forum|alt.badge.img+5

Hi! I am creating an always-on “suggestion box” of sorts where employees can give suggestions to other employees. For this, I envisioned a question like “Please select the employee from the dropdown menu whom you’d like to give a suggestion to.” 

The issue: The dropdown options need to be a list of all active users in our Qualtrics instance. How do I get this to work? 

Best answer by happychuck77

For posterity’s sake, I found my own solution to this:

I set up a daily standalone workflow that points to an SFTP site ( I also tested it with a Google Sheet and that works too) that updates a series of SDSs that feed Text entry questions that use the Autocomplete feature.

View original

6 replies

Forum|alt.badge.img+22
  • Level 7 ●●●●●●●
  • Feb 19, 2024 11:02 PM UTC

Unless the users are changed quite frequently, you could a static list and get people to select using it.

Alternatively, you will need a server at the backend which calls the Qualtrics API. You can call this server using the web service element to get the latest user list, each time a person starts the survey.


Forum|alt.badge.img+5
  • Author
  • Level 2 ●●
  • Feb 21, 2024 2:55 PM UTC

Thanks, @ahmedA. The kicker is that employees receiving feedback need to be able to see the feedback meant for them on either (1) a dashboard or (2) a Qualtrics ticket (we’re still deciding between options 1 and 2). So I don’t think we can do just a static list of names because these have to be tied to actual users if that makes sense.

 

I sort of get what you mean with the second solution you listed. It would have to be almost like the Qualtrics API calls the users table and pulls the entire list of users in, right?   


Forum|alt.badge.img+5
  • Author
  • Level 2 ●●
  • Answer
  • Mar 18, 2024 7:53 PM UTC

For posterity’s sake, I found my own solution to this:

I set up a daily standalone workflow that points to an SFTP site ( I also tested it with a Google Sheet and that works too) that updates a series of SDSs that feed Text entry questions that use the Autocomplete feature.


AlonsoC
Qualtrics Employee
Forum|alt.badge.img+31
  • Qualtrics Employee
  • Aug 9, 2024 6:57 PM UTC

For posterity’s sake, I found my own solution to this:

I set up a daily standalone workflow that points to an SFTP site ( I also tested it with a Google Sheet and that works too) that updates a series of SDSs that feed Text entry questions that use the Autocomplete feature.

@happychuck77, that sounds like a fantastic and interesting initiative! Any updates on how it’s going? Also, thank you for sharing your solution; it’ll greatly help out our community! 


Forum|alt.badge.img+5
  • Author
  • Level 2 ●●
  • Aug 12, 2024 2:34 PM UTC

Yes, the above solution is working perfectly. I worked with my Workday team to create a daily report of active employees that is sent to an SFTP. Then also in Qualtrics I set up a daily standalone workflow that points to the SFTP and updates a Supplemental Data Source that feeds my Text entry question that uses the Autocomplete feature.


AlonsoC
Qualtrics Employee
Forum|alt.badge.img+31
  • Qualtrics Employee
  • Aug 12, 2024 4:03 PM UTC

Yes, the above solution is working perfectly. I worked with my Workday team to create a daily report of active employees that is sent to an SFTP. Then also in Qualtrics I set up a daily standalone workflow that points to the SFTP and updates a Supplemental Data Source that feeds my Text entry question that uses the Autocomplete feature.

@happychuck77, it’s great to hear that it’s working perfectly. Thanks for sharing your successful setup—it's incredibly useful for all of us!