How to reference a Typing Tool?

GeoffKGeoffK Cincinnati, OHFounding Community Member Qubie ✭

How to reference a Typing Tool?

We have created a typing tool in excel that places respondents into 1 of 4 segments based on responses to a particular set of questions. It is very complex, so way too much to manually program in all the variations in the survey flow.

I was wondering if anyone had any ideas for how to have qualtrics reference this excel sheet in any way to automatically identify which segment the respondent has been placed into. The only thing I can think of is maybe using the "Web Service" capability in the survey flow, but I am not exactly sure how to create an external hosting page and/or how difficult that might be.

If anyone has any tips or thoughts, please let me know!

Best Answer

  • TomGTomG Raleigh, NC Wizard ✭✭✭✭✭
    Accepted Answer

    @GeoffK - You are on the right track. You would emulate the Excel formula(s) in a web service script. You can use any web scripting language - I recommend PHP. If you have programming experience, it shouldn't be difficult. You would pipe the answers from your set of typing questions as input parameters and it would return your segment as an embedded variable. You would need access to a web server that would host the script.

    If you don't have a place to host a web script, an alternative option would be to use a JavaScript to emulate the Excel forumula(s) and store the result as an embedded data field or as an answer to the question.

Sign In to Comment