Pulling in variables from a spreadsheet or other external data source

0

We’d like to be able to assign a study ID from a pre-specified list of IDs during the administration of a survey.  For example, there is an external data source (spreadsheet, or whatever) with a list like

ATL-01-003

ATL-01-004

ATL-01-005

As sequential participants take the survey, the next available ID from the list would be assigned.

I thought a remembered a function like this in SG from years ago — does this exist, or ideas for a workaround if it’s not a supported function?

Thanks

Dominic Sharpe answered
    0

    You might consider the Login Action:

    https://help.surveygizmo.com/help/article/link/login-password-action

    One option for login is to upload a spreadsheet of passwords (this could be from your pre-specified list). Respondents would need to type these in.

    Another option (perhaps easier to implement) would be to utilize URL variables to pass in the study ID into the survey.

    For example:

    www.yoursurveylink.com?studyid=ATL-01-003

    SurveyGizmo has several pre-population options described here (perhaps one of these will provide a good solution):

    https://help.surveygizmo.com/help/article/link/get-data-into-a-survey-through-prepopulation

    I hope this gives you some ideas

    Dominic Sharpe answered
      ×

      Login

      Question stats

      • Active
      • Views396 times
      • Answers1 answer
      • Followers1 follower