Solved

How do I use embedded data to calculate tenure based on the response date?

Forum|Forum|1 year ago
February 7, 2024
5 replies
168 views

+7

BetterB
Level 2 ●●

Hi All! I am looking to calculate tenure (based on embedded data coming from SFDC) for a customer that responds to a survey. The format of the date is Year-Month-Day. I don’t have a ton of experience with custom coding. Any help or guidance would be greatly appreciated!

Best answer by TomG

No ‘var’ is a JavaScript command that declares variable names. Don’t change it. I did have the year token wrong. It should be:

Qualtrics.SurveyEngine.addOnload(function() {
	var DateTime = luxon.DateTime;
	var startDate = DateTime.fromFormat("${e://Field/SFDC}","yyyy-MM-dd");
	var tenure = DateTime.now().diff(startDate, ['years','months']).toObject();
	Qualtrics.SurveyEngine.setEmbeddedData('tenure',tenure.years);
});

+27

TomG
Level 8 ●●●●●●●●
Forum|Forum|1 year ago
February 8, 2024

@BetterB,

You can use JavaScript and the Luxon library.

Add Luxon to your survey header in source mode:

<script src="https://cdn.jsdelivr.net/npm/luxon@3.4/build/global/luxon.min.js"></script>

Add JS something like this a question:

Qualtrics.SurveyEngine.addOnload(function() {
	var DateTime = luxon.DateTime;
	var startDate = DateTime.fromFormat("${e://Field/SFDC}","YYYY-MM-dd");
	var tenure = DateTime.now().diff(startDate, ['years','months']).toObject();
	Qualtrics.SurveyEngine.setEmbeddedData('tenure',tenure.years);
});

Like

+7

BetterB
Author
Level 2 ●●
Forum|Forum|1 year ago
February 13, 2024

Thank you @TomG! This is very helpful. Do I have this correct? I added the embedded data as “var.” Should I be inserting something for this "${e://Field/SFDC}"?

Like

+27

TomG
Level 8 ●●●●●●●●
Answer
Forum|Forum|1 year ago
February 13, 2024

No ‘var’ is a JavaScript command that declares variable names. Don’t change it. I did have the year token wrong. It should be:

Qualtrics.SurveyEngine.addOnload(function() {
	var DateTime = luxon.DateTime;
	var startDate = DateTime.fromFormat("${e://Field/SFDC}","yyyy-MM-dd");
	var tenure = DateTime.now().diff(startDate, ['years','months']).toObject();
	Qualtrics.SurveyEngine.setEmbeddedData('tenure',tenure.years);
});