The survey I am conducting needs to be completed within 7 days of another task. I upload the TaskDate as an embedded item in the contact list. Is there a way to auto-calculate an expiration date for the individual emails that are sent out? Alternatively, I can auto-calculate the expiration date in the excel contact sheet, is there a way to import an expiration date into a survey link? Thanks!

I don't think you can do this in a built-in way, but you could use logic in your survey flow to handle it. I've seen some surveys where it checks after each block whether a condition is met and ends the survey if so. You would probably need to evaluate the date using JavaScript as I don't think Embedded Data has that capability. So on the first page of the survey, you could have JavaScript doing something like: ```javascriptvar expDate = Qualtrics.SurveyEngine.getEmbeddedData('customExpirationDate');expDate = new Date(expDate);if (expDate < new Date()) { Qualtrics.SurveyEngine.setEmbeddedData('expired','true');}```Then after that block you could add an if statement in the Survey Flow that says "If Embedded Data `expired` = `true` then End Survey. Consider the fact that if people enter the survey in time but then leave and return after the time, this would not catch them. You would need this logic on every page of your survey in that case.

> @AVB said:> Thanks!> > Right now I am manually entering the expiration dates when I send out the email link, but I can see this being easy to make a mistake or tedious after 100+ times. I'll see if I can get this to workThis sounds like you are distributing to each email address manually. If so, I have two suggestions:1. Create a sample based on TaskDate, then distribute to that sample. That way, you are only doing one distribution a day where you have to set the link expiration.2. Look into creating a script to use API to automate the distributions. The script could calculate the link expiration date and set it when it creates the distribution.

Is there a way to autocalculate a survey expiration date?

Is there a way to autocalculate a survey expiration date? | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded